SQL Insert Statement

[Mike Mueller]

I am having problems implementing an Insert statement.
Here is the code:
strSQL3 = "INSERT INTO Usage (User, TimeStamp) VALUES ('"&
strUserName &"', (Now ()))"

Here is the error message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement.

/secure/validate.asp, line 29

Haven't gotten farther yet on this, but how would I execute
this? Would I just call up that variable or ???

TIA

Mike

 

[Carmen]

One too many close brackets .

strSQL3 = "INSERT INTO Usage (User, TimeStamp) VALUES
("& strUserName &", Now ())"

 

[Carmen]

Oops. Messed up your variable on the last reply.

strSQL3 = "INSERT INTO Usage (User, TimeStamp) VALUES
('"& strUserName &"', Now ())"

 

[Mike]

Tried it and failed. Still getting a syntax error. Here
is the page in question
www.lannonfire.com/secure/login.asp
use test for username and password

 

[grw]

timestamp is a reserved word, use [timestamp]

Tried it and failed. Still getting a syntax error. Here
is the page in question
www.lannonfire.com/secure/login.asp
use test for username and password

 

[carmen]

Sorry, was out of the office for a few days.

Make your TimeStamp variable strTime, then try it like
this:

strSQL3 = "INSERT INTO Usage (User, strTime) VALUES
('"& strUserName &"', Now ())"

 

[grw]

strTime would be treated as a column name, not a variable