Re: [mv] Sql search with multiple mv_search_field

[Ken Berland <ken@hero.com>]

******    message to minivend-users from Ken Berland <ken@hero.com>     ******

http://hero.com/ken/Scan.pm.diff

I patched Scan.pm.orig.orig to my Scan.pm like this:

[ken@hero ~/test]$ patch < Scan.pm.diff
patching file `Scan.pm.orig'

then rename it to Scan.pm (backing up your original), then restart mvend.

On Wed, 12 Apr 2000, Alexei Yakimovich wrote:

> Dear Ken,
> 
> I have same problem, but I can't solve of that one.
> Can you give me a patch or advice?
> 
> Thank you in advance,
> 
> Alexsei
> 
> ----- Original Message -----
> From: "Ken Berland" <ken@hero.com>
> To: <minivend-users@minivend.com>
> Sent: Monday, January 10, 2000 10:07 PM
> Subject: Re: [mv] Sql search with multiple mv_search_field
> 
> 
> > ******    message to minivend-users from Ken Berland <ken@hero.com>
> ******
> >
> > I've patched lib/Vend/Scan.pm and now have the behaviour I want, as well
> > as all the search terms in [mv_raw_searchspec] instead of just the first
> > one or none at all.  I think I found some bugs.  Who can review the patch
> > info?
> >
> >
> > On Sun, 9 Jan 2000, Ken Berland wrote:
> >
> > > Just tried it.  No dice.
> > >
> > > Fill out just the second field and get:
> > > select code from products where code like '%%' OR fixture_type like '%%'
> > > OR manufacturer like '%%'
> > >
> > > this should be:
> > > select  code from products where code like '%%' AND fixture_type like
> > > '%foo%' AND manufacturer like '%%'
> > >
> > > On Sun, 9 Jan 2000, Ramsey French wrote:
> > >
> > > > ******    message to minivend-users from Ramsey French
> <rammjet@mindspring.com>     ******
> > > >
> > > > Maybe set a default VALUE="" ?
> > > >
> > > > On 1/9/00 9:09 PM, Ken Berland at ken@hero.com wrote:
> > > > >
> > > > > With MiniVend V3.14-3, I'm using the following form to to a three
> > > > > mv_search_field search with sql.   Is anyone doing this
> successfully?  I'm
> > > > > getting some weird behaviour. I did the same thing in a "one click
> search"
> > > > > and it works fine.
> > > > >
> > > > >
> > > > > I'd like them all to "AND" together.  When all
> > > > > are blank the sql is query is correct, 1=1.  When all are filled the
> > > > > query is also correct, select code from products where code like
> '%1%' AND
> > > > > fixture_type like '%2%' AND manufacturer like '%3%'.  But when only
> two is
> > > > > filled in I get, select code from products where code like '%%' OR
> > > > > fixture_type like '%%' OR manufacturer like '%%'.
> > > > >
> > > > >
> > > > > <FORM ACTION="[process-search]" METHOD=POST>
> > > > > <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
> > > > > <INPUT TYPE="hidden" NAME="mv_orsearch" VALUE="no">
> > > > > <INPUT TYPE="hidden" NAME="mv_matchlimit" VALUE="15">
> > > > > <INPUT TYPE="hidden" NAME="mv_return_all" VALUE="yes">
> > > > > <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="code">
> > > > > <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="fixture_type">
> > > > > <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="manufacturer">
> > > > > <INPUT TYPE="hidden" NAME="mv_case" VALUE="no">
> > > > > <INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
> > > > > <INPUT TYPE="hidden" NAME="mv_coordinate" VALUE="yes">
> > > > > Item Number:
> > > > > <INPUT TYPE="TEXT" NAME="mv_searchspec" SIZE="20"
> MAXLENGTH="30"><BR>
> > > > > Fixture Type:
> > > > > <INPUT TYPE="TEXT" NAME="mv_searchspec" SIZE="20"
> MAXLENGTH="30"><BR>
> > > > > Manufacturer:
> > > > > <INPUT TYPE="TEXT" NAME="mv_searchspec" SIZE="20"
> MAXLENGTH="30"><BR>
> > > > > <INPUT TYPE="submit" VALUE="Go">
> > > > > </FORM>
> > > > >
> > > > >
> > > > > <!--one click search that works-->
> > > > >
> > > > > Buffers Files Tools Edit Search Mule Tcl-Mode Help
> > > > > [page scan st=sql
> > > > > ra=yes
> > > > > os=no
> > > > > ml=15
> > > > > cs=no
> > > > > su=yes
> > > > > sf=code
> > > > > sf=fixture_type
> > > > > sf=manufacturer
> > > > > se=
> > > > > se=wall
> > > > > se=resolut]
> > > > > DOIT[/page]
> 
> 


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list