Re: Question about using 2 datasources

2001-11-01 Thread Kevin Schmidt
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

RE: Question about using 2 datasources

2001-11-01 Thread Kris Pilles
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

Re: Question about using 2 datasources

2001-11-01 Thread Joseph Thompson
This works to combine two Access datasources into one query. http://cfhub.com/forum/index.cfm?FuseAction=ThreadTopicID=1914 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

Re: Question about using 2 datasources

2001-11-01 Thread Clint Tredway
You will need to run queries from both datasources and compare the results. HTH -- Original Message -- from: Kris Pilles [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 1 Nov 2001 11:52:31 -0500 Ok heres my problem. I have a Access database

RE: Question about using 2 datasources

2001-11-01 Thread Ben Forta
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

RE: Question about using 2 datasources

2001-11-01 Thread Steve Martin
: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 17:07 To: CF-Talk Subject: Re: 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