Yeah, these queries in particular look like they could both easily be shortened down to something along the lines of
SELECT * FROM vProductOptions where prodID = #url.prodid# With a view -- which would probably be useful in several places and a much easier solution than XML. > Why don't you use DB Views? A couple of Views > should make your db access a lot easier. > ---nimer >> -----Original Message----- >> From: Will Tomlinson [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, September 13, 2005 8:36 PM >> To: CF-Talk >> Subject: Re: XML as a database? Please say yes! >> >> 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:218211 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
