Re: [mv] Sql search with multiple mv_search_field

[Ken Berland <ken@hero.com>]

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

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