hi tim, please provide the sql generated by ojb.
jakob ----- Original Message ----- From: "Tim Drury" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 8:49 PM Subject: QueryByCriteria using Float returns nothing > > I'm writing a simple OJB hello-world type app to test if OJB > will work for me. My Foo object has Integer and Float > properties that I'm trying to query on. > > If I set up a query object with all fields null except the > Integer field, I get my Collection back with no problems. > > However, if I query on the Float field I get nothing back. > I know in languages that use IEEE floating point, you cannot > simpy compare two floats without including some sort of > tolerance, but I didn't think SQL required this. If I > take the query from the spy.log and execute it in the > psql query tool (btw, i'm using postgres obviously) I _do_ > get my rows back. But the collection returned by > broker.getCollectionByQuery(query) has no elements and > broker.getCount(query) returns 0. > > Has anyone experienced this? > > -tim > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
