I am stuck creating the RIFE equivalent of an SQL query such as:
delete from table where X and ( P or Q or R )
I'm struggling with code like this which I think should work but doesn't:
Delete delete = new Delete( source );
delete
.from( table )
.where( "field1", "=", value1 )
.startWhereAnd()
.startWhereOr();
for ( String valuen : orValues ) {
delete.whereOr( "fieldn", "=", valuen );
}
Anyone got an example of how to use the startWhereAnd()/startWhereOr()
methods of query manager to simulate bracketed SQL queries like the above?
Thanks,
David Herbert.
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
