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:221010 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
