Use CFQUERYPARAM, but remember that it'll run slightly slower than not using it on MySQL 3.x and 4.0, because neither version understands the concept of prepared statements, so the overhead on the CF side provides no performance benefit. The improved security and consistency is still very desirable, but don't expect things to get faster like with most other RDBMSs.
barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2003 4:22 AM > To: CF-Talk > Subject: Re: CF5 to MySQL without ODBC > > > Jim McAtee wrote: > > > > I see. So, regarding my question about using ODBC style dates with the > > 'native' jdbc drivers - do the drivers understand ODBC > formatted date/times or > > do they just pass queries verbatim to the dbms, forcing you to > comply with the > > particular formats of the database? > > JDBC drivers will pass them on straight to the dbms if provided as > variables. However, CF MX understands them, and I expect that CF MX > converts them on the fly to java.sql.Date, java.sql.Time and > java.sql.Timestamp classes when you use cfqueryparam. > > But if you use cfqueryparam, there is no need to use ODBC dates in the > first place, so it all boils down to the usual "use cfqueryparam". > > Jochem > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
