garenk — Mon, 30 May 2005 16:59:12 +0000

I have found a workaround to the problem. I changed the boolean fields to text fields. They now work fine. Thanks everyone for your help.

dhotchin — Mon, 30 May 2005 15:29:11 +0000

Usefull site: http://www.xlinesoft.com/asprunner/docs/error_syntax_error_in_insert_into_statement.htm

I think "Pin" is a reserved word. Try another word in your database.

chrishirst — Mon, 30 May 2005 15:21:36 +0000

it's the output of the SQL string that will show the error

garenk — Mon, 30 May 2005 15:04:04 +0000

Line 26 is where the error occurs. The first "Conn.execute SQL".
The last two variables are boolean variables. They don't require single quotes.

Here is the SQL string that might be causing the problem:

SQL = "insert into Users ([FullName],[Pin],[Assettag],[MachineType],[LaptopHomeConnect],[SecPCHomeConnect])" & _
" values ('" & toSQLString(Request("FullName")) & _
"','" & toSQLString(Request("Pin")) & _
"','" & toSQLString(Request("AssetTag")) & _
"','" & toSQLString(Request("MachineType")) & _
"'," & toSQLString(LapHomeConn) & _
"," & toSQLString(SecPCHomeConn) & _
")"

Let me know if this is sufficient. Thanks again for your help.

chrishirst — Mon, 30 May 2005 14:43:38 +0000

1/ Which line errors out? there are two executes in there

There looks to be some ' (single quotes) missing on the last two variables in the first insert

write out the SQL string and post that