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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218203 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
