you are right about the summary for the index. what i need to know for each product is whether the product has a positive stock level eg. iof zero then the product is not available for purchase. and this is determined by querying the product options table to see if there are options loaded for a product.
i have just actually created a query which may do the trick for me as opposed to using the function above. >Why would you need to run it multiple times? >Just do a query minus the product_id filter, turn that into a struct >or just return the whole query. >Also, just an FYI, shouldn't an index page be more of a summary than detail? > > >On Sun, Mar 30, 2008 at 7:01 PM, Mike Little <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
