RE: [mv] Multiple field SQL OR Search Results Page Problem MV 4.04

["Cameron B. Prince" <cameron@akopia.com>]

******    message to minivend-users from "Cameron B. Prince" <cameron@akopia.com>     ******

Delimit your query with pipe or set it as a scrath like this:

		[query
		list=1
		st=db
		sql=|
		select sum(amount) from checking where type like 'Payment%' and account !=
'Payroll Expenses' and status = 'closed'
		|
		]
		[seti expenses][sql-code][/seti]
		[/query]

or

[seti query]select sum(amount) from checking where type like 'Payment%' and
account != 'Payroll Expenses' and status = 'closed'[/seti]

		[query
		list=1
		st=db
		sql=|
		[scratch query]
		|
		]
		[seti expenses][sql-code][/seti]
		[/query]

Good luck,

Cameron

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Humberto T Reyes
Sent: Friday, October 13, 2000 11:20 AM
To: minivend-users@minivend.com
Subject: [mv] Multiple field SQL OR Search Results Page Problem MV 4.04


******    message to minivend-users from "Humberto T Reyes"
<htreyes@earthlink.net>     ******

Greetings,

I'm currently having a problem that is just killing me--I need to create a
search page/results page that allows a customer to create a blend of a
particular mix of seeds.

What I am attempting to do is create a page with a series of drop down boxes
that include a manufacturer and five types of varieties.  The problem I have
is hoe MV is creating the search it gives me a parse error very time.

I believe this maybe b/c I'm asking it to create a Query like this:

SELECT sku FROM products WHERE variety='Clovers' or variety='Silage' and
subcategory='Cover Crop' order by manufacturer;

Can someone please point me in the right direction.

Here is the error I get:

<-----Snip-------->

[12/October/2000:21:22:39 -0700] catalog /cgi-bin/evine/search.html Bad SQL
statement: Parse
error near % order by name at /usr/local/pkg/minivend/lib/Vend/Scan.pm line
580.
>
> Query was:
>
st=sql
>
>
sp=cover_results.html
>
va=pass2=no
>
va=verify=yes
>
va=sort=B
>
md=10
>
ml=14.

<------Snip------------->


Here is some partial code to show what I'm attempting to do:

<------------Snip------>

<FORM NAME="test" ACTION="[process-search]" METHOD=POST>
<INPUT TYPE="hidden" NAME="mv_orsearch" VALUE="yes">
<INPUT TYPE="hidden" NAME="mv_coordinate" VALUE="yes">
<INPUT TYPE="hidden" name="mv_searchspec" value="Cover Crop">
<INPUT TYPE="hidden" name="mv_search_field" value="subcategory">
<TR>
<TD WIDTH="10" VALIGN="top">&nbsp;</TD>
<!-- Begin Content Section -->
<TD WIDTH="550" VALIGN="top">
Manufacturer:
<SELECT NAME="mv_searchspec">
<OPTION VALUE="" SELECTED>All Manufacturers
[query sql="select distinct manufacturer from products where
subcategory='Cover Crop' order by manufacturer" list=1]
<OPTION VALUE="[sql-param manufacturer]"> [sql-param manufacturer]
[/query]
</SELECT>
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="manufacturer">
<P>
Blend 1:
<SELECT NAME="mv_searchspec">
<OPTION VALUE="" SELECTED>All Types
[query sql="select distinct variety from products where subcategory='Cover
Crop' order by variety" list=1]
<OPTION VALUE="[sql-param variety]"> [sql-param variety]
[/query]
</SELECT>
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="variety">
<P>
Blend 2:
<SELECT NAME="mv_searchspec">
<OPTION VALUE="" SELECTED>All Types
[query sql="select distinct variety from products where subcategory='Cover
Crop' order by variety" list=1]
<OPTION VALUE="[sql-param variety]"> [sql-param variety]
[/query]
</SELECT>
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="variety">
<P>
Blend 3:
<SELECT NAME="mv_searchspec">
<OPTION VALUE="" SELECTED>All Types
[query sql="select distinct variety from products where subcategory='Cover
Crop' order by variety" list=1]
<OPTION VALUE="[sql-param variety]"> [sql-param variety]
[/query]
</SELECT>
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="variety">
<INPUT TYPE="hidden" NAME="mv_search_page" VALUE="cover_results.html">
<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
<INPUT TYPE="hidden" NAME="mv_sort_field" VALUE="manufacturer">
<INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products">
&nbsp;&nbsp;
<INPUT TYPE="image" SRC="/catalog/images/go29x16.gif" WIDTH="29" HEIGHT="16"
BORDER="0" NAME="imagefield" ALT="Refine product list now">
<P>
<HR>
</TD>
<!-- End Content Section -->
</TR>
</FORM>

<--------Snip------->

Again thank you in advance for any assistance,

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

-
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