Re: HTML form based interactive SQL query

[Dan Busarow <dan@dpcsys.com>]

******    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