Re: D2W Boolean Search
Re: D2W Boolean Search
- Subject: Re: D2W Boolean Search
- From: Chuck Hill <email@hidden>
- Date: Thu, 25 Aug 2011 14:03:05 -0700
On 2011-08-25, at 2:01 PM, David Avendasora wrote:
> :-/
>
> Yep. That "works". The radio button uiMode is ugly as sin, and uses table-based layout... sigh.
>
> If only Git didn't totally frustrate me... and I knew CSS better...
>
> Anyway, out of curiosity, what kind of rule do you use to specify ERD2WCustomQueryBoolean? I've got:
>
> 100 : (task = 'query' and not (attribute = null) and attribute.className = 'java.lang.Boolean') => componentName = "ERD2WCustomQueryBoolean" [com.webobjects.directtoweb.Assignment]
>
> Maybe I should just use 1 and 0 in my DB column instead of true and false.
Oh, why frustrate yourself with so many choices David?
:-P
> On Aug 26, 2011, at 12: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:
>>> 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@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden