+1 On 2011-08-25, at 9:08 AM, Ramsey Gurley wrote:
> 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/programmingosx%40mac.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]
