Select * is icky-poo have you tried it by explicitely stating your column to make sure its not Select * ohh icky hurts typing it....
Adam H On Mon, 17 Jan 2005 17:42:24 -0500, Andrew Tyrone <[EMAIL PROTECTED]> wrote: > 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:190856 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
