I check the Criteria object right before I perform the doSelect(), and it has the proper database name, so I guess my problem lies elsewhere..
I'm puzzled as to how something as fundamental as ORDER BY is not working properly in torque.. Anyway, thanks for the suggestion, but do you have any other ideas since that didn't do the trick? Thanks again. > -----Original Message----- > From: Akmal Sarhan [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2003 4:05 AM > To: Turbine Users List; [EMAIL PROTECTED] > Subject: Re: Criteria.addAscendingOrderByColumn() bug? > > try initializing Criteria by passing the name of your db to the it ;-) > > regards > Akmal > ----- Original Message ----- > From: "Tim Clotworthy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 09, 2003 10:09 PM > Subject: Criteria.addAscendingOrderByColumn() bug? > > > > Hello, > > I was hoping some could tell me whether there are any know bugs with the > > org.apache.torque.util.Criteria. addAscendingOrderByColumn() method? I > > have a very simple query: > > > > FESCriteria crit = new FESCriteria(); > > crit.addAscendingOrderByColumn(RefTransactionCodesPeer.TYPE_OF_TRANSACTI > > ON); > > > > transList = (ArrayList) RefTransactionCodesPeer.doSelect(crit); > > > > If I leave out the addAscendingOrderByColumn line, it works fine. When > > included, I get an exception: > > > > java.lang.NullPointerException > > at > > org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1209) > > at > > org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927) > > at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1321) > > at > > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelectVillageRecords( > > BaseRefTransactionCodesPeer.java:398) > > at > > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelectVillageRecords( > > BaseRefTransactionCodesPeer.java:366) > > at > > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelect(BaseRefTransac > > tionCodesPeer.java:334) > > at > > com.hotapp.fes.support.FESSupportDAO.selectTransTypes(FESSupportDAO.j > > ava:202)...blah, blah, blah.. > > > > I have verified that the RefTransactionCodesPeer.TYPE_OF_TRANSACTION is > > equivalent to a valid and appropriate String value, so its not that. > > > > Any ideas would be greatly appreciated. Thanks. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
