Query of Queries Error

[Chad Baloga]

I am try to run a query of queries to order a query I create on the fly. On DEV 
I do not get an error.  On PROD I am getting:

The system has attempted to use an undefined value, which usually indicates a 
programming error, either in your code or some system code.

Null Pointers are another name for undefined values. 

My Code:
cfquery name=docQryReordered dbtype=query
   SELECT * FROM docQry ORDER BY sysModule
/cfquery

If I take the ORDER BY out, I still get the error.

Any suggestions? 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352765
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[lakshmi Suresh]

try to dump query docQry chk if it is returning any row.
On Wed, Sep 26, 2012 at 6:50 PM, Chad Baloga cbal...@gmail.com wrote:


 I am try to run a query of queries to order a query I create on the fly.
 On DEV I do not get an error.  On PROD I am getting:

 The system has attempted to use an undefined value, which usually
 indicates a programming error, either in your code or some system code.

 Null Pointers are another name for undefined values.

 My Code:
 cfquery name=docQryReordered dbtype=query
SELECT * FROM docQry ORDER BY sysModule
 /cfquery

 If I take the ORDER BY out, I still get the error.

 Any suggestions?


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352766
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[Chad Baloga]

Yes it is, I have been playing with it and dumping results to see what data may 
be causing the error

try to dump query docQry chk if it is returning any row.


 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352767
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[lakshmi Suresh]

in select statement try to select one column at a time to chk which
column's data is causing the error.

On Wed, Sep 26, 2012 at 7:12 PM, Chad Baloga cbal...@gmail.com wrote:


 Yes it is, I have been playing with it and dumping results to see what
 data may be causing the error

 try to dump query docQry chk if it is returning any row.
 
 
 


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Query of Queries Error

[Chad Baloga]

I figured it out.  The last column had some NULL values which I guess it didn't 
like even though other columns have NULLs and it's fine (Sounds like a bug).  I 
defaulted the NULL ones to N/A so it works now.  Also had to declare all my 
columns as VARCHARs in my QueryNew set statement.

try to dump query docQry chk if it is returning any row.


 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Query of Queries error

[vidya yegnaraman]

I have a runtime query of a query error as below.
java.lang.String cannot be cast to java.util.Date  
But the output format is correct and is in date. This application was developed 
in coldfusion 6.1 and sqlserver2000. But now we get this error when it was 
migrated to coldfusion 8 and sql server 2005.
Below is the query block. There error comes in the select statement.
if (NOT IsDefined(URL.sOrderBy)) URL.sOrderBy = dtStartDate;
if (NOT IsDefined(URL.sOrderType)) URL.sOrderType = DESC;
/cfscript
cftry
!--- Query of a query ---
cfquery name=Variables.qSearchProjects dbtype=query
SELECT  *
FROMqCombinedProjects
ORDER BY #URL.sOrderBy# #URL.sOrderType#;
/cfquery
cfcatch
!--- Order the projects by start date ---
cfquery name=Variables.qSearchProjects dbtype=query
SELECT  *
FROMqCombinedProjects
ORDER BY dtStartDate DESC;
/cfquery
/cfcatch
/cftry

dtstartdate is in date format. Please help as this really urgent


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries error

[Richard White]

i had a similar problem and turned out to be that one of the values in the 
order by clause was empty - cf seems to mistake it for a empty string and 
therefore was producing the same error you are experiencing... check all values 
in the problem column to ensure there are no empty values

i also get around alot of query of query problems by using cast()

hope this helps

 I have a runtime query of a query error as below.
 java.lang.String cannot be cast to java.util.Date  
 But the output format is correct and is in date. This application was 
 developed in coldfusion 6.1 and sqlserver2000. But now we get this 
 error when it was migrated to coldfusion 8 and sql server 2005.
 Below is the query block. There error comes in the select statement.
 if (NOT IsDefined(URL.sOrderBy)) URL.sOrderBy = dtStartDate;
   if (NOT IsDefined(URL.sOrderType)) URL.sOrderType = DESC;
   /cfscript
   cftry
   !--- Query of a query ---
   cfquery name=Variables.qSearchProjects dbtype=query
   SELECT  *
   FROMqCombinedProjects
   ORDER BY #URL.sOrderBy# #URL.sOrderType#;
   /cfquery
   cfcatch
   !--- Order the projects by start date ---
   cfquery name=Variables.qSearchProjects dbtype=query
   SELECT  *
   FROMqCombinedProjects
   ORDER BY dtStartDate DESC;
   /cfquery
   /cfcatch
   /cftry
 
 dtstartdate is in date format. Please help as this really urgent


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312097
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query of Queries Error

