Originally Said By: Jason Byrnes
Use " 0 <> 0" instead of "WHERE 0 <> 0"; 
Hi Jason,
Sorry for the delay. I've been really backed up. ;-)
OK, it no longer chokes. But it's either not doing what it's supposed to or I'm not understanding correctly.
What I'm trying to acomplish is:
If on some page on the site, a user clicks the Search button for the search form without having filled in a search criteria, they do not see any matches on the results page. (And I redirect them to a differnt page with WA Server Redirect.)
What is currently happening is that when the user does the above, they are shown all records.
I had hoped / thought that adding the 0 <> 0 would accomplish the task.
Going to look for vegies and fruit but will be back soon.
Thanks,
David
