Re: [ic] flex-select where clause?

[Mike Heins <suppressed>]

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?

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

If you like what you're gettin', keep doin' what you're doin'. -- Hector
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users