> select a,b,c,d
> from houses
> where 1=1
> <cfif isDefined("form.lotsize") and
> isNumeric(form.lotsize)>
> and lotsize >= #form.lotsize#
> </cfif>
> etc
The 1=1 part is just a dummly clause so I can have a set of "and PROPERTY =
#FORMVALUE#" lines.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
