This may help with the set up (but I'm assuming as it verifies it probably ok): http://www.oxalto.co.uk/index.cfm/2007/7/2/Setting-up-a-MySQL- database-with-Unicode--properly-in-Coldfusion-7
T On 2 Jul 2007, at 13:18, Mark Leder wrote: > I have a new MySQL connection set up in CF7 - verifies correctly > (called > "mysqldb). Within this connection I have a db called "ABC", and > then tables > within this db. > > I can't get the cfquery to work correctly: > If I use: <cfquery name="insertA" datasource="mysqldb"> I get the > error: No > database selected > If I use: <cfquery name="insertA" datasource="abc"> I get the error: > Datasource "ABC" could not be found > > I suspect the first error is closer to the solution. How do I get > a cfquery > to point to the right db? > > THANKS! > > Mark > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4