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 t
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"
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.a
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 val
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 nam
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 g
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
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 remo
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
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 || [emp
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 cas
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
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
>
>
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() wher
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 th
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
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 us
ecordset 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
lto:[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
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.
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 an
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.
Error Executing Database Query.
Query Of Queries runtime error.
Unsupported type comparison.
237 : AND
PSchedule_Date =
238 : AND
Pschedule_BaseID Is Not Null
239 :
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
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
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.
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
> th
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 retu
s,
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
t; <[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 col
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
>
>
>
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 cau
"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 que
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 data
34 matches
Mail list logo