Date issues

[ifeyinwa]

below is my script in asp which works well and updates my access dtabase table, BUT [ SQLStmt = SQlstmt & "CCDATE=#" & Now & "# "] This piece does not update with the date. Am I missing a quote or.....
Thanks as always,
Ify



SQlstmt = "Update BILLTABLE Set "
SQLStmt = SQlstmt & "COMMENTS ='" & Replace(Strpriorcomments,"'","''") & " " & vbcrlf & Replace(Strcomments,"'","''") &"-" & Strtrace &";" & "',"
SQLStmt = SQlstmt & "CCDATE=#" & Now & "# "
SQLStmt = SQlstmt & "Where BILLNO = '" & StrbillNo &"'"
Conn.Execute(SQLStmt)

 

[PaulBricker]

What do you have that vbcrlf in there for. This is what the line looks like with that in there

Update BILLTABLE Set COMMENTS ='
-;',CCDATE=#8/12/2008 11:03:52 AM# Where BILLNO = ''

That breaks up the sql statement into to lines that are probably not being read properly. Try it without that.


Paul

 

[PaulBricker]

Also, you have a semi colon before the CCDATE line. That may be mucking up the works as well.

Paul