Hi Dave, Have you tried an ERD2WCustomQueryBoolean instead? I use a subclass of that in my framework and I don't recall having issues like this one.
Ramsey On Aug 25, 2011, at 12:17 AM, David Avendasora wrote: > Hi all, > > I'm have a boolean (in the DB as a VARCHAR(5), using the Wonder boolean > prototype) attribute that I want to be able to search on. When I search using > a text field (like you get on the default Query All > page(ERMODQueryEntitiesPage) it works as expectd. Typing true, True or TRUE > all work just fine for searching. > > But if I use the D2WQueryBoolean or ERD2WQueryBooleanRadioList on the normal > Query page it doesn't work. > > When searching for true, the DB query has: WHERE t0."IS_DUPLICATED" > '0' > When searching for false, the DB query has: WHERE t0."IS_DUPLICATED" = '0' > > So it's converting the boolean to 0 and 1, and then searching in the DB for > that number as a string. Uhg. > > When I do an update, it does: "IS_DUPLICATED" = 'true' > And since that column is a locking column, the WHERE clause has: > "IS_DUPLICATED" = 'false' > > So it appears that the D2WEditBoolean is properly converting the boolean to a > String. > > Why don't either D2WQueryBoolean or ERD2WQueryBooleanRadioList? > > Is there a rule I'm missing? > > Dave > _______________________________________________ > 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/rgurley%40smarthealth.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]
