i should have included the error section:
--- On Tue, 1/25/11, Theodore Petrosky <tedp...@yahoo.com> wrote: > From: Theodore Petrosky <tedp...@yahoo.com> > Subject: what am i doing wrong with this qualifier > To: webobjects-dev@lists.apple.com > Date: Tuesday, January 25, 2011, 6:06 PM > theDate is an NSTimestamp; > > EOQualifier qualifier = ERXQ.is("invoiceBookedDate", > theDate); > > ERXFetchSpecification<Invoice> fs = new > ERXFetchSpecification<Invoice>(Invoice.ENTITY_NAME, > qualifier, sortOrderings); > NSLog.out.appendln("fs = " + fs); > > fs = <class > er.extensions.eof.ERXFetchSpecification(entityName=Invoice, > qualifier=(invoiceBookedDate = > (com.webobjects.foundation.NSTimestamp)'2010-12-06 00:00:00 > Etc/GMT'), > isDeep=true, usesDistinct=false, > sortOrdering=(<class > er.extensions.eof.ERXSortOrdering(invoiceBookedDate > compareAscending)>), > hints=null, > _prefetchingRelationshipKeyPaths = null)> > er.extensions.components._private.ERXWOString - Exception while formatting NumberFormatException: Infinite or NaN at java.math.BigDecimal.<init>(BigDecimal.java:797) at com.webobjects.foundation.NSNumberFormatter.stringForObjectValue(NSNumberFormatter.java:1026) at com.webobjects.foundation.NSNumberFormatter.format(NSNumberFormatter.java:1654) at er.extensions.formatters.ERXNumberFormatter.format(ERXNumberFormatter.java:250) at java.text.Format.format(Format.java:140) ... skipped 31 stack elements Jan 25 17:58:33 TheWorkTracker[62782] INFO er.extensions.components._private.ERXWOString - Exception while formatting NumberFormatException: Infinite or NaN at java.math.BigDecimal.<init>(BigDecimal.java:797) at com.webobjects.foundation.NSNumberFormatter.stringForObjectValue(NSNumberFormatter.java:1026) at com.webobjects.foundation.NSNumberFormatter.format(NSNumberFormatter.java:1654) at er.extensions.formatters.ERXNumberFormatter.format(ERXNumberFormatter.java:250) > If qualifier = null; I get the entire list (the query > works). and the sql: > > select * from t_invoice where c_invoice_booked_date = > '2010-12-06 0:00:00 Etc/GMT'; > > works beautifully. > > Am I just being brain dead? > > Ted > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com