Using NOW() in INSERT statement

[cwolgamott]

Hello. I am building an asp page where I am trying to insert values into a database table. I believe that I may be having difficulty inserting NOW() into a field. I was wondering if that is how I should be inserting the current date and time into a field. Secondly, I am getting the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'VALUES'.

That error message is coming from the following code:

SQL = " INSERT INTO CaseInfo (CaseInfo.casenum, CaseInfo.caller, CaseInfo.subject, CaseInfo.description, CaseInfo.openedby, CaseInfo.dateopened, CaseInfo.daterequested, CaseInfo.dateneeded, CaseInfo.dateestimated, CaseInfo.iscompleted, CaseInfo.respondedto, CaseInfo.percentcomplete, CaseInfo.status "
SQL = SQL + "VALUES (" + CStr(newCaseNumber) + ", " + "'" + inputFullName + "', " + "'" + Request("subject&quot + "', " + "'" + Request("description&quot + "', " + "'" + "INTRANET" + "', " + "NOW()" + ", " + "'" + CStr(Request("date1&quot) + "', " + "'" + CStr(Request("date1&quot) + "', " + "NOW()" + ", " + "'" + "N" + "', " + "'" + "N" + "', " + "0" + ", " + "'" + "NOT STARTED" + "')"
conn1.Execute(SQL)

I would greatly appreciate any suggestions. Thank you.

 

[cbokowski]

1st you are missing the &quot" in the first sql chunk.

2nd you can use the GETDATE() from sql server I am not sure that you gain anything, but if your db and iis are on diff boxes you could potentially have problems if the times on the servers go out of sync.

hth

 

[cwolgamott]

Thank you so much for your reply. I greatly appreciate it.