sql_language thread: need help in building sql query
Sounds like you could do it a few ways: Build in logic into your page/component that puts a "point" value for each matched boolean operand. So if someone selected terrace, swimming pool, and gated community, then the properties that matched all three would have 3 points, only two 2 points (only as an example) Then display your records based on a descending point order.
|





