> Are you sure? When I pass a string into a cfqueryparam of type cf_sql_integer > I get the error: Invalid data etc for CFSQLTYPE CF_SQL_INTEGER. > Which leads me to believe it is being scanned/validated before being sent to > MySQL, and also makes me wonder whether cfqueryparam even uses prepared > statements. It seems and not just inline SQL variables. > ( The exception is a coldfusion.sql.Parameter$DataTypeMismatchException )
It's not sent to MySQL directly, it's sent to your JDBC driver, which has to validate it and pass it on. JDBC throws an exception, which is caught and rethrown in CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
