in reply to How to parse a QUERY_STRING and construct an sql query out of that ?

Have a look at SQL::Abstract. It turns a Perl data structure into an SQL query.

So all you have to do is parse your QUERY_STRING into a data structure and give the data structure to SQL::Abstract.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

My blog: Imperial Deltronics
  • Comment on Re: How to parse a QUERY_STRING and construct an sql query out of that ?

In Section Seekers of Perl Wisdom