Thanks Barney, No luck though...and it turns out that was exactly what i had done to workaround this.
The really weird part is the datasource pointing to a copy of this DB at CrystalTech using the MySQL 3.x driver that comes with MX 7 works just fine....but using the same driver on a local copy of the DB doesn't work (datasource verifies fine but returns no data when CFQUERYPARAM is used....works fine when CFQUERYPARAM removed).....same query also runs fine in a query builder grrrrr...I hate MySQL..wish this project didn't require it Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Barney Boisvert" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, July 27, 2005 5:17 PM Subject: Re: MySQL JDBC Driver (MySQL connector) > Check this from Steven Erat's blog (watch the wrap): > > http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=25AA9A56-45A6-2844-7A60CF5B3666D010 > > cheers, > barneyb > > On 7/27/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: >> Hey All, >> >> I've got a MySQL Datasource in CF MX 7 (installed as a J2EE instance) and >> I did some workaround to make the datasource work with MySQL 4.1 (the one >> shipped is for 3.x). The problem is now that the datasource verifies, >> any query using CFQUERYPARAM on a numeric field will return no data. As >> soon as I remove the CFQUERYPARAM and use the raw variable...voila...data >> is returned. >> >> If I connect to a remote copy of the same database, the datasource works >> fine with CFQUERYPARAM???? >> >> So I figured I'd try the latest JDBC driver, but the article found here: >> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19170 >> >> relates to MX 6 and not 7...there are no Java & JVM settings in CF >> Admin....so where should I drop the connector jar file?? >> >> or if you have another solution to my problem...fire away >> >> TIA >> >> Cheers >> >> Bryan Stevenson B.Comm. >> VP & Director of E-Commerce Development >> Electric Edge Systems Group Inc. >> phone: 250.480.0642 >> fax: 250.480.1264 >> cell: 250.920.8830 >> e-mail: [EMAIL PROTECTED] >> web: www.electricedgesystems.com >> > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 50 invites. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:213060 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
