Its not CF thats choking, its the DB driver. Unless you can replace it with something more stable, you might need to change your query to something else that gets the job done. Also, why do you have 0=0 within your query? That seems a little odd...
Kevin -----Original Message----- From: Mike Rogan [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 8:41 AM To: CF-Talk Subject: Invalid precision value I am receiving the following CF error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value If I try to run the query directly from MS Access, using the same SQL, I receive no error and the results are returned properly. Any ideas on this one? The SQL is: SELECT * FROM foo WHERE targetCoStage LIKE '%Start-up%' AND targetCoStage LIKE '%Development%' AND targetCoStage LIKE '%Early Stage%' AND targetCoStage LIKE '%Late Stage%' AND targetCoStage LIKE '%Middle Stage%' AND UpdateStatus = 'Updated' AND 0 = 0 ORDER BY ID ASC The query above will run successfully in CF as long as I have no more than four "AND" clauses. Once I add a fifth, no matter what the clause is, CF chokes, but Access is fine. The "targetCoStage" column contains a comma delimited values, e.g.: "Start-up,Growth,Development,Early Stage" Thanks! Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207859 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
