[mv] Problem with HTML-based SQL-Query

["Thomas Hecker" <tom@x9media.com>]

******    message to minivend-users from "Thomas Hecker" <tom@x9media.com>     ******

Hi folks!
I have a Problem with Minivend 3.14-3 . I want to perform an sql-query using
drop-down menus. The whole thing works fine as long as I specify either both
options or just the first (subcategory), leaving the manufacturer on its
default to show all manufacturers.
But when I try to perform a query specifying just the manucturer, I get no
match.

I've tried to change the mv_coordinate value to "no" but it doesn't seem to
have an effect.

Here's the code:

<FORM ACTION="[process-search]" METHOD=POST target="fenster">
<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">

<INPUT TYPE="hidden" NAME="mv_coordinate" VALUE="yes">
 <INPUT TYPE=hidden NAME=mv_search_field VALUE=subcategory>
 <INPUT TYPE=hidden NAME=mv_search_field VALUE=manufacturer>

   Artikelart:<select size="1" name="mv_searchspec">
<option value="" selected>alle</option>
<option value="aps">APS-Kameras</option>
<option value="digital">Digitalkameras</option>
<option value="B1">Spiegelreflex</option>
<option value="B2">Sucherkameras</option>
</select>

  Marke: <select size="1" name="mv_searchspec">
<option value="">alle</option>
<option value="Agfa">Agfa</option>
<option value="Canon">Canon</option>
<option value="casio">Casio</option>
<option value="Fuji">Fuji</option>
<option value="Kodak">Kodak</option>
<option value="Konica">Konica</option>
<option value="Minolta">Minolta</option>
<option value="nikon">Nikon</option>
<option value="olympus">Olympus</option>
<option value="Pentax">Pentax</option>
<option value="ricoh">Ricoh</option>
<option value="Rollei">Rollei</option>
<option value="sony">Sony</option>
<option value="Toshiba">Toshiba</option>
<option value="yashica">Yashica</option>
<option value="voigtl">Voigtl&auml;nder</option>
</select>

 <INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
  </FORM>
----------------------------------------------------------------------------
-------------------------
Thanks for your attention

Tom

-
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