Hi,
I have a qoq like so,
cfstoredproc
procedure=LEO4_ADMIN_DISTINCT_DAILY
datasource=#request.matrixDSN#
username=#request.matrix#
password=#request.neo#
cfprocresult name=q_distinctData
cfprocparam dbvarname=@customerid value=#attributes.id# cfsqltype=cf_sql_integer type=in
damn, I posted before I could get the rest in,
I get this error,
Error Executing Database Query.
Query Of Queries runtime error.
Unsupported type comparison.
Is this possible, or is there a work around, for example does hal helms
query sim tag support this.
[Todays Threads]
[This Message]
Is vehicleid field an integer or a varchar?If it's integer, you don't need
the single quotes.
WHERE vehicleid in (165,564)
From: John mccosker [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 11:35 AM
To: CF-Talk
Subject: Re: query of query question
I know I can add rows but is it possible to delete a record from a query
using QofQ.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Sparrow-Hood, Walter wrote:
I know I can add rows but is it possible to delete a record from a query
using QofQ.
Just select all the records except the one you want to delete.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads]
[This Message]
Just use a WHERE clause in your QofQ, and you can effectively delete rows.
-Original Message-
From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 1:03 PM
To: CF-Talk
Subject: Query of query question
I know I can add rows but is it possible to delete
Duh - it's been a long day - thanks.
-Original Message-
From: Jochem van Dieten [SMTP:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 4:15 PM
To: CF-Talk
Subject: Re: Query of query question
Sparrow-Hood, Walter wrote:
I know I can add rows but is it possible to delete a record
Subject: Query of query question
I know I can add rows but is it possible to delete a record from a query
using QofQ.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hi All,
I'm finally getting around to trying query a query to order info I'm shoving
into a WDDX packet. The packet contains three columns, a date, a string and
a string. Is it possible to order by the date field? When I order by this
column now is sorts the field but treats it like a string, so
PROTECTED]]
Sent: Thursday, December 12, 2002 12:11 PM
To: CF-Talk
Subject: Query a Query Question
Hi All,
I'm finally getting around to trying query a query to order info I'm shoving
into a WDDX packet. The packet contains three columns, a date, a string and
a string. Is it possible to order
That worked like a charm! thx!
Duane
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 3:20 PM
To: CF-Talk
Subject: RE: Query a Query Question
QofQ doesn't seem to do dates well at all. One work around that we have used
is if you format
I'm querying a search resultset and getting an error. It must be some kind
of syntax thing but I don't see it. Does anyone see a problem with this
query.
The first query returns the following:
CUSTOM1 CUSTOM2 KEY RECORDSSEARCHED SCORE
SUMMARY
April 2002
Try a single quote!
On Tuesday, September 17, 2002, at 05:57 AM, Smith, Daron [PA] wrote:
I get error: Can't find symbol:
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and
Try single quotes.
Collin Tobin
QA Engineer
617 219 2000
[EMAIL PROTECTED]
Macromedia®
What the web can be.(tm)
-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 8:58 AM
To: CF-Talk
Subject: query of query question
I'm querying
is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 8:58 AM
To: CF-Talk
Subject: query of query question
I'm querying a search resultset and getting an error. It
must be some kind
, and a powerful ally it is. - Yoda
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 9:05 AM
To: CF-Talk
Subject: Re: query of query question
Try a single quote!
On Tuesday, September 17, 2002, at 05:57 AM, Smith, Daron [PA] wrote
Quoting Smith, Daron [PA] [EMAIL PROTECTED]:
The first query returns the following:
CUSTOM1CUSTOM2 KEY RECORDSSEARCHED SCORE SUMMARY
April 2002 article 970 1421 0.7742 ...
-100 25251421 0.7742 ...
What datatypes?
: query of query question
I'm querying a search resultset and getting an error. It must be some
kind
of syntax thing but I don't see it. Does anyone see a problem with this
query.
The first query returns the following:
CUSTOM1 CUSTOM2 KEY RECORDSSEARCHED SCORE
SUMMARY
April 2002 article
Quoting Raymond Camden [EMAIL PROTECTED]:
Are you using CFMX? I believe this issue relates to the fact that
QofQ makes assumptions based on the data in the original query. In
your data below - your first row in the column custom 1 has a data.
April 2002 is not a date, it is a string. A date
Single quote returns the same thing, April 2000 is not a number (meant to
include in original msg, double quotes was just a WAG). The original query
is a cfsearch resultset so .
I'm using CF5 so does the assumptions thing with MX still apply? Is there
a way that I can tell it to assume that
Hi
I have a query which is held in the session scope
and when trying to query this query:
I find I get an error if I scope the variable(I know its supposed to be
locked)but not if I dont scope the variable:
cfquery name=getQuantity dbtype=query
SELECT
quantity
FROM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 9:10 AM
To: CF-Talk
Subject: Query of query question
Hi
I have a query which is held in the session scope
and when trying to query this query:
I find I get an error if I scope the variable(I know its supposed to be
locked)but not if I dont
Well if this were to work, I would think you would need to make a
modification or two (but I'm not saying it could work):
cfquery name=getQuantity dbtype=query
SELECT
quantity
FROM
session.basket
!--- might need to add # signs to the above? ---
WHERE
!--- session.basket.
of query question
Well if this were to work, I would think you would need to make a
modification or two (but I'm not saying it could work):
cfquery name=getQuantity dbtype=query
SELECT
quantity
FROM
session.basket
!--- might need to add # signs to the above? ---
WHERE
24 matches
Mail list logo