Re: filtering results based on url variables

2005-08-05 Thread Cameron Johnson
In case anyone is interested, or if someone digs into the archives for this topic, a friend helped me work out a javascript solution. The function basics are: var urlfield= '#url.field#; function filter(param, value) { switch (param) { case 'field' : urlfield = value; break; } location.href

Re: filtering results based on url variables

2005-08-01 Thread jonese
Hack option: if you know A == B then just do a listFirst(), or ListLast() :) otherwise you'll have to loop over the "list" and slam in an OR / AND to the SQL. jonese On 8/1/05, Cameron Johnson <[EMAIL PROTECTED]> wrote: > > Using a CFC, I've got a table of results from a getAllRecords method.

Re: filtering results based on url variables

2005-08-01 Thread Barney Boisvert
How about in your filter code, you unset any variable before you set it. that's prevent the duplication, and let you keep the rest of the code as-is. Most likely that'd be in the code that renders the link for adding filter so that it doesn't contain another value for the same filter it'd be sett

filtering results based on url variables

2005-08-01 Thread Cameron Johnson
Using a CFC, I've got a table of results from a getAllRecords method. I want to filter those results based on some variables that the user clicks on individually. So, in the getAllRecords method, my SELECT query will be: SELECT * FROM table WHERE value1 = #arguments.value1# AND value2 = #argum