RE: Question about using 2 datasources

2001-11-01 Thread Steve Martin
al Message- From: 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 o

RE: Question about using 2 datasources

2001-11-01 Thread Ben Forta
You can join two queries in a third . 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

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 t

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=Thread&TopicID=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 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

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 >

Question about using 2 datasources

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