[ic] mv_action_map search question
Brian Kosick
interchange-users@interchange.redhat.com
Thu Jan 31 11:24:00 2002
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