[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
SQL Search
Hi, I try an SQL - Search.
My Form looks like this :
<FORM ACTION="[process-target main]" METHOD=POST>
Autor : <input name="autor" size="35">
<INPUT TYPE=hidden NAME=mv_searchtype VALUE="sql">
<INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">
<INPUT TYPE="hidden" NAME="mv_case" VALUE="no">
<INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
<INPUT TYPE=hidden NAME="mv_sql_query"
VALUE="
SELECT * FROM products
WHERE
vorname_1 LIKE XXX">
<input type="submit" value="Suche starten">
</form>
I replaced XXX with
- autor -> error "Unknown column"
- 'autor' -> it searchs for "autor"
- [autor] -> no results
- [value autor] -> not the current but the next search is successfull
I tried to make the SQL-string with [set] in the results-Page ... no
effect
I use minivend 3.12, Perl 5.005_02 built for i586-linux, and the
SQL::Statement Module 0.1012, SuSE Linux 6.1, Apache 1.3.4
thx for thinking about it .... kim
