... although you did show me below that its OK to throw CFIF's into the
query itself... I have always wrapped the query within the CFIFs
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 8:15 AM
To: CF-Talk
Subject: RE: Sorting Logic question
There is nothing wrong at all with this approach...
<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]
