You can happily query multiple databases within the same request; what you can't do is query multiple databases within a single transaction. So as long as your CFQUERY tags don't share a CFTRANSACTION block you should be fine.
Can you post the actual error message? cheers, barneyb On Thu, Mar 11, 2010 at 12:26 PM, Steven Sprouse <[email protected]> wrote: > > I have someone who has two separate databases and they want me to write a Web > form generating option menus from both databases. > > I have set up both as separate data sources in my Coldfusion administrator > and have included one cfquery at the head of my document generating a list of > locations. It's working fine. When I try to query the second database and do > a cfoutput for another option menu, I get errors. > > I seem to remember that it might not be possible to have two separate cfquery > statements in the same document. Is this correct? If so, how would I go about > achieving my desired result? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
