Hi,
sorry, i'm a little mad at the moment, you know....
I simply don't understand what is wrong with the following syntax.

SELECT OBJECT(c) FROM MyStoreItem AS c WHERE c.price = 0

I keep getting a error when trying to deploy the bean!
Can anyone help me? The log follows at the botton
Thanks a lot,
ltcmelo

2004-03-19 19:40:53,390 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(c) FROM MyStoreItem AS c WHERE c.price = 0'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "MyStoreItem" at line 1, column 23.
Was expecting one of:
"IN" ...
<ABSTRACT_SCHEMA> ...
)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:50)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:59)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:212)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
at sun.re
....
...
...
...