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