Thanks for you help Raymond. I have it working by giving it a default value of -100. Not ideal as really want it to be null. As a suggestion it would be nice if the QueryAddColumn function took datatype as an argument.
Cheers, Sam ----- Original Message ----- From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 10:11 AM Subject: RE: Query of Queries Error > It sounds like you are trying to link up a non integer and integer > column from 2 queries. Can you make the added column have some default > integer values? > > ======================================================================= > Raymond Camden, ColdFusion Jedi Master for Hire > > Email : [EMAIL PROTECTED] > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Sam Farmer [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 01, 2002 10:00 AM > > To: CF-Talk > > Subject: Re: Query of Queries Error > > > > > > CF MX Enterprise. > > > > I have narrowed it down to one column and get the following message: > > > > All resulting columns of queries in a SELECT statement > > containing a UNION > > operator must have corresponding types. > > Columns with index number equal "2" have diffent types > > (INTEGER, VARCHAR). > > > > The column with an index of 2 in the second query is a column > > I have added, > > however, in this case it has no value. In the first query > > the column is not > > added and its an integer column. > > > > Any suggestions? > > > > Thanks, > > > > Sam > > > > > > ----- Original Message ----- > > From: "Raymond Camden" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 01, 2002 8:40 AM > > Subject: RE: Query of Queries Error > > > > > > > What version? > > > > > > Can you limit your select statement to one query that can cause the > > > error? That will pinpoint the exact column. > > > > > > > > ============================================================== > > ========= > > > Raymond Camden, ColdFusion Jedi Master for Hire > > > > > > Email : [EMAIL PROTECTED] > > > Yahoo IM : morpheus > > > > > > "My ally is the Force, and a powerful ally it is." - Yoda > > > > > > > -----Original Message----- > > > > From: Sam Farmer [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, September 30, 2002 12:22 PM > > > > To: CF-Talk > > > > Subject: Query of Queries Error > > > > > > > > > > > > Hi, > > > > > > > > I have a query of queries that has been working fine until > > > > today when I > > > > started getting the following error: > > > > > > > > Query Of Queries runtime error. > > > > Unsupported Numeric type conversion in Query of Queries. > > > > > > > > Thats the extent of the error message provided! The columns > > > > seem to match > > > > up exactly on database type and length. > > > > > > > > Can anyone help provide some insight? > > > > > > > > Thanks, > > > > > > > > Sam > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
