Could be...I have two dollar format values in there. I'll see about stripping the dollar formatting before the query and see if that helps...
Thanks, Rick > -----Original Message----- > From: Cesana, Paolo [mailto:[EMAIL PROTECTED] > Sent: Friday, October 14, 2005 9:43 AM > To: CF-Talk > Subject: RE: What could be wrong with this query? > > > How about a comma in a numeric value returned by a cfqueryparam > statement? > > Paolo Cesana > Principal Software Engineer > > > > Eagle Global Logistics (EGL) > 1801 NW 82 AVE > Miami FL 33126 > Phone: (305) 594-0038 Ext 7326 > Fax: (305) 593-0431 > > Mailto: [EMAIL PROTECTED] > http://loginet.eaglegl.com > http://www.eaglegl.com > > "Electricity is not the result of a series of upgrades to the candle" > Auth. unknown > > > > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Friday, October 14, 2005 9:36 AM > To: CF-Talk > Subject: What could be wrong with this query? > > > Good morning...(or afternoon, evening, etc...) > > I'm getting a MySQL error returned that says the Column count does not > match the value count on this query... > > I've tried outputting all the form values and everything looks correct. > > Does anyone see anything wrong with this query that I'm missing? > > Thanks for the help... > > Rick > > > <CFQUERY Name="InsertAccount" Datasource="#DSN#"> > > Insert into accounts > > ( > Client_ID, Company_ID, Account_Type, Account_Number, > Issue_Date, Face_Amount, Premium, > Payment_Mode, Policy_Notes > ) > > Values ( > <cfqueryparam cfsqltype="CF_SQL_INTEGER" > Value="#Form.Client_ID#">, > <cfqueryparam cfsqltype="CF_SQL_INTEGER" > Value="#Form.Company_ID#">, > <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > Value="#Form.Account_Type#">, > <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > Value="#Form.Account_Number#">, > <cfqueryparam cfsqltype="CF_SQL_DATE" > Value="#DateFormat(CreateODBCDate(ParseDateTime(Form.Issue_Date)), > 'M/D/YYYY')#">, > <cfqueryparam cfsqltype="CF_SQL_DECIMAL" > Value="#Form.Face_Amount#">, > <cfqueryparam cfsqltype="CF_SQL_DECIMAL" > Value="#Form.Premium#">, > <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > Value="#Form.Payment_Mode#">, > <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" > Value="#Form.Policy_Notes#"> > ) > > </CFQUERY> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221013 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
