Recent content by tmishue

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...

Thanks for the suggestions. Here's what I tried and still no record is added to my database. <% internala = Request.Form(&quot;internaltxt&quot;) froma = Request.Form(&quot;fromtxt&quot;) categorya = Request.Form(&quot;categorytxt&quot;) locationa = Request.Form(&quot;locationtxt&quot;) rooma...

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(&quot;Catlstbx&quot;) 'Catlstbx is the listbox on ASP1.asp strSQL= &quot;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 ;-)