[Phillip Duba]

I'm getting an error when performing a query of queries as follows:

Unsupported Date type conversion in Query of Queries. 

The query contains nubmers, strings and one date field. Here's a row from the 
CFDump of the query.

21 || {ts '2005-04-08 00:00:00'} || 317 || 1887 || Karen Wennlund || [empty 
string] || [empty string] || JS || PS317 || Emergency Contact Information || 
[empty string] 

Is having a date field a limitation on queries of queries, the definition of 
data in the field? I build this query using the query functions and then want 
to to do a mass order by on it once it's built. Thanks,

Phil

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212340
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

Re: Query of Queries Error

[Brian Kotek]

This is an old and annoying issue that is cause by CF trying to guess the 
type of the data in the column. We've had to append a string character such 
as a tilde to the data to foce everything to be a string, do the QofQ, and 
then remove it before processing/display.

Hope that helps,

Brian


On 7/20/05, Phillip Duba [EMAIL PROTECTED] wrote:
 
 I'm getting an error when performing a query of queries as follows:
 
 Unsupported Date type conversion in Query of Queries.
 
 The query contains nubmers, strings and one date field. Here's a row from 
 the CFDump of the query.
 
 21 || {ts '2005-04-08 00:00:00'} || 317 || 1887 || Karen Wennlund || 
 [empty string] || [empty string] || JS || PS317 || Emergency Contact 
 Information || [empty string]
 
 Is having a date field a limitation on queries of queries, the definition 
 of data in the field? I build this query using the query functions and then 
 want to to do a mass order by on it once it's built. Thanks,
 
 Phil
 
 

~|
Logware (www.logware.us): 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:212342
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

Re: Query of Queries Error

[Phillip Duba]

Thanks Brian, that worked. Ugh, what a crappy bug,

Phil

This is an old and annoying issue that is cause by CF trying to guess the 
type of the data in the column. We've had to append a string character such 
as a tilde to the data to foce everything to be a string, do the QofQ, and 
then remove it before processing/display.

Hope that helps,

Brian


On 7/20/05, Phillip Duba [EMAIL PROTECTED] wrote:


~|
Logware (www.logware.us): 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:212347
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

Re: Query of Queries error - solution

[Jeff Langevin]

Thanks for the idea.  I still had problems though.  So I added a dummy 
row using querySetCell() where the offending column's value was set to 
aaa (I think someone might have suggested something like this 
earlier).  This is a value that would never occur in real life.  On 
the next process that I perform on the data, I will weed out that row.

Thanks for everyone's suggestions.  As always, you folks are great.

--Jeff

On 6/22/2005 5:33 PM, Mark A Kruger wrote:
 ok... in your querySetCell( ) call try doing something stringlike. For
 example, try Javacast('string',myVar) - or try trim or  something like myVar
  '' - anything to make the script aware of the type so it doesn't have to
 guess.
 
 -Mark
 


~|
Logware (www.logware.us): 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:210333
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=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries error - solution

[Jeff Langevin]

Oh yes, and I used the cast in the other query to get QoQ to play 
nicely.  Thanks!

cast(OrderDetails.Order_ID AS varchar(12)) AS Order_ID,

--Jeff

On 6/23/2005 8:52 AM, Jeff Langevin wrote:

 Thanks for the idea.  I still had problems though.  So I added a dummy 
 row using querySetCell() where the offending column's value was set to 
 aaa (I think someone might have suggested something like this 
 earlier).  This is a value that would never occur in real life.  On 
 the next process that I perform on the data, I will weed out that row.
 
 Thanks for everyone's suggestions.  As always, you folks are great.
 
 --Jeff
 
 On 6/22/2005 5:33 PM, Mark A Kruger wrote:
 
