Not truly sure since it is on a hosted platform (another provider) -----Original Message----- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 12:06 PM To: CF-Talk Subject: Re: Access & CMFX 7
Dumb question, what driver are you uising to connect to the DB? On 12/23/05, Adkins, Randy <[EMAIL PROTECTED]> wrote: > > 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:227616 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
