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:227640
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
