ok, i have a query sth like: select class1 from org.apache.ojb.mytest.MyClass where field="sth" it works andif i have sth like select class1 from org.apache.ojb.mytest.MyClass where class1.field="sth" I get the following error : Unknown table 'class1' in where clause General error: Unknown table 'class1' in where clause java.sql.SQLException: General error: Unknown table 'class1' in where clause at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:498) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:551) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:927) at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:288)
is the syntax of second query wrong? pls let me know, thanks __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
