Re: what am i doing wrong with this qualifier
Re: what am i doing wrong with this qualifier
- Subject: Re: what am i doing wrong with this qualifier
- From: Chuck Hill <email@hidden>
- Date: Tue, 25 Jan 2011 15:12:01 -0800
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 <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
--
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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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