Re: disabling wildcard in AR reports

Hey, that's a very elegant workaround.
Now we can disable the wild cards by double quoting
the customer name.
I'll submit the patch to Mr S.

--- AA.pm.bak   Wed May 24 09:16:16 2006
+++ AA.pm       Wed May 24 11:04:30 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'";
     }
   }



--- Mark Bucciarelli <[email protected]> wrote:

> On Wed, May 24, 2006 at 07:11:05AM -0700, Donald
> Baud wrote:
> 
> > I wish Dieter would add a knob to disable wild
> card searching
> > on the form.
> 
> This sounds useful to me as well.  Perhaps a simple
> implementation (that does not require another knob)
> is to follow
> the search engine rule--if the string is in quotes,
> don't use
> wildcards. 
> 
> Did you submit a wish via the sql ledger web site? 
> I have found
> Mr. S to be responsive to that avenue and it
> probably get's stuck
> in a database somewhere.
> 
> I would expect that a wish posted here will get
> quickly get lost
> in life's inexorable shuffle.
> 
> m
> 
> 
> _______________________________________________
> 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