Re: search query analyzer

Paul Godard wrote:

Hi I am looking for some good ideas to combine some fields with query operators (multiple words, or/and, >/„/¾<, range of numerical values...). Let's say I have 2 fields (numerical & text) to combine where the serach criteria can be as complicated as this : - year : >1950, 1960-1965, not1980-2000, >2002 - subject : (boy and bicycle) or (man and tractor) Is there a bullet proof function that can filter such field values and return a valid sql query? I sure hope not, if such things existed in the API we would all be out of jobs :-)

before you get started, i suggest taking a look at full text indexing , you will find that a lot friendlier than ordinary look ups. -- Raditha Dissanayake. --------------------------------------------- http://www.radinks.com/print/upload.php SFTP, FTP and HTTP File Upload solutions