<cfquery ...>
select a,b,c,d
from houses
where 0=1
<cfif isDefined("form.lotsize") and isNumeric(form.lotsize)>
and lotsize >= #form.lotsize#
</cfif>
etc
By the way, as a side comment - I recently ran across a real estate site
that wouldn't let me search by street. This was extremely annoying as I knew
the exact address of the house I wanted to look at.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
