M
mpeters
Hello,
I am sure this has been done lots of times but I can't seem to find some
examples. I need to write an SQL interface that allows the user to
specify fairly straightforward conditional clauses. Like,
first_name='john' and age < 30
I imagine I would have a list of field names on one side and a list of
entry fields on the other where the user could specify the data. I
guess the trick is how to let the user specify the connectors like
"and", "or", or even put them in parentheses. I am thinking some
Javascript library would come in handy here.
Is there something like this that I can re-use or take as a starting point?
I am sure this has been done lots of times but I can't seem to find some
examples. I need to write an SQL interface that allows the user to
specify fairly straightforward conditional clauses. Like,
first_name='john' and age < 30
I imagine I would have a list of field names on one side and a list of
entry fields on the other where the user could specify the data. I
guess the trick is how to let the user specify the connectors like
"and", "or", or even put them in parentheses. I am thinking some
Javascript library would come in handy here.
Is there something like this that I can re-use or take as a starting point?