u will need it when u do a closed search. i dont know if my terming is
correct, but here is an example. I do a search on monster.com on "Cold
Fusion", and it returns 25 results. On that results page,. I have the
option to search my results, u know, querying a query. let's say that i
want to know which of these 25 results have "Houston" in them. in CF 5, i
just query the the original query. Of course, there are other ways to do
the same exact thing without using this "special" function from CF 5. like,
for example, I can save SQL statements in a hidden field, and when they want
to do another search within the search, I just add another "WHERE" criteria
into the SQL statement. Another method is to just tell your users to click
back, and type in more keywords! hehe
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 10:36 AM
To: CF-Talk
Subject: Re: Can we do another select on a cfquery resultset?
Haven't really paid much attention to CF5's features - but the Query-a-Query
does sound great. How might it work though? I can't think of many
occasions when I've needed it.
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
----- Original Message -----
From: ""Ben Forta"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Wednesday, March 21, 2001 1:13 PM
Subject: RE: Can we do another select on a cfquery resultset?
> That's a new feature in CF5 (in beta right now).
>
> --- Ben
>
>
> -----Original Message-----
> From: JAIME HOI [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 7:54 AM
> To: CF-Talk
> Subject: Can we do another select on a cfquery resultset?
>
>
>
> hi
> i was juz wondering if it is possible to do a select on the resultset
> returned from <cfquery>?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists