That isn't true in the least, you can certainly have more than one db queried in a request. I have to hit 3 or 4 just for authentication, single sign on, personnel records and other info that's spread all across the University I work for.
What are the errors? Are you nesting queries outputs inside one another? If so that won't work, you have to use cfloop instead. -----Original Message----- From: Steven Sprouse [mailto:[email protected]] Sent: Thursday, March 11, 2010 3:26 PM To: cf-talk Subject: Two CFQUERY statements? 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:331609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
