Issue TRQS91 has just been modified by user quintonm

You can view the issue detail at the following URL:
     <http://scarab.werken.com/scarab/issues/id/TRQS91>

The following modifications were made to this issue:

Criteria crit = new Criteria();

crit.add(PersonPeer.LAST_NAME,(Object)((String)lastName.getValue() + 
"%"),Criteria.LIKE);
crit.setIgnoreCase(true);
crit.addAscendingOrderByColumn(PersonPeer.LAST_NAME);
crit.addAscendingOrderByColumn(PersonPeer.FIRST_NAME);

List v = PersonPeer.doSelect(crit);

In this example, any rows in the database which have a null value for 
PersonPeer.FIRST_NAME will be omitted from the returned list.  




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

Reply via email to