ok... in your querySetCell( ) call try doing something stringlike. For
example, try Javacast('string',myVar) - or try trim or  something like myVar
 '' - anything to make the script aware of the type so it doesn't have to
guess.

-Mark

 
 
 
 

~|
Logware (www.logware.us): 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:210339
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=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries error - solution

[James Holmes]

Would it help if I made good on my threat to write a QueryCast() UDF for CF 6.1?

On 6/23/05, Jeff Langevin [EMAIL PROTECTED] wrote:
 Oh yes, and I used the cast in the other query to get QoQ to play
 nicely.  Thanks!
 
 cast(OrderDetails.Order_ID AS varchar(12)) AS Order_ID,
 
 --Jeff
 
 On 6/23/2005 8:52 AM, Jeff Langevin wrote:

-- 
Geeque - accept the geek within and get your friends off your back -
http://www.cafepress.com/geeque/

~|
Logware (www.logware.us): 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:210342
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

RE: Query of Queries error - solution

[Mark A Kruger]

awesome... good tip... (still a kludge though - ha)...

-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 23, 2005 7:52 AM
To: CF-Talk
Subject: Re: Query of Queries error - solution


Thanks for the idea.  I still had problems though.  So I added a dummy
row using querySetCell() where the offending column's value was set to
aaa (I think someone might have suggested something like this
earlier).  This is a value that would never occur in real life.  On
the next process that I perform on the data, I will weed out that row.

Thanks for everyone's suggestions.  As always, you folks are great.

--Jeff

On 6/22/2005 5:33 PM, Mark A Kruger wrote:
 ok... in your querySetCell( ) call try doing something stringlike. For
 example, try Javacast('string',myVar) - or try trim or  something like
myVar
  '' - anything to make the script aware of the type so it doesn't have to
 guess.

 -Mark





~|
Logware (www.logware.us): 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:210356
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=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries error - solution

[Jeff Langevin]

I have no doubt that it would be put to good use by many if you did...

--Jeff

On 6/23/2005 10:07 AM, James Holmes wrote:

 Would it help if I made good on my threat to write a QueryCast() UDF for CF 
 6.1?
 
 On 6/23/05, Jeff Langevin [EMAIL PROTECTED] wrote:
 
Oh yes, and I used the cast in the other query to get QoQ to play
nicely.  Thanks!

cast(OrderDetails.Order_ID AS varchar(12)) AS Order_ID,

--Jeff

On 6/23/2005 8:52 AM, Jeff Langevin wrote:
 
 

-- 

Jeff Langevin Web Programmer
Appalachian Mountain Club [EMAIL PROTECTED]
5 Joy Street, Boston, MA 02108 617-523-0655 x302


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210422
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

Query of Queries error

[Jeff Langevin]

I am trying to join two sets of data using query of queries.  I've read 
the livedocs and search the HoF archives and haven't been able to figure 
out a way to handle this.  My problem is that I run the query at the end 
of this massage and get the following error:

Query Of Queries runtime error.
Can't convert the string 13207A to java type LONG

QoQ is making the column be the wrong type.  I need to to be a string 
type, but the first record has a numeric value as the order ID.  Any 
suggestions on how to force the type in QoQ?  One data set is coming 
from a database and another is a query built from a csv file.  I could 
write the csv data to a database table first and then work on it from 
there, but I'd rather avoid that if possible.  I have a CF5 server and a 
6.1 server on which I can run this process.

Thanks!

-Jeff


cfquery dbtype=query name=combineOrderData
SELECT  getOrders.OrderDetail_ID,
getOrders.Order_ID,
getOrders.Qty,
getOrders.ProductTitle,
getOrders.OptTitles,
getOrders.realPartNumber,
shippedOrderData.whsorderno,
shippedOrderData.shipdate,
shippedOrderData.trackno,
shippedOrderData.ordered,
shippedOrderData.shipped,
shippedOrderData.line,
shippedOrderData.freightcharge
FROMgetOrders,
shippedOrderData
WHERE   getOrders.Order_ID = shippedOrderData.Order_ID AND
getOrders.realPartNumber = shippedOrderData.product
ORDER BY getOrders.Order_ID
/cfquery


