RE: [ic] flex-select where clause?

["Ron Phipps" <suppressed>]

> From: suppressed
[mailto:interchange-users-
> suppressed On Behalf Of Mike Heins
> Sent: Thursday, July 14, 2005 1:23 PM
> 
> Quoting Ron Phipps (suppressed):
> > 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

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users