[ic] flex-select where clause?

[Mike Heins]

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?

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