[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: SQL searches
****** message to minivend-users from Mariusz Matuszewski <MMatuszewski@PL.EEFT.COM> ******
-----Original Message-----
From: Dan Busarow [mailto:dan@dpcsys.com]
Sent: Monday, June 07, 1999 7:04 PM
To: minivend-users@minivend.com
Subject: 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
Could you give me the complete example how to do that.
I was playing with this (using this documentation section of course) for
long, and all I recognized is that if you want to submit a query using
mv_sql_query it must be fixed, no variable substitution like in my example
above allowed :(
> 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
-
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
