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 Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
