Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Advanced Search form database queries

by Basilides (Friar)
on Jul 30, 2002 at 12:11 UTC ( [id://186175]=note: print w/replies, xml ) Need Help??


in reply to Advanced Search form database queries

Well, I've quite frequently seen queries in rows of 3 elements: a list box with the columns in your db (or plain english names for them), another list box of operators (=, >, <, >=, <=, contains, etc.), and then a text box for the search value.

At the end of each row, you have a button which will allow the user to add another row to the query. I think where I've seen it used, there's an implied AND between the rows. You run into permutation problems with nesting if you offer an OR option between rows.

HTH--I guess it's stating the obvious, but I thought I'd let you know--this seems a fairly common way of doing things. My company organises its search forms this way.

  • Comment on Re: Advanced Search form database queries

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://186175]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (6)
As of 2024-04-23 22:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found