actually it is a numeric. It has to be the drivers since I converted the DB to MySQL and Rant eh same code and it worked just fine.
-----Original Message----- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 1:22 PM To: CF-Talk Subject: RE: Access & CMFX 7 Is that field in the database actually a bit field, or yes/no field in Access? Just a thought. Not sure setting integer vs bit in cfqueryparam would matter in this instance. -------------------------------------------------------- Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: www.ejhassociates.com tel: 651.207.1526 fax: 651.207.1536 mob: 952.210.9060 -------------------------------------------------------- This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not [email protected] you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -------------------------------------------------------- -----Original Message----- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 10:47 AM To: CF-Talk Subject: Access & CMFX 7 I have a simple Insert query that is throwing an error on CFMX 7. I have validated that all the form fields are there and properly set as needed. 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> I have validated that all fields are specified correctly for the data types. The query runs just fine if I ran it in MS Access. However in CF7, it Indicates there is a syntax error in the INSERT query. The line that it references is this line: <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" VALUE="#form.acctstatus#"> The value of the form variable is 1. Error Executing Database Query. Syntax error in INSERT INTO statement. Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227635 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
