0 ).
>
>
> Hope that helps.
>
>
..
>
> Ben Nadel
> Certified Advanced ColdFusion MX7 Developer
> www.bennadel.com
>
> Need ColdFusion Help?
> www.bennadel.com/ask-ben/
>
> -Original Message-
> From: Michael Beins [mailto:[EMAIL PROTECTED]
> Sen
This issue has been resolved, thanks everyone for your help.
> In my code I am running two cfsearches. The results from the second
> search need to appear at the top of the results from the first search.
> So I append them to the first set and manually set the score and the
> rank so can forc
TED]>
To: "CF-Talk"
Sent: Monday, November 13, 2006 12:45 PM
Subject: Query of Query Error
> In my code I am running two cfsearches. The results from the second
> search need to appear at the top of the results from the first search. So
> I append them to the first set
com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Michael Beins [mailto:[EMAIL PROTECTED]
Sent: Monday, November 13, 2006 7:46 AM
To: CF-Talk
Subject: Query of Query Error
In my code I am running two cfsearches. The results from the second search
need to appear
In my code I am running two cfsearches. The results from the second search
need to appear at the top of the results from the first search. So I append
them to the first set and manually set the score and the rank so can force the
results to the top in a query of a query.
That is where I am ge
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
Does anyone know why a query of a query would return this error. The column was
description, but I changed it to bobTest to make sure it wasn't a reserved word.
Error Executing Database Query.
Query Of Queries runtime error.
Query Of Queries runtime error.
Failed to get meta_data for columni
On Wednesday 26 May 2004 19:07 pm, Alexander Sherwood wrote:
> I'm not aware of any restrictions on the data types a CF query can contain.
> Am I wrong?
It would be restricted to valid SQL types, wouldn't it ?
How the hell do you get a CFC into a query column to run a QoQ on anyway ? I
think you
Has anyone run into errors when doing a Query of a Query where one of the columns holds a CFC?
I'm not aware of any restrictions on the data types a CF query can contain. Am I wrong?
Thanks!
--
Alex
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> 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
>
> --
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
--
I'm performing a couple of verity searches, and then performing a query of a
query to union the results and I'm getting the following error, that I'm
really unfamiliar with...
Query Of Queries runtime error.
All resulting columns of queries in a SELECT statement containing a UNION
operator must ha
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()
uot;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
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
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
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 line 5, column 44. Incorrect conditional expression,
Expected one of [like|null|between|in|comparison] condition, The specific
Have any of you run into this error before?
Query Manipulation Error Code = 0
Unable to instantiate environment for 'QUERY'.
Reason: 30 second timeout limit exceeded.
This code was running just fine a few days ago, today it errors
continuously. Here's the code:
=
Have any of you run into this error before?
Query Manipulation Error Code = 0
Unable to instantiate environment for 'QUERY'.
Reason: 30 second timeout limit exceeded.
This code was running just fine a few days ago, today it errors
continuously. Here's the code:
=
30 matches
Mail list logo