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 .... FROM getOrders, .... 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
