RE: HTML form based interactive SQL query

[Mariusz Matuszewski <MMatuszewski@pl.eeft.com>]

******    message to minivend-users from Mariusz Matuszewski <MMatuszewski@PL.EEFT.COM>     ******

Hello Dan!!!
I really appreciate your help.
But unfortunatelly it is not solving my problems.
Can you do it from html drop down list.
It is working fine for me to, for the user input field.
But if I want to limit the number of user choices by allowing them just to
select from the HTML drop-down-list it is not working.
I did the ODBC trace (I  am connected to my database via ODBC) and the query
geneated by mvend to my SQL database is like:
select * from products where author like ;
so the result of drop down list (default selected) is not transferred as a
parameter to the SQL query.
Am I missin somethig really simple???

Mariusz Matuszewski
mmatuszewski@pl.eeft.com



-----Original Message-----
From: Dan Busarow [mailto:dan@dpcsys.com]
Sent: Sunday, March 07, 1999 10:36 PM
To: Mariusz Matuszewski
Cc: MiniVend List
Subject: Re: HTML form based interactive SQL query


******    message to minivend-users from Dan Busarow <dan@dpcsys.com>
******

On Fri, 5 Mar 1999, Mariusz Matuszewski wrote:
> I would like to make a form-based query to my SQL database.
> For example:
> how to send the following query to be sent to my database (the
> form_field_artist is the user input field on the form):
> select code from products where artist like form_field_artist

    <FORM ACTION="[process-target main]" METHOD=POST>
    <INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products">
    <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="artist">
    <INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
    <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="sql">
    <INPUT TYPE=text NAME="mv_searchspec" SIZE=20>
       This is your form_field_artist

    <INPUT TYPE="submit" NAME="mv_todo" VALUE="Search">
    <INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">

mv_substring_match enables LIKE, without it the search uses =

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
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