[ic] flex-select where clause?

[Ron Phipps]

> From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-
> bounces at icdevgroup.org] On Behalf Of Mike Heins
> Sent: Thursday, July 14, 2005 1:23 PM
> 
> Quoting Ron Phipps (rphipps at reliant-solutions.com):
> > Is there a way to add a where clause to the flex-select so only a
subset
> > of the table is returned?  I'd like to use flex-select on some admin
> > pages to show data in a table related to the current item being
edited,
> > so essentially I only need to show data from a table where a field
is
> > equal to [cgi item_id].
> >
> 
> Doesn't
> 
>     [flex-select
>         sql-query="
>             select sku,description,price from products
>             where sku = '[cgi item_id]'
>         "
>     /]
> 
> work?
> 

It sure does Mike.  I haven't done much work with flex-select or
table-editor, so I was unaware of the sql-query option.  I dug through
the code and saw that option :)

Thanks,
-Ron