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
