parentheses in keywords

"Markus Hoenicka" <[email protected]>
Newsgroups gmane.text.refdb.devel
Message-ID <[email protected]>
Markus Hoenicka writes:
 > I'd rather suspect it's my fault. I can reproduce it over here, but I
 > think that the problem is unrelated to SQL parser problems. I guess it
 > is my query parser that screws up things. As a temporary workaround,
 > something like (using SQLite):
 > 
 >   getref -t risx :KW:="10102-43-9 (Nitric Oxide%"
 > 
 > should do the trick. I'll try to get back with a fix asap.
 > 

Looks like it is a lot easier:

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.

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de




-------------------------------------------------------
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.