CALTRADE
Alex, again thank you for responding, but I don't think that approach will work. It looks like this may be a way to force people to enter a value, but all you have done is add a new field to the predefined values table with a value of "0" (zero). Zero is not a null value - it is an actual value of zero. That means when you try to create a search form with this, it will be searching for that "zero" value.

So if you have a search with two fields - lets say "hair color" see more and "eye color" to use your example. You want to find members with brown hair, but you don't care about eye color so you select "brown" for hair color but leave "not selected" for eye color. This will search the database for "brown hair" and the actual value of "not selected" (zero). Using your approach, this will not return any results- the query will be looking for members with brown hair AND "o" (not selected) but since "not selected" is not null - it is an actual value, there won't be any members with both those fields so the search won't work. Please let me know if there is something I don't understand here.
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.093512058258057