[thelist] CFQuery sub search...

.jeff jeff at members.evolt.org
Thu Nov 1 12:17:01 CST 2001


susan,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Susan Wallace
>
> I know that the answer to this is in the forums, but
> they have been down all morning and I am impatient. ;)
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

what forums?

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> I need to allow users to "Search within these results".
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

sounds like a typical "existing keywords" AND "new keywords" type search.

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> I know that a query object is available to me after I
> run a CFQUERY, and that these are available:
>
> query_name.ColumnList
> query_name.currentRow
> query_name.recordCount
>
> How do I construct a query to use these variables in
> the "next" search.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

i don't think you'll find that these queries are going to help you.  if
you're running cf5, you could use a query of a query.

however, if you don't have cf5, then you can one of two things.  either
bruteforce the search by first performing the query the with "existing
keywords", getting that resultset back, and looping over it looking for the
"new keywords".  or you can make ultra crazy with the sql syntax for your
search.

SELECT *
  FROM tablename
 WHERE (#logic for "existing keywords")
   AND (#logic for "new keywords")

rudy, you got any ideas?

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/






More information about the thelist mailing list