[FX.php List] How do I contrain a found set?

Edward L. Ford elford at cs.bu.edu
Sat Aug 5 21:27:10 MDT 2006


Hello all,
How would one constrain a found set with FX?

In my situation, the database has a group of fields that are considered 
search able for users, and then there's a special approved field, which 
can be set to either Yes or No -- end users should only see records that 
have Yes for the Approved field.

Currently, there is a page for a user to perform a search on multiple 
fields.  I want to first perform a Find, using the criteria input into 
an HTML form -- I've already got that figured out.  Now I want to 
constrain the found set based on if Approved is set to yes or not.  How 
would I do that?

Right now, I just have $SearchParams->AddDBParam('Approved', 'Yes'); in 
with the rest of the items input from the HTML POST.  Because the search 
is a logical OR search, having it set this way returns all of the 
approved records -- since I set the Approved param record to yes, all 
approved records have that match, and thus are returned, essentially 
negating the criteria entered by a user into the HTML form.  (Does that 
make sense to anyone else but me?)

Let me know any suggestions,
--Ed F.



More information about the FX.php_List mailing list