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
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 a
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
Do you mean delete it from the database, or exclude it from the results?
If you just want to exclude it, you could use a WHERE to eliminate it from
your new results.
-Original Message-
From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED]
Sent: November 12, 2003 3:03 PM
To: CF-Talk
QofQ doesn't seem to do dates well at all. One work around that we have used
is if you format dates thusly '-mm-dd' (which happens to be iso in xml)
you can order / sort in correct order using text functions.
good luck
Rob
-Original Message-
From: Duane Boudreau [mailto:[EMAIL
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
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
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. Later on, you
have a non date value. Therefore, when you QofQ against it - the system
gets
, 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?
Are you using single or double quotes in your query?
You should be using single quotes. eg.
select * from results where custom1 = '-100'
Stephen
- Original Message -
From: Smith, Daron [PA] [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 17, 2002 1:57 PM
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
Kola, I am not using query of query like that, what I am doing is running
successive queries against the first query as follows
cfquery name=getQuantity dbtype=query
SELECT
quantity, product, price
quantity*price AS total_value
FROM
qfirstquery (FIRST QUERY)
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.
Well it works but only if you dont scope the session var. I havent used cf5
much
so I just wondered if this was how it was supposed to work
Kola
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 7:40 PM
To: CF-Talk
Subject: Re: Query
19 matches
Mail list logo