Re: [mv] [loop search="..."] sql?

[Scott Benson <scott@rant.tzo.com>]

******    message to minivend-users from Scott Benson <scott@rant.tzo.com>     ******

adam@opusvl.com wrote:

> ******    message to minivend-users from adam@opusvl.com     ******
>
> opsss... ok I have worked around that problem
> (Murphy's law)
>
> thou does anybody know how to select a distinct subcategory from the
> products
> data base in a loop search. I already have a working loop search but can
> not
> get disinct results.
>

I ran into a similar problem with a search I was trying to do within an arbitrary
database... couldn't figure out how to do it other than using a sql query...

[query sql="select distinct my_column from my_table where my_whatever = my_value
order by my_column" list=1]

[sql-param my_column]

[/query]



scott


>
> thank you for any help..
>
> --
> --caffine is our friend--
> -
> 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