Re: parentheses in keywords
rob caSSon <[email protected]>
| Newsgroups | gmane.text.refdb.devel |
|---|---|
| Message-ID | <[email protected]> |
> getref ":KW:='10102-43-9 (Nitric Oxide)'" > > works like a charm. The trick is to employ the double quotes to hide > the single quotes from the query parser. This way they'll be left > alone until the SQL tokenizer works on the actual query. i bet this works with sqlite...i'll have to give it a try, but the RLIKE still wants the parentheses quoted in mysql according to the logs... i'll try to test postgresql later tonight, if i get the chance... staying db-agnostic is often a pain, but i'm glad you're doing it.... ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn