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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.