[ic] mv_action_map search question

[Brian Kosick]

Hello list,

         I'm trying to create an search map.  I had one working a while 
ago, but now it is broken.  I couldn't figure it out, so created a new very 
very simple one to test it out.  I'm using 4.8.3, perl 5.6.1, 
RH7.1.  Here's the simple search

<form action="[area search]" METHOD=POST>
<INPUT TYPE="hidden" NAME="mv_search_map" VALUE="
         mv_searchspec=search1
         ">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="ac_color">
<INPUT Type="TEXT" NAME="search1" VALUE="">
<INPUT TYPE="submit" VALUE="[L]Search[/L]">

</form>

^^^This returns every item in the database.  And causes an error message of 
"No search string specified" to be entered in the error log.

Here's my original search (Yes I swear this worked when I originally 
created it.)  Now, it seems to return results with no rhyme or 
reason.  That have a searchspec match in ANY of the fields.  IE if you 
request on search_color=b (BLUE) it returns everything that has a b in any 
of the fields

<form action="[area search]" METHOD=POST>
[set main_search]np=results.html/[/set]
<input type=hidden name=mv_more_alpha value="yes">
<input type=hidden name=mv_more_alpha_chars value="1">
<INPUT TYPE=hidden NAME=mv_sort_field VALUE=name>
<input type=hidden name=mv_return_fields value="code, name, short_desc, 
price, qty, new_plant,disc">
<INPUT TYPE="hidden" NAME="mv_profile" VALUE="main_search">
<INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">
<INPUT TYPE=hidden NAME=mv_searchtype VALUE="db">
<INPUT TYPE="hidden" NAME="mv_search_map" VALUE="
         mv_searchspec=search_zone
         mv_searchspec=search_color
         mv_searchspec=search_soil
         mv_searchspec=search_height
         mv_searchspec=search_bloom
         mv_searchspec=search_sun
         ">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="zones">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="ac_color">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="soil">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="ht">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="bloom">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="sun">
<center>
<font size="4"><b>Please Select Your Zone:</b></font><br>

<select name="search_zone">
<option value="">Select Zone
<option value="3">ZONE 3
<option value="4">ZONE 4
<option value="5">ZONE 5
<option value="6">ZONE 6
<option value="7">ZONE 7
<option value="8">ZONE 8
<option value="9">ZONE 9
<option value="10">ZONE 10
</select>
<br>

</center>

<!-- -->
<h3 align="center"><b>Additional Search Criteria:</b></h3>

<center>
<select name="search_color" >
         <option value="">Flower Color (Any/All)
         <option value="">ANY/ALL COLORS
         <option value="m">MIXED
         <option value="r">RED
         <option value="b">BLUE
         <option value="y">YELLOW
         <option value="w">WHITE
         <option value="v">PURPLE
         <option value="o">ORANGE
         <option value="g">GREEN
         <option value="l">LAVENDER
         <option value="p">PINK
         <option value="z">SILVER
         <option value="c">COPPER
</select><br>
<select name="search_soil" >
         <option value="">Soil Condition
         <option value="s">SANDY
         <option value="c">CLAY
         <option value="n">NORMAL
         <option value="a">ACID
</select><br>
<select name="search_height">
         <option selected value="">Plant Height
         <option value="s">SHORT to 18"
         <option value="m">MEDIUM 18"-36"
         <option value="t">TALL 36"+
</select><br>
<select name="search_bloom">
         <option value="">Blooms During
         <option value="a">EARLY SPRING
         <option value="b">SPRING
         <option value="c">LATE SPRING
         <option value="d">SUMMER
         <option value="e">LATE SUMMER
         <option value="f">FALL
         <option value="g">LATE FALL
</select><br>
<select name="search_sun">
         <option value="">Sun-Shade Condition
         <option value="1">Full Sun
         <option value="2">Mostly Sunny
         <option value="3">Half Sun/Half Shade
         <option value="4">Mostly Shady
         <option value="5">Full Shade
</select>
<INPUT TYPE="submit" VALUE="[L]Search[/L]">
<br>
</center>
</form>



Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@nacs.net