me, search, COUNT(search) AS searchCount
FROM auctionSearch
GROUP BY domainname, search
ORDER BY searchCount DESC
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 5:21 PM
To: CF-Talk
Subject: RE: Can a QofQ be performed on result set of a cfhttp call?
Please disregard. I've figured out the problem.
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 2:31 PM
To: CF-Talk
Subject: Can a QofQ be performed on result set of a cfhttp call?
I can't get past this. Any ideas? Gracias.
http://www.mydo
Not sure, but I don't think you can do a GROUP BY on a Q of Q. The SQL
functionality on QoQ is severely limited. To see if your Q of Q
actually works, take out the GROUP BY and Count(), and see if it
works.
> url="http://www.mydomain.com/data.txt";
> name="auctionSearch"
>
I think you problem is this:
GROUP BY COUNT(search)
I don't think you can group on an aggregate. You have to group on a
field and then SELECT or ORDER BY aggregates of that field:
SELECT domain, search, COUNT(search) AS searchCount
FROM auctionSearch
GROUP BY domain, search
ORDER BY COUNT(sea
> Subject: Can a QofQ be performed on result set of a cfhttp call?
Yes, if the CFHTTP call returns a query object (as yours does below).
> I can't get past this. Any ideas? Gracias.
>
>url="http://www.mydomain.com/data.txt";
> name="auctionSearch"
> textqualifier="">
>
>
>
What error do you get? Query of query can be used on _any_ query result in CF.
On Dec 3, 2007 1:30 PM, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> I can't get past this. Any ideas? Gracias.
>
> url="http://www.mydomain.com/data.txt";
> name="auctionSearch"
> textqualifier=""
6 matches
Mail list logo
