[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Problem with Coordinated Search using SQL
A really nice thing about mysql is the --log option. You can start the
safe_mysqld server with this option and see what minivend is/trying to do.
On Wed, 1 Dec 1999, Humberto T Reyes wrote:
> I am attempting to use a coordinated search with SQL to a MySQL database. I have not been able to get it to work properly because I do not know how to get the values of the select statements to my query. Can anyone provide some guidance please!!
>
> Here is what I'm doing:
>
> <FORM action="[process-search]" method="POST">
> <B><FONT color="#0000cc">Choose a manufacturer and/or styleand click go!</FONT></B><BR>
> <INPUT TYPE="hidden" NAME=mv_search_map VALUE="
> mv_searchspec=search1
> mv_searchspec=search2
> mv_searchspec=search3
> mv_searchspec=search4
> ">
> <INPUT TYPE="hidden" name="mv_search_field" value="department">
> <INPUT TYPE="hidden" name="mv_search_field" value="subcategory">
> <INPUT TYPE="hidden" name="mv_search_field" value="manufacturer">
> <INPUT TYPE="hidden" name="mv_search_field" value="style">
> <SELECT name="search3">
> <OPTION selected value="">All Manufacturers
> <OPTION value="Manufacturer1">Manufacturer1
> <OPTION value="manufacturer2">Manufaacturer2
> <OPTION value="manufacturer3">Manufacturer3
> </OPTION>
> </SELECT>
>
> <INPUT TYPE="hidden" name="mv_matchlimit" value="14">
> <INPUT TYPE="hidden" name="mv_search_page" value="vineyard_results.html">
> <INPUT TYPE="hidden" name="mv_searchtype" value="sql">
> <INPUT TYPE="hidden" name="search1" value="[value choice]">
> <INPUT TYPE="hidden" name="search2" value="Vines Rootstock">
> <INPUT TYPE="hidden" name="mv_substring_match" value="yes">
> <INPUT TYPE="hidden" name="mv_coordinate" value="yes">
>
> <SELECT name="search4">
> <OPTION value="">All Styles
> <OPTION value="V shape">V Shape
> <OPTION value="Standard">Standard
> <OPTION value="Others">Others
> </OPTION>
> </SELECT>
>
> <INPUT alt="search again" border=0 height=15 name=imagefield src="/simple/images/go_1.gif" type=image width=31>
> </FORM>
>
> ---------------
>
> One of the values I'm using here comes from the previous page--included in a one click link. I was able to do this before I started using MySQL. Am I missing anything??
>
> Thanks in advance,
>
> Humberto Reyes
> htreyes@earthlink.net
>
>