~|
Logware (www.logware.us): 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:210255
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

RE: Query of Queries error

[Ian Skinner]

Upgrade to CFMX 7?  

I know, that is not really an answer, but this is one of the many improvements 
in MX 7, the ability to type QofQ columns which did not exist in previous 
versions.

Assuming this is not an option, you are going to have to do something to force 
the issue, can you possible sort one of the original queries so that the first 
row is clearly a string?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 10:59 AM
To: CF-Talk
Subject: Query of Queries error

I am trying to join two sets of data using query of queries.  I've read
the livedocs and search the HoF archives and haven't been able to figure
out a way to handle this.  My problem is that I run the query at the end
of this massage and get the following error:

Query Of Queries runtime error.
Can't convert the string 13207A to java type LONG

QoQ is making the column be the wrong type.  I need to to be a string
type, but the first record has a numeric value as the order ID.  Any
suggestions on how to force the type in QoQ?  One data set is coming
from a database and another is a query built from a csv file.  I could
write the csv data to a database table first and then work on it from
there, but I'd rather avoid that if possible.  I have a CF5 server and a
6.1 server on which I can run this process.

Thanks!

-Jeff


cfquery dbtype=query name=combineOrderData
SELECT  getOrders.OrderDetail_ID,
getOrders.Order_ID,
getOrders.Qty,
getOrders.ProductTitle,
getOrders.OptTitles,
getOrders.realPartNumber,
shippedOrderData.whsorderno,
shippedOrderData.shipdate,
shippedOrderData.trackno,
shippedOrderData.ordered,
shippedOrderData.shipped,
shippedOrderData.line,
shippedOrderData.freightcharge
FROMgetOrders,
shippedOrderData
WHERE   getOrders.Order_ID = shippedOrderData.Order_ID AND
getOrders.realPartNumber = shippedOrderData.product
ORDER BY getOrders.Order_ID
/cfquery




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210257
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

RE: Query of Queries error

[Mark A Kruger]

Jeff,

One of your original queries (that pull from the DB) sees the join column as
a numeric type. re-cast it as a string type in the original query. Here's an
MS SQL example.

cast(realPartNumber AS varchar(12)) AS realPartnumber

What DB are you using?

This should cause the recordset object to see it as a string.

-mark

Mark A. Kruger, CFG, MCSE
www.cfwebtools.com
www.necfug.com
http://mkruger.cfwebtools.com



-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 12:59 PM
To: CF-Talk
Subject: Query of Queries error


I am trying to join two sets of data using query of queries.  I've read
the livedocs and search the HoF archives and haven't been able to figure
out a way to handle this.  My problem is that I run the query at the end
of this massage and get the following error:

Query Of Queries runtime error.
Can't convert the string 13207A to java type LONG

QoQ is making the column be the wrong type.  I need to to be a string
type, but the first record has a numeric value as the order ID.  Any
suggestions on how to force the type in QoQ?  One data set is coming
from a database and another is a query built from a csv file.  I could
write the csv data to a database table first and then work on it from
there, but I'd rather avoid that if possible.  I have a CF5 server and a
6.1 server on which I can run this process.

Thanks!

-Jeff


cfquery dbtype=query name=combineOrderData
SELECT  getOrders.OrderDetail_ID,
getOrders.Order_ID,
getOrders.Qty,
getOrders.ProductTitle,
getOrders.OptTitles,
getOrders.realPartNumber,
shippedOrderData.whsorderno,
shippedOrderData.shipdate,
shippedOrderData.trackno,
shippedOrderData.ordered,
shippedOrderData.shipped,
shippedOrderData.line,
shippedOrderData.freightcharge
FROMgetOrders,
shippedOrderData
WHERE   getOrders.Order_ID = shippedOrderData.Order_ID AND
getOrders.realPartNumber = shippedOrderData.product
ORDER BY getOrders.Order_ID
/cfquery




~|
Logware (www.logware.us): 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:210258
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

Re: Query of Queries error

