Or just put [] around it to see if its your problem... eg [PASSWORD] ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----Original Message----- From: Ken Ketsdever [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 1:34 PM To: CF-Talk Subject: RE: Access & CMFX 7 PASSWORD - is a reserved word. In earlier versions of CF it didn't matter as much when using Access. Try changing your field name and see what happens. ************************************************************************ ***** Here is the insert query: <CFQUERY NAME="qAddMemberInfo" DATASOURCE="#REQUEST.DSN#"> INSERT INTO MEMBERS ( FIRSTNAME, LASTNAME, COMPANYNAME, EMAILADDRESS, PHONENUMBER, USERNAME, PASSWORD, LOGINS, ACCTSTATUS ) VALUES ( <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.firstname#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.lastname#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.companyname#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.emailaddress#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.phonenumber#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.username#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#form.password#">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" VALUE="0">, <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" VALUE="#form.acctstatus#"> ) </CFQUERY> Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
