sql query

[Andreas Kotowicz <koto@mynetix.de>]

Hi all,

I've just put my products database on sql and everything works fine, except 
the search through all categories. I do use:	

<INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
<INPUT TYPE="hidden" NAME="mv_matchlimit" VALUE="7">
<INPUT TYPE="hidden" NAME="mv_sql_query" VALUE="select * from products 
where upper(description) LIKE  %?% OR upper(category) LIKE %?%">
<INPUT MAXLENGTH="30" NAME="mv_searchspec" SIZE="13" VALUE="">

But this doesn't work. A simple <INPUT TYPE="hidden" NAME="mv_sql_query" 
VALUE="select * from products where description = ?"> works just for 
descriptions which are really the same. but if I already do a <INPUT 
TYPE="hidden" NAME="mv_sql_query" VALUE="select * from products where 
description = ? OR category = ?"> he just finds descriptions but no 
categories I enter.

Anyone a hint?


Andreas