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