Date Problem

[discusmania]

guys,

What's my problem actually

this is my code in asp
strinsert="insert into score (badge,score,qid,date) "&_
" values('"&badge&"',"&score&","&qid&",#" & Date() & "#)"

this is the error:

insert into score (badge,score,qid,date) values('12319',3,1,#6/1/2004#)
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/dept/amt/software/quiz/quizall.asp, line 97


regards,Nor

 

[willir]

discusmania

I am not sure you have resolved your problem.

Date is a reserved word. I would be a bit concerned about using Date for a field name.

 

[Gwena]

How About this:
strinsert="insert into score (badge,score,qid,[date]) "&_
" values('"&badge&"',"&score&","&qid&",#" & Date() & "#)"