Syntax error in INSERT INTO statement.

I'm getting this error..

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

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

/v4/gy/adddb.asp, line 29


with this code..

@ Language=VBScript
Option Explicit



dim MyConn, sql, strdate, strlarg_img, strsmall_img, strauthor, stremail, strcat
%>




strdate = Request.Form("date")
strlarg_img = Request.Form("larg_img")
strsmall_img = Request.Form("small_img")
strauthor = Request.Form("author")
stremail = Request.Form("email")
strcat = Request.Form("cat")

'build up first INSERT
sql = "INSERT INTO gallery (date,larg_img,small_img,author,email,cat) values("
sql = sql & "'" & strdate & "',"
sql = sql & "'" & strlarg_img & "',"
sql = sql & "'" & strsmall_img & "',"
sql = sql & "'" & strauthor & "',"
sql = sql & "'" & stremail & "',"
sql = sql & "'" & strcat & "')"

'execute first statement
myConn.execute sql


'clean up
set myConn = nothing


I tried to add [] around gallery but I still came up with the same error.

I don't see anything obvious. If you happen to have a single quote as part of one of the request strings, it would cause a syntax error.

Best bet is to output the SQL string after it's been pieced together and see if the final string is what you expected.

I had to change "date" to "gdate" in the db. I guess "date" is a reserved statement.