Got a link to info on ConnectorJ Ken?? ;-) and yes...yer right....the MySQL Connector is what I'm using now (it's not CF specific....it's a JAR you can add to CF)
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: "Ken Ferguson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, July 28, 2005 5:12 AM Subject: Re: MySQL JDBC Driver (MySQL connector) > 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:213138 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
