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

[adam@opusvl.com]

******    message to minivend-users from adam@opusvl.com     ******


Thanx but I figured how to do it in loop searches.

I could not do a sql query because the loop(s) are inside the sql query
from another
table with some bits of  perl to do some manipulation on the data.

The aim? To do some funky dynamic stuff :)

personal opion - minivend is quite kewl

thanks again


Scott Benson wrote:
> 
> ******    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..

-- 
--caffeine 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