One thing I'd like to add is that by using the query functions you are also able to add the 2nd recordset to the end of the first recordset. If you were to use a union query and weren't explicity ordering the unioned recordset, CFMX will use the first field as the index field and merge your queries and not place the second result set at the end of the first. It all depends on what you want to happen, so that's not necessarily a bad thing.
> -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Monday, January 17, 2005 5:26 PM > To: CF-Talk > Subject: Re: Help with Union on a query of a Query > > Use the query functions. QofQ has an enormous number of > issues when dealing with column types, so if you're doing any > kind of modifications to the queries after you get the back > from the database, chances are good the QofQ engine will > complain. Rumor has it that many (or most) of these issues > will be resolved in Blackstone, thankfully. > > cheers, > barneyb > > On Mon, 17 Jan 2005 14:17:41 -0800, Ian Skinner > <[EMAIL PROTECTED]> wrote: > > I have a fairly complicated process, where I have to build > up a query from several different sources. I have got it all > working, except the last step where I have to add the latest > record to the end of the newest record. I am trying to do > this with a union in a query-of-a-query query block. I am > getting the following error. > > > > Query Of Queries runtime error. > > All resulting columns of queries in a SELECT statement > containing a UNION operator must have corresponding types. > > Columns with index number equal "3" have different types > (OTHER, VARCHAR). > > > > Here is the code. > > <cfquery dbtype="query" name="Data"> > > SELECT > > * > > FROM > > Data > > > > UNION > > > > SELECT > > * > > FROM > > CurData > > </cfquery> > > > > I have debugged the process so I know that I have all the > same columns in both querries. Is there an easy fix to this, > or is it better if I just start using the query functions to > add data to the final query object. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190854 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
