users@glassfish.java.net

EJB QL syntax

From: <glassfish_at_javadesktop.org>
Date: Sat, 29 Sep 2007 20:35:37 PDT

[code]
"SELECT c FROM Categories c WHERE c.categoryname LIKE :categoryname%"
[/code]

or

[code]
"SELECT c FROM Categories c WHERE c.categoryname LIKE %:categoryname%"
[/code]

The error was "Unexpected char %". What did i do wrong?

btw, do you guys happen to have a reference guide for EJB QL? thanks alot
[Message sent by forum member 'eviljanca' (eviljanca)]

http://forums.java.net/jive/thread.jspa?messageID=237716