Lee, How does that help me. I need the items in query 1 to display, unless
there is an item in query 2 during the same time slot, then the time from
query two displays instead. Example below:
Query 1 Query 2 Display
6am - 10am Q1 6am-10am
10am - 2pm Q1 10am-2pm
2pm - 4pm 2pm - 6pm Q2 2pm - 6pm
4pm - 9pm Q1 6pm - 9pm
Dave
----- Original Message -----
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 10:49 PM
Subject: RE: Sorting on Two Queries
> 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
