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 wOOdy-Soft 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: *

  • Users: llaurit
  • Content: Threads
  • Order by date
  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

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