Re: disabling wildcard in AR reports

A checkbox called "exact match" might be nice.  If checked, it would 
disable wildcard searching.
It would default to unchecked.

On Wed, 24 May 2006, Donald Baud wrote:

> I finally decided to patch AA.pm to suit my needs. 
> This is probably very clumsy because I can no longer
> search customers with "%customer%" but at least, I can
> still do "%customer" or "customer%".
> 
> I wish Dieter would add a knob to disable wild card
> searching on the form.
> 
> --- AA.pm.bak   Wed May 24 09:16:16 2006
> +++ AA.pm       Wed May 24 09:54:36 2006
> @@ -599,6 +599,7 @@
>    } else {
>      if ($form->{$form->{vc}}) {
>        $var = $form->like(lc $form->{$form->{vc}});
> +      $var =~ s/^%(.*)%$/$1/;
>        $where .= " AND lower(vc.name) LIKE '$var'";
>      }
>    }
> 
> 
> 
> --- Donald Baud <donaldbaud-/[email protected]> wrote:
> 
> > Is there a way to disable wildcard searching on
> > customer name?
> > I have a few customers setup as: "customer1"
> > "customer2" ... "customer100"
> > I am trying to show the aging report for "customer1"
> > but I keep getting info for "customer10"
> > "customer11"
> > customer12" ...
> > 
> > the query being sent to postgres is something like:
> > select * 
> > from customer 
> > where lower(vc.name) LIKE '%customer1%'
> > 
> > Why is the wildcard being added automatically?
> > according to the manual, one has to request it with
> > the '%' or '_' sign?
> > 
> > notice: I cannot change the customer name format
> > because it is being used as a keyname in other
> > applications
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> > protection around 
> > http://mail.yahoo.com 
> > 
> > 
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> >
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> 
> _______________________________________________
> sql-ledger-users mailing list
> sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 


_______________________________________________
sql-ledger-users mailing list
sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users