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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:213058 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
