Sure Dave..
Are you using CF5? If so, there is a new feature called "Query-a-Query".
You can actually set a query to run on an existing query's values.
Lee Fuller
Chief Technical Officer
PrimeDNA Corporation / AAA Web Hosting Corporation
"We ARE the net."
http://www.aaawebhosting.com
> -----Original Message-----
> From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 13, 2001 7:37 PM
> To: CF-Talk
> Subject: Sorting on Two Queries
>
>
> I've got a situation where I have scheduling information in
> two different databases (different DSN's). Here's what I
> need. I need to query both and in the output, if there is
> something in the schedule from table 2 that is scheduled
> during the same time as something in table 1, the table 2
> info needs to be displayed instead of the table 1 info. Can
> someone suggest a good approach to this? I've downloaded
> CF_QueryUnion and have been working with that.
>
> Thanks,
> Dave
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
