[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