Richard, Glad to be of help. I hope that now you will have a great weekend, happy holidays, etc. (and that your hair will grow back :-)
And more than that, I hope that with Scorpio the MySQL drivers bundled with CF will be upgraded. (Anyone from the CF team at Adobe lurking here on this list ? ) btw ... I wore a "DBA hat" fulltime for several years before coming to CF. This made me very aware of the key role that the driver "middleware" plays in all SQL to client communication (CF included). I encourage that if others ever encounter problems related to CF and databases (including SQL), if you have access to DBAs, really try to engage your DBA when trying to resolve your problem. And truly, if you have access to DBAs, though you may not need them every day, be sure you make friends with them because there are times that they really can make magic happen for your database driven web applications :-) Happy CF'ing! Best regards, g On 12/1/06, Richard White <[EMAIL PROTECTED]> wrote: > > hi greg, you are a diamond :) I changed the driver over to the connector j > 5.0 and added a new datasource not with mysql connection but with 'other' > and set the configuration manually. I tried it and couldnt believe that it > is now working. It does make alot of sense now that we know what it is. > > Thanks again for your help greg, i really do appreciate it :) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4