[ic] flex-select where clause?
rphipps at reliant-solutions.com
Thu Jul 14 16:27:00 EDT 2005
> From: interchange-users-bounces at icdevgroup.org
> 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
> > 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
> > so essentially I only need to show data from a table where a field
> > equal to [cgi item_id].
> select sku,description,price from products
> where sku = '[cgi item_id]'
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 :)
More information about the interchange-users