Are you sure that is the right error text? Formatting a number seems to have nothing to do with fetching against a date...
On Jan 25, 2011, at 3:09 PM, Theodore Petrosky wrote:
> 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/chill%40global-village.net
>
> This email sent to ch...@global-village.net
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall
knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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