[Jeff Langevin]

The problem is that the offending data is in the csv file which is being 
turned into a query result using QuerySetCell().  That doesn't support 
setting a type.

If I do the cast in the other query, QoQ throws an error saying that the 
comparison of the two different data types is not supported...

Oh if only we could move to 7.  But that is not an option.

--Jeff

On 6/22/2005 2:06 PM, Mark A Kruger wrote:

 Jeff,
 
 One of your original queries (that pull from the DB) sees the join column as
 a numeric type. re-cast it as a string type in the original query. Here's an
 MS SQL example.
 
 cast(realPartNumber AS varchar(12)) AS realPartnumber
 
 What DB are you using?
 
 This should cause the recordset object to see it as a string.
 
 -mark
 
 Mark A. Kruger, CFG, MCSE
 www.cfwebtools.com
 www.necfug.com
 http://mkruger.cfwebtools.com
 
 
 
 -Original Message-
 From: Jeff Langevin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 22, 2005 12:59 PM
 To: CF-Talk
 Subject: Query of Queries error
 
 
 I am trying to join two sets of data using query of queries.  I've read
 the livedocs and search the HoF archives and haven't been able to figure
 out a way to handle this.  My problem is that I run the query at the end
 of this massage and get the following error:
 
 Query Of Queries runtime error.
 Can't convert the string 13207A to java type LONG
 
 QoQ is making the column be the wrong type.  I need to to be a string
 type, but the first record has a numeric value as the order ID.  Any
 suggestions on how to force the type in QoQ?  One data set is coming
 from a database and another is a query built from a csv file.  I could
 write the csv data to a database table first and then work on it from
 there, but I'd rather avoid that if possible.  I have a CF5 server and a
 6.1 server on which I can run this process.
 
 Thanks!
 
 -Jeff
 
 
 cfquery dbtype=query name=combineOrderData
   SELECT  getOrders.OrderDetail_ID,
   getOrders.Order_ID,
   getOrders.Qty,
   getOrders.ProductTitle,
   getOrders.OptTitles,
   getOrders.realPartNumber,
   shippedOrderData.whsorderno,
   shippedOrderData.shipdate,
   shippedOrderData.trackno,
   shippedOrderData.ordered,
   shippedOrderData.shipped,
   shippedOrderData.line,
   shippedOrderData.freightcharge
   FROMgetOrders,
   shippedOrderData
   WHERE   getOrders.Order_ID = shippedOrderData.Order_ID AND
   getOrders.realPartNumber = shippedOrderData.product
   ORDER BY getOrders.Order_ID
 /cfquery
 
 
 
 
 

~|
Logware (www.logware.us): 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:210282
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=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries error

[Mark A Kruger]

ok... in your querySetCell( ) call try doing something stringlike. For
example, try Javacast('string',myVar) - or try trim or  something like myVar
 '' - anything to make the script aware of the type so it doesn't have to
guess.

-Mark

-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 3:16 PM
To: CF-Talk
Subject: Re: Query of Queries error


The problem is that the offending data is in the csv file which is being
turned into a query result using QuerySetCell().  That doesn't support
setting a type.

If I do the cast in the other query, QoQ throws an error saying that the
comparison of the two different data types is not supported...

Oh if only we could move to 7.  But that is not an option.

--Jeff

On 6/22/2005 2:06 PM, Mark A Kruger wrote:

 Jeff,

 One of your original queries (that pull from the DB) sees the join column
as
 a numeric type. re-cast it as a string type in the original query. Here's
an
 MS SQL example.

 cast(realPartNumber AS varchar(12)) AS realPartnumber

 What DB are you using?

 This should cause the recordset object to see it as a string.

 -mark

 Mark A. Kruger, CFG, MCSE
 www.cfwebtools.com
 www.necfug.com
 http://mkruger.cfwebtools.com



 -Original Message-
 From: Jeff Langevin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, June 22, 2005 12:59 PM
 To: CF-Talk
 Subject: Query of Queries error


 I am trying to join two sets of data using query of queries.  I've read
 the livedocs and search the HoF archives and haven't been able to figure
 out a way to handle this.  My problem is that I run the query at the end
 of this massage and get the following error:

 Query Of Queries runtime error.
 Can't convert the string 13207A to java type LONG

 QoQ is making the column be the wrong type.  I need to to be a string
 type, but the first record has a numeric value as the order ID.  Any
 suggestions on how to force the type in QoQ?  One data set is coming
 from a database and another is a query built from a csv file.  I could
 write the csv data to a database table first and then work on it from
 there, but I'd rather avoid that if possible.  I have a CF5 server and a
 6.1 server on which I can run this process.

 Thanks!

 -Jeff


 cfquery dbtype=query name=combineOrderData
   SELECT  getOrders.OrderDetail_ID,
   getOrders.Order_ID,
   getOrders.Qty,
   getOrders.ProductTitle,
   getOrders.OptTitles,
   getOrders.realPartNumber,
   shippedOrderData.whsorderno,
   shippedOrderData.shipdate,
   shippedOrderData.trackno,
   shippedOrderData.ordered,
   shippedOrderData.shipped,
   shippedOrderData.line,
   shippedOrderData.freightcharge
   FROMgetOrders,
   shippedOrderData
   WHERE   getOrders.Order_ID = shippedOrderData.Order_ID AND
   getOrders.realPartNumber = shippedOrderData.product
   ORDER BY getOrders.Order_ID
 /cfquery








~|
Logware (www.logware.us): 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:210295
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

My Query of Queries error with code

[Jeff]

Here's the error I'm getting, and below that, is the code that's apparently
causing it. Now, here's the really weird part. SOME...I repeat...SOME words
and phrases actually *WORK*. In other words, I can type heart or cancer
and return a legit, fine recordset, all UNION'ed and sorted correctly.
However, certain words and phrases cause the error below:


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 diffent types (VARCHAR, OTHER).

Here's the code I'm using:
CFSEARCH
   name = GetLevel2Content
   collection = Level2Content
   criteria = #Form.Criteria#
   startRow = #Form.StartRow#

 CFSEARCH
   name = GetLevel3Content
   collection = Level3Content
   criteria = #Form.Criteria#
   startRow = #Form.StartRow#

CFSEARCH
   name = GetLevel4Content
   collection = Level4Content
   criteria = #Form.Criteria#
   startRow = #Form.StartRow#

CFSEARCH
   name = GetLevel5Content
   collection = Level5Content
   criteria = #Form.Criteria#
   startRow = #Form.StartRow#

CFSEARCH
   name = GetPrograms
   collection = McLeodPrograms
   criteria = #Form.Criteria#
   startRow = #Form.StartRow#

 
cfquery name=Combine dbtype=query
SELECT * 
FROM GetLevel2Content

UNION
SELECT * 
FROM GetLevel3Content

UNION
SELECT * 
FROM GetLevel4Content

UNION
SELECT * 
FROM GetLevel5Content

UNION
SELECT * 
FROM GetPrograms

ORDER BY Score desc
/cfquery

~|
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

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Re: My Query of Queries error with code

[Jochem van Dieten]

Jeff wrote:
 Here's the error I'm getting, and below that, is the code that's apparently
 causing it. Now, here's the really weird part. SOME...I repeat...SOME words
 and phrases actually *WORK*. In other words, I can type heart or cancer
 and return a legit, fine recordset, all UNION'ed and sorted correctly.
 However, certain words and phrases cause the error below:
 
 
 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 diffent types (VARCHAR, OTHER).

CF does not remember what datatypes columns are, it tries to 
determine on the fly. So if the first record of some column 
contains 'april 2001' Cf thinks it is a date and will assume the 
whole column is a date column. Naturally it is really a string, 
but it will prevent you from unioning it to some other string column.

The only workaround I know is prepending some garbage string to 
each record so you force CF to recognize it as a string. Then 
after the unioning you can strip it off.

Jochem


~|
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

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

Redsky-Query of Queries Error with = cfqueryparam... statement

[Angel Stewart]

Error Executing Database Query.  

Query Of Queries runtime error.
Unsupported type comparison.  

