You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Dieter Engelhardt <D-...@t-online.de> on 2002/12/06 23:50:49 UTC

select * from ...

How do i accomplish a simple select * from sometable without specifing every
selectColumn.

Example:

Criteria criteria = new Criteria();
criteria.addJoin(TbOrtPeer.OLP_ID, TbOrtLookupPeer.OLP_ID);
criteria.add(this.getPeer().ORT_ID, iOrt_ID);
List v = this.getPeer().doSelect(criteria);

i'll get an exception "Syxntaxerror in SQL-Statement"

It looks like the statement misses the * as a wildcard for all columns.

If i try add criteria.addSelectColumn("*");

I get an exception "Malformed column name in Criteria select: '*' is not of
the form 'table.column'"

What's wrong?
How can i do it right?

Thanx for your help
Dieter




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>