i suppose then left joining your tables and using cfif|cfelse/cfswitch|cfcase logic at output can do the trick?
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Little wrote: > good question, at this stage being able to display all with like you said - a > availability flag would be quite good. > > >> do you want to display on your summary page only products that are in >> stock, or all products with 'unavailable' for those out of stock? >> >> Azadi Saryev >> Sabai-dee.com >> http://www.sabai-dee.com/ >> >> >> >> Mike Little wrote: >> >>> i need to develop a system for displaying products on a summary page. >>> >>> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
