[mv] sql search-coordinate problems

["Tobias Gebauer" <tobias.gebauer@x9media.com>]

******    message to minivend-users from "Tobias Gebauer" <tobias.gebauer@x9media.com>     ******

Hello,
i have a problem with the coordinate_search over several columns...
The following search form gives me allways the same searchresult after
sending my statements.....
but its strange that the same code works fine if i use a ASC database
instead a SQL database:

 <FORM ACTION="[process-search]" METHOD=POST target="fenster">
<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
 <INPUT TYPE=hidden NAME=mv_search_map VALUE="
          mv_searchspec=search1
       mv_searchspec=search2
    mv_searchspec=search3">
     <INPUT TYPE=hidden NAME=mv_search_field VALUE=subcategory>
     <INPUT TYPE=hidden NAME=mv_search_field VALUE=title>
  <INPUT TYPE=hidden NAME=mv_search_field VALUE=category>
     <INPUT TYPE=hidden NAME="mv_coordinate" VALUE="yes">
Artikelart:<select size="1" name="search1">
<option value="" selected>alle</option>
<option value="aps">APS-Kameras</option>
<option value="digital">Digitalkameras</option>
<option value="slr">Spiegelreflex</option>
<option value="sucher">Sucherkameras</option>
</select>
    Marke: <select size="1" name="search2">
<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="hidden" NAME=search3 VALUE="kamera">
<INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
  </FORM>


A part of my sql products-table:

| code | subcategory | title                 | category | artikelname |
description                                      | related | image | price
| angebote | Info |

| 6    | slr         | Nikon F 90 X, Gehäuse | kamera   | Nikon       | sehr
gute Spiegelreflexkamera, Semi-Profibereich | 1 2     | NULL  | 2300.50  |
sonder   | Info |

| 7    | digital     | Olympus C  830 L      | kamera   | Olympus     |
Hochauflösende Digitalkamera                     | 4       | NULL  |
23232.90 | sonder   | Info |



Can someone help me?????

Regards



Tobias Gebauer
X9MEDIA internet communication
Heinrich-Roller Str. 16/17
10405 Berlin
Germany
fon: +49 (0)30 440 55 470
fax: +49 (0)30 440 55 475

mail: tobias.gebauer@x9media.com
http://www.x9media.com/

Fingerprint PGP-Key:
7BE4 2B1A 63C7 2FDB 985D  55D4 9E5D 8D28 700E 10B2

-
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