sql line format

[clientuser]

I keep getting this line is setup wrong:

strSQL = "INSERT INTO maillist_members " & "(FirstName, LastName, Email, listID) VALUES " & "('" strFirstName & "', '" & strLastName & "', '" & strEmail & "', " & "' & intListID & "')" & ";"

getting:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/mailinglist2/subscribe_process.asp, line 31

strSQL = "INSERT INTO maillist_members " & "(FirstName, LastName, Email, listID) VALUES " & "('" strFirstName & "', '" & strLastName & "', '" & strEmail & "', " & "' & intListID & "')" & ";"
-------------------------------------------------------------------------------------------------^

 

[senadaulay]

Try This:

strSQL= "INSERT INTO maillist_members (FirstName, LastName, Email, listID) " & _
"VALUES('"&strFirstName&"','"&strLastName&"','"&strEmail&"',"&intListID&");"

Hope it will help you.

 

[clientuser]

sorry but i get the same error:

strSQL= "INSERT INTO maillist_members (FirstName, LastName, Email, listID) " &_
"VALUES('"&strFirstName&"','"&strLastName&"','"&strEmail&"',"&intListID&");"
	objConn.Execute (strSQL)

 

[senadaulay]

What database do you use? I assume name of the fields are correct right and the order of the field Has to be
the same as the one in your table?

Try to put
Response.Write(strsql)
Response.End

Maybe this Link could also help you.

http://www.adopenstatic.com/faq/80040e14.asp

 

[DreXor]

looks like broken line continuance issues, pretty common, there's a few ways to get it to work, try formatting the string like this :

strSQL= "INSERT INTO maillist_members (FirstName, LastName, Email, listID) "_
&"VALUES('"&strFirstName&"','"&strLastName&"','"&strEmail&"',"&intListID&")"

objConn.Execute (strSQL)

end quote, underscore, no space, and nothing other than carriage returns and spaces until ampersand open quote continue.....

also i removed the trailing semicolon, it's common for access DB's but not necessary, and not typically "liked" by SQL, just a minor habit i've removed from my standard practices, to ease headaches.


DreX
aKa - Robert