[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: SQL searches
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Mon, 7 Jun 1999, Mariusz Matuszewski wrote:
> Does it mean that you couldn't achieve sql queries like:
> select field1, field2 from database
> where field1=[value form_variable1] and field2=[value form_variable2]???
No. The example is refering to using a single input field to select from
two (or more) DB fields.
See "Coordinated and joined searching" in the documentation for info on
your case; or specify your own mv_sql_query
> Mike Heins wrote:
> I think you would be better off letting MV build the query:
>
> <FORM ACTION="[process-search]" METHOD=POST>
> <INPUT TYPE=hidden NAME=mv_searchtype VALUE="sql">
> <INPUT TYPE=hidden NAME=mv_search_page VALUE="results1.html">
> <INPUT TYPE=hidden NAME=mv_search_field VALUE="grade">
> <INPUT TYPE=hidden NAME=mv_search_field VALUE="description">
> <INPUT TYPE=hidden NAME=mv_orsearch VALUE="yes">
> <INPUT TYPE=text NAME=mv_searchspec SIZE="20">
> <INPUT TYPE=submit VALUE="SQL">
> </FORM>
>
> And possibly as well:
>
> <INPUT TYPE=hidden NAME=mv_substring_match VALUE="yes">
>
> and maybe:
>
> <INPUT TYPE=hidden NAME=mv_begin_string VALUE="yes">
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
