Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tmishue

    Database connection to SQL Database

    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 =...
  2. tmishue

    Database connection to SQL Database

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

    Problems Adding Records

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

    DTC Label value won't pass

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

    DTC Label value won't pass

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

    Problems Adding Records

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

    Problems Adding Records

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

    Problems Adding Records

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

    RecordsetNavBar with Parameterized queries

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

    DateTimePicker Control Getting the Value

    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 *:->*
  11. tmishue

    DateTimePicker Control Getting the Value

    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 =...
  12. tmishue

    how do i call a field of a form on the current page, within ASP code?

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

    how do i call a field of a form on the current page, within ASP code?

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

    how do i call a field of a form on the current page, within ASP code?

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

    Time Conversion

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

    Time Conversion

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

    how do i call a field of a form on the current page, within ASP code?

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

    Forms Question

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

    Forms Question

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

    Forms Question

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

Part and Inventory Search

Back
Top