db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Quinton McCombs <qmcco...@nequalsone.com>
Subject [SOURCE] Issue #TRQS91 modified
Date Mon, 09 Dec 2002 23:05:24 GMT

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.  




Mime
View raw message