Thanks, Alex. We have a workaround in place now by comparing against
97, the ASCII value of 'a'. This will work for now, and we'll probably
just leave it that way as this query will likely never change.
Thanks again,
-M@
On Wednesday, August 27, 2003, at 06:36 AM, Alexey Loubyansky wrote
char is a numeric type.
11.2.7.1 Literals
An exact numeric literal is a numeric value without a decimal point,
such as 57, -957, +62. Exact
numeric literals support numbers in the range of Java long. Exact
numeric literals use the Java integer
literal syntax.
alex
Matthew Hixson wrote:
I have
I have a JBoss-QL query that contains
o.approvalCode = 'a'
in the where clause. This is causing JBoss to throw:
nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered "\'a\'" at line 1, column 229.
Was expecting one of:
"ABS" ...
"LENGTH" ...
"LOCATE" ...