The OJB OQL Parser supports the LIKE operator.
for reasons beyond our control the official ODMG OQL grammar did use only lowercase letters.
So you should simply try to use "like" instead.
Thomas
Eric Northam wrote:
Does anyone know the syntax for the LIKE operator or whether it's even
supported? I tried the following the following; two of which I took from the
POET OQL Reference Guide.
where lastName LIKE "Si*"
where lastName = "Si*"
where lastName LIKE "Si%"
where lastName = "Si%"
The LIKE operator appears to be ignored and results in all rows being
returned. Nothing is returned in the other scenarios.
Eric
DISCLAIMER: The information contained in this e-mail is, unless otherwise indicated, confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
