Search results for query: *

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

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

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

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

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

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

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

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

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