in reply to Advanced Search form database queries
The first thing that I think you should ask yourself is "Who is going to be using this 'Advanced Search'?" I would say go ahead and allow the user to write their own queries if:
I've had good success with the method you are currently using. It's intuitive enough for most users to comprehend without any instructions and it converts very easily into SQL statements when you need to parse the form.
I think the most important thing here is to get feedback from your users to find out if the Advanced Search capabilities you've offered are getting the job done for them. Maybe just have a small form on your results page that they can check whether or not they found what they were looking for.
~CubicSpline
"No one tosses a Dwarf!"
|
|---|