237 :   AND
PSchedule_Date =  cfqueryparam
VALUE=#DateFormat(CreateDate(year(dateinfo),month(dateinfo),k),
MM/DD/)# CFSQLTYPE=cf_sql_date

238 :   AND
Pschedule_BaseID Is Not Null
239 :   AND
PSchedule_BaseID = cfqueryparam VALUE=#GEtPilots.PSchedule_Baseid#
CFSQLTYPE=cf_sql_integer
240 :   /cfquery

The error is in line 239.


This is the query..I modified it to check for NULL values since the
Release Notes for Redsky mentioned something along those lines.
I was told that the app worked fine before the update...

Any ideas from anyone as to what the problem could be?

-Gel



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query of Queries Error

[Jose Alfonso]

Here’s the function in a cfc that’s causing the error.
It seems like the problem re-occurs whenever the runtime query being appended does not 
match the first one instantiated:-(

cffunction name=”appendqry”
returntype=”query”
hint=”Appends a query in a named instance” output=”No”
 
cfargument name=”Query” type=”query” required=”Yes”
cfargument name=”InstanceName” type=”string” default=”Query”
cfif not isDefined(“this.#arguments.InstanceName#”)
cfscript
“this.#arguments.InstanceName#” = arguments.query;
/cfscript
cfelse
cfquery name=”this.#arguments.InstanceName#” dbtype=”query”
SELECT * FROM this.#arguments.InstanceName#
UNION ALL
SELECT * FROM arguments.Query
/cfquery
/cfif
cfreturn evaluate(“this.”  arguments.InstanceName) /
/cffunction 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries Error

[jon hall]

Just to clarify...you are saying that a QoQ sometimes changes the
datatype of a column?


btw...you should be able to rewrite the cfreturn without the eval as:
cfreturn this[arguments.InstanceName] /

it's a bit cleaner imho.

-- 
 jon
 mailto:[EMAIL PROTECTED]

Tuesday, July 1, 2003, 4:52:23 PM, you wrote:
JA Here’s the function in a cfc that’s causing the error.
JA It seems like the problem re-occurs whenever the runtime query being appended does 
not match the first one instantiated:-(

JA cffunction name=”appendqry”
JA returntype=”query”
JA hint=”Appends a query in a named instance” output=”No”
 
JA cfargument name=”Query” type=”query” required=”Yes”
JA cfargument name=”InstanceName” type=”string” default=”Query”
JA cfif not isDefined(“this.#arguments.InstanceName#”)
JA cfscript
JA “this.#arguments.InstanceName#” = arguments.query;
JA /cfscript
JA cfelse
JA cfquery name=”this.#arguments.InstanceName#” dbtype=”query”
JA SELECT * FROM this.#arguments.InstanceName#
JA UNION ALL
JA SELECT * FROM arguments.Query
JA /cfquery
JA /cfif
JA cfreturn evaluate(“this.”  arguments.InstanceName) /
JA /cffunction 
JA 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query of Queries Error

[Jose Alfonso]

Thanks for the hint there.
Yes the problem seems to be that CF creates the data types at run time and as far as I 
can tell based on the first row of the query. So depending on wich recordset is passed 
by the appendquery function, that particular column can change data types (in my case 
the data type is ntext in SQL and basically can accept any data type) but when CF sees 
mm/dd/yy it assumes it's a datetime data type, same thing with other data types as 
well.

Just for the heck of it and based on a thread I read, I created this 'fix query' 
method that forces the first row to be string but it still will not work. So I am 
begining to think that saving the instance data on a Q of Q is not the best solution 
here but I really want to group the data so I welcome any suggestions

cffunction name=fixquery
 returntype=query
 hint=Ugly fix to CF Bug. Takes a query and returns a new one 
with a blank first row
cfargument name=Query type=query required=Yes
cfscript
lstFields = arguments.query.Columnlist;
qTemp = QueryNew(lstFields);
QueryAddRow(qTemp,1);

/cfscript
cfloop index=ii list=#lstFields#
cfscript
QuerySetCell(qTemp,ii,'');
/cfscript
/cfloop

cfloop query=arguments.Query
cfscript
QueryAddRow(qTemp,1);
/cfscript
cfloop index=ii list=#lstFields#
cfscript
QuerySetCell(qTemp,ii,evaluate(ii));
/cfscript
/cfloop
/cfloop
cfreturn qTemp /
/cffunction
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query of Queries Error

[Jose Alfonso]

I've got a variation on this same error (Macromedia please acknowledge this is a bug 
in CFMX!)

In my case I have an append query component that basically takes a query argument and 
appends the queries in an instance.

The problem is that the query returned by the method may vary the data it returns. In 
this case at one point it returns most records with zero and 1 as data and so when the 
UNION tries to join them the error occurs.

This is the error I get:
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 23 have diffent types (VARCHAR, BIGINT).

Jedi Master please tell this simple mortal:
Why is CFMX 'assuming' data types in query of queries?
(I've heard this complain many times, this makes code written in CF5 not compatible 
with CFMX)
Why (if the sublime realm of Java requires that you use those ‘assumed’ data types) 
don’t you allow Query of queries to receive arguments that tell it what the data types 
are?
Talk to me master…

And lastly is there worldly solution to this problem? Trust me master, I’ve tried… but 
my faith fails me… if I change the data of those 2 insubordinate records to ‘Yes’ and 
‘No’ my worldly code does work.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries Error

[Matthew Walker]

Can we see your code?

 -Original Message-
 From: Jose Alfonso [mailto:[EMAIL PROTECTED]
 Sent: Thursday, 29 May 2003 9:09 a.m.
 To: CF-Talk
 Subject: Query of Queries Error
 
 I've got a variation on this same error (Macromedia please acknowledge
 this is a bug in CFMX!)
 
 In my case I have an append query component that basically takes a query
 argument and appends the queries in an instance.
 
 The problem is that the query returned by the method may vary the data it
 returns. In this case at one point it returns most records with zero and 1
 as data and so when the UNION tries to join them the error occurs.
 
 This is the error I get:
 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 23 have diffent types (VARCHAR, BIGINT).
 
 Jedi Master please tell this simple mortal:
 Why is CFMX 'assuming' data types in query of queries?
 (I've heard this complain many times, this makes code written in CF5 not
 compatible with CFMX)
 Why (if the sublime realm of Java requires that you use those 'assumed'
 data types) don't you allow Query of queries to receive arguments that
 tell it what the data types are?
 Talk to me master.
 
 And lastly is there worldly solution to this problem? Trust me master,
 I've tried. but my faith fails me. if I change the data of those 2
 insubordinate records to 'Yes' and 'No' my worldly code does work.
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries Error

[Ryan Kime]

I am getting the same Unsupported Numeric type error on a QofQ from a site
I'm migrating from CF5 to CFMX. It worked fine in CF5. Mine sounds only
slightly different in the fact that my QofQ is only used to order the query
results. Notice I don't have all the tie fields in the QofQ, could that
affect it? If anyone has any ideas or a better way to order the results, I'm
all ears...

[SNIP]

cfset newRow  = QueryAddRow(teamStandings, 1)
!--- set the cells in the query ---
cfset temp = QuerySetCell(teamStandings, site_id, #site_id#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, name,
#organization_name#, #loop_count#)
cfset temp = QuerySetCell(teamStandings, wins, #wins#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, losses, #losses#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, ties, #ties#,
#loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_wins,
#dist_wins#, #loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_losses,
#dist_losses#, #loop_count#)
cfset temp = QuerySetCell(teamStandings, dist_ties,
#dist_ties#, #loop_count#)

cfset loop_count = loop_count + 1
/cfloop

cfquery name=Standings dbtype=query
SELECT
site_id,
name,
wins,
losses,
dist_wins,
dist_losses
FROM teamStandings
ORDER BY dist_wins DESC
/cfquery


-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 30, 2002 11:22 AM
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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: Query of Queries Error

[Raymond Camden]

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
 
 
 
 
 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query of Queries Error

[Sam Farmer]

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
 
 
 
 
 
 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Query of Queries Error

[Raymond Camden]

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
  
  
  
  
  
  
 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query of Queries Error

[Sam Farmer]

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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Query of Queries Error

[Sam Farmer]

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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists