> Is there any way to do a union in mysql version less than
> 4... Using queries of queries or anything?
Sure, do the two queries, which return exactly the same columns and then
just programatically add one to the end of the other:
<cfquery name="query1">
SELECT col1, col2, col3 FROM myTable
WHERE col2 = "pink"
</cfquery>
<cfquery name="query2">
SELECT col1, col2, col3 FROM myTable
WHERE col3 = "round"
</cfquery>
<cfloop query="query2">
<cfset queryaddrow(query1)>
<cfset querysetcell(query1, "col1", query2.col1)>
<cfset querysetcell(query1, "col2", query2.col2)>
<cfset querysetcell(query1, "col3", query2.col3)>
</cfloop>
HTH,
Tim.
-------------------------------------------------------
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
-------------------------------------------------------
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
-------------------------------------------------------
This message may contain information which is legally
privileged and/or confidential. If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
-------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
