Re: Query of Queries Error
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
Re: Query of Queries Error
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 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
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
try to dump query "docQry" chk if it is returning any row. On Wed, Sep 26, 2012 at 6:50 PM, Chad Baloga 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: > >SELECT * FROM docQry ORDER BY sysModule > > > 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
Query of Queries Error
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: SELECT * FROM docQry ORDER BY sysModule 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
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";
>
>
>
>
> SELECT *
> FROMqCombinedProjects
> ORDER BY #URL.sOrderBy# #URL.sOrderType#;
>
>
>
>
> SELECT *
> FROMqCombinedProjects
> ORDER BY dtStartDate DESC;
>
>
>
>
> 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
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";
SELECT *
FROMqCombinedProjects
ORDER BY #URL.sOrderBy# #URL.sOrderType#;
SELECT *
FROMqCombinedProjects
ORDER BY dtStartDate DESC;
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
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
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
Query of Queries Error
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 - solution
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
RE: Query of Queries error - solution
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
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
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
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
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
>
>
>
> 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
>
>
>
>
>
>
~|
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
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 > > > > 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 > > > > > > ~| 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
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 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 ~| 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
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 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 ~| 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
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 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 ~| 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: My Query of Queries error with code
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
My Query of Queries error with code
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: SELECT * FROM GetLevel2Content UNION SELECT * FROM GetLevel3Content UNION SELECT * FROM GetLevel4Content UNION SELECT * FROM GetLevel5Content UNION SELECT * FROM GetPrograms ORDER BY Score desc ~| 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
Redsky-Query of Queries Error with = statement
Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. 237 : AND PSchedule_Date = 238 : AND Pschedule_BaseID Is Not Null 239 : AND PSchedule_BaseID = 240 : 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=subscribe&forumid=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
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 lstFields = arguments.query.Columnlist; qTemp = QueryNew(lstFields); QueryAddRow(qTemp,1); QuerySetCell(qTemp,ii,''); QueryAddRow(qTemp,1); QuerySetCell(qTemp,ii,evaluate(ii)); ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
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: it's a bit cleaner imho. -- jon mailto:[EMAIL PROTECTED] Tuesday, July 1, 2003, 4:52:23 PM, you wrote: JA> Heres the function in a cfc thats 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> returntype=query JA> hint=Appends a query in a named instance output=No> JA> JA> JA> JA> JA> this.#arguments.InstanceName# = arguments.query; JA> JA> JA> JA> SELECT * FROM this.#arguments.InstanceName# JA> UNION ALL JA> SELECT * FROM arguments.Query JA> JA> JA> JA> JA> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Heres the function in a cfc thats causing the error. It seems like the problem re-occurs whenever the runtime query being appended does not match the first one instantiated:-( this.#arguments.InstanceName# = arguments.query; SELECT * FROM this.#arguments.InstanceName# UNION ALL SELECT * FROM arguments.Query ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
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=subscribe&forumid=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
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) dont 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, Ive 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=subscribe&forumid=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
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] SELECT site_id, name, wins, losses, dist_wins, dist_losses FROM teamStandings ORDER BY dist_wins DESC -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=lists&body=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
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
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 > > > > > > > > > > > > > > > > > > __ 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
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
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
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
