Your error message should have your entire SQL statement that was attempted. Copy the SQL statement and paste it into MS Access and see if you can run it from there. Run it against the actual MS Access database. If it bombs in MS Access you might get a better understanding from Access' error message what the problem is.
Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gaddy David Sent: Wednesday, July 27, 2005 10:30 AM To: [email protected] Subject: Inconsistant SQL syntax error Anyone see this before? Code operates perfectly in DEV env, but in production bombs with "Syntax error in INSERT INTO statement". Identical datasources (MS Access) both boxes running MX7. Here's the SQL: <cfquery datasource="ff" name="add2users"> insert into users(username, password, fname, lname, customer, admin) values('#form.username#','#form.password#','#form.fname#','#form.lname#' ,2,0) </cfquery> Is "users" a reserved word in some environs? I know that "user" is. Strange stuff. Thanks, David ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
