[ic] flex-select where clause?

Mike Heins mike at perusion.com
Thu Jul 14 16:23:09 EDT 2005

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].


            select sku,description,price from products
            where sku = '[cgi item_id]'


Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

If you like what you're gettin', keep doin' what you're doin'. -- Hector

More information about the interchange-users mailing list