Re: [mv] Searching multiple columns in MySQL problem

[Daniel Ceregatti <daniel@digitalsavant.com>]

Excelent idea! I did not think of this. I've already fixed the problem by using javascript to reconstruct the mv_sql_query, but I'd rather go with a solution that's not javascript dependent.

Thanks.

Dan Busarow wrote:

> ******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******
>
> On Wed, 20 Oct 1999, Daniel Ceregatti wrote:
> > This is just straight cgi...I know how to do this. I need to know how to do this with minivend tags, so minivend parses the results via results.html...I appreciate the try, though. :)
>
> I'd put the search in a custom page instead of the standard results page.
> Then you can just build the select statement yourself.  I haven't done
> this using standard input fields but I believe you can reference any
> cgi var via [value cgi-variable]
>
> [sql type=list
>    query="select * from atable where field1 like '% [value inputfield] %'
>    or field2 like '% [value inputfield] %'"]
>
> 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

--

Daniel Ceregatti

Programmer - Digital Savant

Phone: (323) 848-7964 x106
Fax: (323) 871-2499
7039 Sunset Blvd., Suite 200
Hollywood, CA 90028