Re: disabling wildcard in AR reports

No it's not an elegant work-around. All it does is strip the %.

-- 
Dieter Simader    http://www.sql-ledger.com   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
============ On a clear disk you can seek forever ==========

On Wed, 24 May 2006, Donald Baud wrote:

> 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
>



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