I'm rewriting the shopping cart for a boutique. It's a generous mixture
of JS and CFM. An issue that I have is this...
I have a table of sizes and their IDs
I have a table of colors and their IDs
I have a table of Items and their specs. Two of the fields hold a comma
delimited listing of IDs, one field for the sizes and one for the colors.
When I call my initial query it gives me the specs of the items within a
specific category
Select c.txtBoutCat as Cat,
i.txtSubCat as SubCat,
i.txtDesignName as Name,
i.mnyItemPrice as Price,
i.mnyXXAdd as XX,
i.mnyXXXAdd as XXX,
i.txtColors as Colors,
i.txtSizes as Sizes,
i.blEmbroider as Embroider,
i.txtImageName as Image,
i.intImgWidth as Width,
i.intImgHeight as Height,
i.intImgThmbWidth as TWidth,
i.intImgThmbHeight as THeight,
i.blWomens as Womens
From tblboutcat c,
tblboutitems i
Where c.intBoutCatID = i.intBoutCatID
And i.blActive = 1
Then I will cfoutput for the query qItems, writing my form within the
output, basically creating the display for each individual item. My
problem is getting my comma delimited lists of IDs into actual text
entries of my select boxes. What is the best way of going about this?
Cutter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
