Re: [mv] Sql search with multiple mv_search_field

[Ken Berland <ken@hero.com>]

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


-
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