Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Multiple Keywords search not working with Regular

Quote Reply
Multiple Keywords search not working with Regular
I want to be able to put in multiple keywords into the keyword field to do a 'OR' search. I tried putting 'word1 | word2' in keyword box, and clicking Regular expression option it does not seem to work in DBMan SQL. It gives no matching records.

But if I search for word1 or word2 separately the keyword search works perfectly. The regular expression option does not work.

Has anybody faced this problem ?? I would appreciate any help in finding a solution to this problem.

Thanks.

Quote Reply
Re: Multiple Keywords search not working with Regular In reply to
|| = or NOT |

Regards,

Eliot Lee
Quote Reply
Re: Multiple Keywords search not working with Regular In reply to
Eliot,

I tried giving || in between words, I am trying to search, it did not work. Again I get no matching records.

It seems to me that regular expressions search is just not provided for in DBMan SQL. I looked at the db.cgi, and searched for any mention of regular expression - it does not have any mention. Specifically in sub query - I read thru the whole sub - it does not seem to handle regular expressions - therefore OR searches. Am I missing some code in the db.cgi? Is these any fix for this.

FYI I am working with version 1.01 of db.cgi for DBMan SQL.