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:331607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
