Re: [OFBiz] Users - Problems with Search queries ...

Posted by David E. Jones on Oct 28, 2005; 1:44am
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Problems-with-Search-queries-tp136240p136244.html


If it isn't doing that I wouldn't call it a bug... It may be that it  
is doing an equals instead of a LIKE on the postal code. That should  
be pretty easy to change.

-David


On Oct 27, 2005, at 6:20 PM, Ian Gilbert wrote:

> Thanks for that.  I don't think that it is working in the case of the
> party manager for postcodes.  I'll investigate more widely and  
> submit a
> bug report.
>
> Best wishes
>
> Ian
>
> On Thu, October 27, 2005 5:15 pm, David E. Jones wrote:
>
>>
>>
>
>
>> Right now we aren't translating wild cards in general queries (we do
>> in the product search queries to support the "*" and "?" wild  
>> cards). So,
>> the wild cards are the default SQL wild cars: "%" to match any  
>> string, "_"
>> (underscore) to match a single character.
>>
>>
>> -David
>>
>>
>>
>> On Oct 27, 2005, at 9:59 AM, Andrew Sykes wrote:
>>
>>
>>
>>> Ian,
>>>
>>>
>>> I don't know about OFBiz, but an Oracle system I used to work on
>>> used % as it's wildcard.
>>>
>>> That's what I call a "wild" card!!!
>>>
>>>
>>> Kind Regards
>>> --
>>> Andrew Sykes <[hidden email]>
>>> Sykes Development Ltd
>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> [hidden email]
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>
>>>
>>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users