[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL Search
Sorry, I forgot s.th. I use a MySQL-Database with
Database products products.asc dbi:mysql:minivend:localhost:3333
... kim
Dana Hudes wrote:
> SQL::Statement is just an SQL parser, not a database interface.
> DBD::CSV uses it.
>
> On Sun, 25 Jul 1999, Kim Armann wrote:
> >
> > 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
