[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: HTML form based interactive SQL query
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Tue, 16 Mar 1999, Mariusz Matuszewski wrote:
> THNX Dan!!!
You're welcome!
> It is working fine. The only problem I have now are the empty strings.
> If you liwe the empty string in select, supposing that you are doing search
> basing on two fields, my query looks like:
> select code from products where author like '%%' and title like '%%';
> If both select variables are not empty, everything works fine.
> But I want to be able to leave some fields emty, to allow users selecting
> just the categories they want like:
> select code from products where author like '%%' and title like '%Album%';
> Any ideas???
Take a look at mv_coordinate
If you set it to yes then fields with empty strings are not included
in the search spec.
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
