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