Re: SQL Search

[Dana Hudes <dhudes@hudes.org>]

SQL::Statement is just an SQL parser, not a database interface.
DBD::CSV uses it.


On Sun, 25 Jul 1999, Kim Armann wrote:

> ******    message to minivend-users from Kim Armann <kim@nichols.de>     ******
> 
> 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
> -
> 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
>