Thanks for all your responses. Guess I'll just stick with my db. It just seemed like running the queries to gather multiple options and combinations of options was getting out of hand. Here's what I'm using just to grab options and their values for a given product. Seems a bit ridiculous but I dunno how to get around it given the db schema. (no crackin on my lack of queryparams, just testing)
<cfquery name="options" datasource="***"> SELECT tblprodoptions_rel.optionID, tblprodoptions_rel.optionprodID,tblprodoptions_rel.option_optiontype, tbl_listoptiontypes.optiontypeID, tbl_listoptiontypes.optiontypename, tbl_listoptiontypes.optionsort, tblprod_SKUS.SKUID, tblprod_SKUS.SKU_prodID, tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.optionID AS theoptionID, tblSKUoptions.optiontypeID , tblSKUoptions.optionname, tblSKUoptions.optionsort,tblprod_SKUS.SKU_prodID, tblprod_SKUS.SKUID FROM tbl_listoptiontypes, tblprodoptions_rel, tblprod_SKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblprodoptions_rel.optionprodID = #URL.PRODID# AND tblprodoptions_rel.option_optiontype = tbl_listoptiontypes.optiontypeID AND tblprodoptions_rel.optionprodID = tblprod_SKUS.SKU_prodID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.optionID AND tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tbl_listoptiontypes.optiontypeID = tblSKUoptions.optiontypeID AND tblprod_SKUS.SKU_prodID = #URL.PRODID# ORDER BY tbl_listoptiontypes.optionsort </cfquery> <cfquery name="optionitems" datasource="****"> SELECT tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.optionID, tblSKUoptions.optiontypeID, tblSKUoptions.optionname, tblSKUoptions.optionsort,tblprod_SKUS.SKU_prodID, tblprod_SKUS.SKUID FROM tblSKUoptions_rel, tblSKUoptions, tblprod_SKUS WHERE tblSKUoptions_rel.option_optionID = tblSKUoptions.optionID AND tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblprod_SKUS.SKU_prodID = #URL.PRODID# ORDER BY tblSKUoptions.optionsort </cfquery> Thanks much, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218137 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
