My question would be "Why do it in CF if you can do it in SQL?"
IMHO it's always best to make the DB do the work it's meant for...it does it best
So I'd suggest using a UNION clasue to "join" the 2 queries. As you stated, there are 2 select lists with the same columnsso you should be good to go if your DB can handle UNIONs
But hey...perhaps I'm not gettin what you're after
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: Ryan Mitchell
To: CF-Talk
Sent: Tuesday, August 10, 2004 9:13 AM
Subject: joining two queries
hello again
i have two queries, with the same column list in each.. and i want to
append one query to the end of the other...
i know i can do it in sql, but i want to do it in coldfusion
preferably in cfscript...
how!?
Ryan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]