This is happening when using the CF MySQL connector, right? Try installing the MySQL ConnectorJ and see if it works with that. I'm using the MySQL 4.1 with ConnectorJ and CF7 with no problems.
Bryan Stevenson 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:213066 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
