In Entity Modeller I used prototype: date
data type: Date (D)
External Type: timestamp
Class: com.webobjects.foundation.NSTimestamp
point me to check something?
Ted
--- On Tue, 1/25/11, Michael Gargano <mgarg...@me.com> wrote:
> From: Michael Gargano <mgarg...@me.com>
> Subject: Re: what am i doing wrong with this qualifier
> To: "Theodore Petrosky" <tedp...@yahoo.com>
> Cc: "webobjects-dev@lists.apple.com" <webobjects-dev@lists.apple.com>
> Date: Tuesday, January 25, 2011, 6:15 PM
> sounds like your mapping is wrong on
> that property
>
> -mike
>
> Sent from my iPhone
>
> On Jan 25, 2011, at 6:09 PM, Theodore Petrosky <tedp...@yahoo.com>
> 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/mgargano%40me.com
> >
> > This email sent to mgarg...@me.com
>
_______________________________________________
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
