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/archive%40mail-archive.com This email sent to [email protected]
