Re: [mv] Problem with Coordinated Search using SQL

["Humberto T Reyes" <htreyes@earthlink.net>]

Thanks for the input

Here is what my SQL looks live in the log file:

991213  9:19:41      85 Connect    xxxxx@localhost on xxxx
                     85 Query      select code from products where 1 = 1
                     85 Query      select * from products where code =
'02-0200'
                     85 Query      select * from products where code =
'02-0201'
                     85 Query      select * from products where code =
'02-0202'
                     85 Query      select * from products where code =
'02-0203'
                     85 Query      select * from products where code =
'02-0204'
                     85 Query      select * from products where code =
'02-0205'
                     85 Query      select * from products where code =
'02-0206'
                     85 Query      select * from products where code =
'02-0207'
                     85 Query      select * from products where code =
'02-0208'
                     85 Query      select * from products where code =
'02-0209'
                     85 Query      select * from products where code =
'02-0210'
                     85 Query      select * from products where code =
'02-0211'
                     85 Query      select * from products where code =
'02-0212'
                     85 Query      select * from products where code =
'02-0213'
991213  9:19:42      85 Quit

Why is MV creating a select statement "from products where 1=1??  It simply
displays all the contents of the products table.  Any ideas as to what I'm
doing wrong?

I'm using MV 3.14

Thanks in advance.

----- Original Message -----
From: "Ken Berland" <ken@hero.com>
To: <minivend-users@minivend.com>
Sent: Friday, December 10, 1999 6:14 PM
Subject: Re: [mv] Problem with Coordinated Search using SQL


> ******    message to minivend-users from Ken Berland <ken@hero.com>
******
>
> 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
> >
> >
>
> -
> 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
>