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:213059 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
