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 <[email protected]> wrote: > From: Michael Gargano <[email protected]> > Subject: Re: what am i doing wrong with this qualifier > To: "Theodore Petrosky" <[email protected]> > Cc: "[email protected]" <[email protected]> > 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 <[email protected]> > wrote: > > > i should have included the error section: > > > > > > --- On Tue, 1/25/11, Theodore Petrosky <[email protected]> > wrote: > > > >> From: Theodore Petrosky <[email protected]> > >> Subject: what am i doing wrong with this > qualifier > >> To: [email protected] > >> 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 protected]) > > Help/Unsubscribe/Update your Subscription: > > http://lists.apple.com/mailman/options/webobjects-dev/mgargano%40me.com > > > > This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
