Criteria with a like

[Rob Broadhead]

I am doing a select with a like as shown below and I have to enter the 
column name as a string instead of using the static member of the peer. If 
I use the member then it builds the sql to find 
tablename.tablename.columnname instead of tablename.columnname is this me 
using the API incorrectly or is it something I set wrong when generating 
the peers? I am using torque 3.1 with Postgres if that helps.

String name = "test client%";
Criteria crit = new Criteria;
crit.add(ClientsPeer.TABLE_NAME,"CLIENTNAME",name,Criteria.LIKE); // works
// 
crit.add(ClientsPeer.TABLE_NAME,ClientsPeer.CLIENTNAME,name,Criteria.LIKE); 
// does not work

Thanks,
Rob


//--------------------------------------------------------------------
Rob Broadhead - Consultant
RB Consulting Inc.
[EMAIL PROTECTED]
//-------------------------------------------------------------------- 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]