Search results for query: *

Still get the same error when running debug and my record is still not added. Here's what I did changing the bolded line as you suggested: Set CCSCal=Server.CreateObject("ADODB.Connection") CCSCal.ConnectionTimeout=40 CCSCal.Open "DSN=CCSCalendarSQL" sqlStatement =...

Hey Everyone, Need help with this database connection in ASP. I am getting the following error on the line that is in bold below: An exception of type 'Microsoft OLE DB Provider for ODBC Drivers:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'calendarinfotable'.'was not...

I figured out what I was doing wrong. I added my SQL text to my DTC Recordset onbeforeopen event and the record was added. Thanks for all your time and effort in helping me. I truly appreciate it! tmishue

Addition to my problem: If I hide my textbox then I can not pass the value of it to me Second.asp. Is there a way to work around this? Thanks again! tmishue

Hello, Just wandering if anyone knows why this doesn't work? fieldlabel.setCaption(fieldonform1) when i submit I thisForm.action = "Second.asp" thisForm.submit Second.asp field = Request.Form(fieldlabel) - fieldlabel is not passed and field = "" does anyone know why I...

I wrote the SQL Statement to the asp page and my variable are being passed correctly. Here is what the statement looked like on the asp page. INSERT INTO calendarinfotable(DepartmentSchool, Category, Subject, Room, Location, StartDate, StartTime, EndDate, EndTime, Intranet, Toemail...

...strconn="driver={SQL Server};server=beta1;uid=sa;pwd=;database=calendarinfotable;" oconn.Open(strconn) strsql = "Select * from calendarinfotable" Set ors = Server.CreateObject("ADODB.Recordset") ors.ActiveConnection = oconn ors.CursorLocation = 3'adUseClient...

Hey, I am trying to add a record to my SQL database. I am using MS InterDev to create my ASP pages. I have a form in which the user inputs the info, then they click to submit the information. When clicking submit they are directed to my Conf.asp which contains the code to add the new record...

giorgioc, Try going into the properties of your DTC Recordset to the Implementation Tab and select to Preserve your Recordset in Session State. It worked for me. I was having the same problem and your question helped me to find out what was happening. Thanks tbmishue

Thanks soo much TazzMan! Your right I had set the ID but not the name. Once I set the name as you suggested everything worked beautifully!!!! Thanks for the fast and helpful response. tbmishue *:->*

Hey, I have a form containing the DateTimePicker Control. When I click the submit button I need to access the value of the datetimepicker control and the process.asp page. I have tried the following: On the onchange event stdte = datetimepicker.value and in the process.asp doing stdate =...

I haven't every used this method, but I did get it from the Help with Visual Studio. Maybe you can use it. Listbox DTC help. getValue Method Returns a value from an object. Syntax object.getValue([nIndex | strField]) Parameters object A script object. nIndex Index of an item in...

Sounds like your are trying do so something similiar to what I have here? Sub CatRecordset_onbeforeopen() cHoldcat = Request("Catlstbx") 'Catlstbx is the listbox on ASP1.asp strSQL= "SELECT Subject AS Subject, StartDate AS [Start Date], StartTime AS [Start Time] FROM infotable...

Do you mean a list box? Can you give a little more info about your situation? tbmishue

Thanks for the fast responses and all your help. I got it working. tbmishue ;-)

Can anyone help me? I have a form in which users enter a time in timetextbx. I have an option box to select AM or PM. I need to convert the value in the timetextbx to military time if PM is selected then conver it into DateTime format using the CDate function. Does anyone have any...

I've done a something similiar by setting the SQL text to a DTC recordset by a value passed by a form. But I am really not sure about the code for your sqlstring because I am really new to sql. I do know however that you can get the value of a field on a form on a previous page by doing the...

I figured it out. <SCRIPT ID=clientEventHandlersVBS LANGUAGE=vbscript> Sub retbtn_onclick() history.go (-1) End Sub </SCRIPT> Thanks Sooooooo much for your help. You have no idea how much stress you saved me. Thanks again, tammym

I like the history.back () idea but I can't get it to work. Here is my code for the button, I'm really new to ASP and vbscript can someone help me with what I am missing. Thanks, tammym <SCRIPT ID=clientEventHandlersVBS LANGUAGE=vbscript> Sub retbtn_onclick() thisform.action= history.back...

I have a form on ASP1.asp when the form is submitted I do some validation on ASP2.asp. In the event that there is an error with the user input I want my ReturnToForm.btn to direct the user back to the form on ASP1.asp with all the information that they have already input in. When I do...