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. > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 8 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:190850 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
