One way would be to combine the two queries into one. You have the two datasources already in cfqueries just do this.
<cfquery name="getOrdersForCustomer" dbtype="query"> Select a.*, b.* from queryA a, queryB b </cfquery> Of course you may have to make some small changes like making the column names match, ordering by a certain field... but this will give you one query with all of your data -Ferg -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:15 AM To: CF-Talk Subject: Create 1 CFSELECT from two sources Using 6.1 and Access DB... Is there a way to combine two data sources to generate a CFSELECT list? I have a list of storage locations, and a list of participants. My select list will result in allowing the end user to tell me that the item is at a storage location, or with a participant. The list of participants is in one database, and the list of locations is in another. How do I make them appear in one list? ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
