Thank you Ben, that solved my problem as far as I know.
>
> Try this to take care of data casting issues:
>
> http://www.bennadel.com/index.cfm?dax=blog:237.view
>
> When setting the score set the value using JavaCast( "float", 1. ).
>
>
> Hope that helps.
>
>
..
>
A quick guess is the column type for score or rank
The cfsearch result query is likely to have rank and score as a numeric
type.
Maybe variables.rrank breaks this. Is it just Rank ie can you order by
Score?
- Original Message -
From: "Michael Beins" <[EMAIL PROTECTED]>
To: "CF-Ta
Try this to take care of data casting issues:
http://www.bennadel.com/index.cfm?dax=blog:237.view
When setting the score set the value using JavaCast( "float", 1. ).
Hope that helps.
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need Cold
I had tried doing a to_char but that didn't work so I did some reasearch and
found if I used this select dbms_lob.substr( name, 32765, 1 ) I was able to do
this select to_char(dbms_lob.substr( name, 32765, 1 )) and then I was able to
do a query of a query.
Bob Everland
Ah, yes, possibly. CLOBS and VARCHARs are very different - if you want
to be able to do a LIKE clause in the QoQ, try using
to_char(theCLOBColumn) in the original query (assuming the text is
small enough).
On 1/13/06, Robert Everland III <[EMAIL PROTECTED]> wrote:
> Another thing to add is the fie
Another thing to add is the field is a CLOB from Oracle, could that have
anything to do with why I can't query that field?
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229362
Archives: http://www.houseoffusi
I'm just trying to integrate the new changes to lighthouse into the 6.1
version, nothing crazy. I did a dump of the query and it has the column in it
select *
fromissues
where 1=1
and bugtype =
Can we see your code?
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: 12 January 2006 13:11
To: CF-Talk
Subject: Query of query error
Does anyone know why a query of a query would return this error. The column
was description, but I changed it to bobTest to m
> There's no database. The query is built dynamically from
> data on another website.
When you populate the query object, try using Val to populate your numeric
columns.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This Mes
ssage-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 11:15 AM
To: CF-Talk
Subject: RE: Query of Query Error
> Ok, I queried the original query to get only rows which had
> numeric values for price, beds, baths... Then, I queried the
> new que
> Ok, I queried the original query to get only rows which had
> numeric values for price, beds, baths... Then, I queried the
> new query. I get the same error.
>
>
> select *
> from variables.listings.qResults
> where price <> ''
> AND beds <> ''
> AND baths <> ''
>
>
> select * f
Did you verify that your where clause is working? Theoretically, you should
be using "WHERE bed is not null" not where bed <> '' (assuming the original
column is a number column).
- Original Message -
From: "Brad Roberts"
> Ok, I queried the original query to get only rows which had numer
x27;'
select *
from temp
where price between 1 AND 999
AND beds >= 0
AND baths >= 0
-Brad
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 10:50 AM
To: CF-Talk
Subject: RE: Query of Query Error
> I ge
> I get the following error:
> Query Of Queries runtime error.
> Unsupported type comparison.
>
> Here's my code:
>
>
> select *
> from variables.listings.qResults
> where price between 1 AND 999
> AND beds >= 0
> AND baths >= 0
>
> --
Okay, so I tried using val() both when values get added to the query and in
the query of query -- I currently have this code:
SELECT nick, message FROM history
WHERE msgid > #val(attributes.cleared)# AND
( nick = '' OR nick = '#trim(ucase(attributes.nick))#'
awesome, thanks. :)
>> So I'm guessing that MX is creating the msgid column as a
>> varchar column
> and
>> it's complaining about "msgid > #attributes.cleared#" ...
>> So does anybody
>> know how to set the data type on a query column created
>> using querynew()
> in
>> MX?
> I've had success wi
> So I'm guessing that MX is creating the msgid column as a varchar column
and
> it's complaining about "msgid > #attributes.cleared#" ... So does anybody
> know how to set the data type on a query column created using querynew()
in
> MX?
I've had success with this problem by putting putting Val()
Arrgghh
So I changed the name of the column. ( Thanks Matt :) and now it produces
this error on MX (not on CF5).
Error Executing Database Query.Query Of Queries runtime
error. Unsupported type comparison. The specific sequence of files
included or processed is: C:\CFusionMX\wwwroot\dev\talkon
It's the other "from" -- the "OR from =" section. Perhaps [from]?
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Thursday, 13 March 2003 1:31 p.m.
To: CF-Talk
Subject: query of query error -- works on mx bombs on cf 5
I've got this query of query that's work
Oooops!! the title of my last post was stricken by some random dyslexia. :)
should read works on CF 5 bombs on MX
> I've got this query of query that's working on CF 5... On
> MX it produces
> this error:
> Error Executing Database Query.Query Of Queries
> syntax error.
> Encountered ""from"" at
20 matches
Mail list logo