Fw: what am i doing wrong with this qualifier
Fw: what am i doing wrong with this qualifier
- Subject: Fw: what am i doing wrong with this qualifier
- From: Theodore Petrosky <email@hidden>
- Date: Tue, 25 Jan 2011 15:09:46 -0800 (PST)
i should have included the error section:
--- On Tue, 1/25/11, Theodore Petrosky <email@hidden> wrote:
> From: Theodore Petrosky <email@hidden>
> Subject: what am i doing wrong with this qualifier
> To: email@hidden
> 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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden