<SNIP>
> <CFIF Form.ponnumber neq "">
> <CFSET Searchpon=Where ponumber like '%#Form.ponumber#%'
> <CFIF FORM.invoicenumber neq "">
> <CFSET SearchInv="And invoicenumber LIKE'%#FORM.invoicenumber#%'"
> </CFIF>
Actually the 0=0 (or something like it) is required, in your example code
included above if form.ponnumber is indeed blank then your statement would
be entirely missing the WHERE statement although it could have many AND's,
this will cause an error.
--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
