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 Chriss Miller 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. llaurit

    Default Date Problem

    I am putting information from an InterDev webpage into a SQL database. The SQL db has datetime for the datatype of one of my fields. When I insert info to the SQL db, it automatically fills in "1/1/1900." It always does this when I leave the text box empty and sometimes even when I...
  2. llaurit

    Recordset won't execute

    Thank you for the tip, but I ended up switching my method for adding the data. Lynn
  3. llaurit

    Recordset won't execute

    I created a connection in vbScript to a SQL database. I set parameters to update the table. I used these settings: objCmd.CommandText = sp_name objCmd.CommandType = adCmdStoredProc When I use "cmdObj.execute," I get the following error: Microsoft OLE DB Provider for ODBC Drivers...
  4. llaurit

    Creating parameters in vbscript

    I am using SQL Server 7.0 to store my data and using Visual InterDev as the user interface on the Internet. Is this what you were asking about?? Lynn
  5. llaurit

    Creating parameters in vbscript

    I did try including the adovbs.inc file and I am still getting an error. The underlying data type in SQL is "numeric." Thanks for the reply! Lynn
  6. llaurit

    Creating parameters in vbscript

    I am trying to create a parameter for a SQL field in Visual InterDev. Set tmpParam = addrequest.CreateParameter ("@uid", adInteger, adParamOutput, 16, uid) I keep getting the error: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in...
  7. llaurit

    Entering the date into a sql script

    Ray, my problem was that I couldn't have "Date" as the field name in my db. Once I changed that the CDate and # format worked. Thanks! Lynn
  8. llaurit

    Entering the date into a sql script

    I tried using the CDate and I still got an error. Thank you anyway!! Lynn
  9. llaurit

    Entering the date into a sql script

    I am trying to take a date/time field from a database. This is the code that I have been using. I know everything works except for the date format. Please let me know what the correct format is. Thanks! strAddNew = "INSERT INTO tblLog (Date, StartTime, EndTime, CustomerID, Employee...

Part and Inventory Search

Back
Top