You can join two queries in a third <CFQUERY>. Look at the docs on querying queries.
--- Ben -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:07 PM To: CF-Talk Subject: RE: Question about using 2 datasources I have CF 5... How do I do this Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] -----Original Message----- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:00 PM To: CF-Talk Subject: Re: Question about using 2 datasources If you have CF 5 you can join 2 queries with query of a query! ----- Original Message ----- From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 10:52 AM Subject: Question about using 2 datasources > Ok heres my problem. > > I have a Access database that our users can go into and register new > studetns with. However all of our course information resides in another > datasource. My problem is that I have to display the course names which > reside in database 2. however I have to use the course ID's stored in > Datasource 1. How can I dothis? > > Thanks for all your help > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists