That worked, thanks for clearing that up for me. -----Original Message----- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:40 AM To: CF-Talk Subject: Re: CFQuery and MySQL
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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4