This is on ColdFusion 6 yeah not 6.1?
-----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 11:22 To: [EMAIL PROTECTED] Subject: [ cf-dev ] loop the loop loopiness Can anyone help me with this one please. I have the following code .... <CFOUTPUT QUERY="GetCartItems"> <TR> <TD BGCOLOR="##cc0000">#PartNum#</TD> <TD BGCOLOR="##cc0000">#ItemName#</TD> <td BGCOLOR="##cc0000"> <cfif GetCartItems.ItemsItemSize eq ""> N/A <cfelse> <select name="selectSize#Replace(ItemIDPK,"-","_","ALL")#"> <cfloop index = "ListElementSize" list = " #ValueList(GetCartItems.ItemsItemSize)#"> <cfif #ListElementsIZE# eq GetCartItems.CartItemsItemSize> <!--- preselect it ---> <option value="#ListElementSize#" selected>#ListElementSize#</option> <cfelse> <option value="#ListElementSize#">#ListElementSize#</option> </cfif> </cfloop> </select> </cfif> </td> <td BGCOLOR="##cc0000"> <cfif GetCartItems.ItemsItemColour eq ""> N/A <cfelse> <select name="selectColour#Replace(ItemIDPK,"-","_","ALL")#"> <cfloop index = "ListElementColour" list = "#ValueList(GetCartItems.ItemsItemColour)#"> <cfif #ListElementColour# eq GetCartItems.CartItemsItemColour> <!--- preselect it ---> <option value="#ListElementColour#" selected>#ListElementColour#</option> <cfelse> <option value="#ListElementColour#">#ListElementColour#</option> </cfif> </cfloop> </select> </cfif> </td> <td ALIGN="RIGHT" bgcolor="##cc0000">#lscurrencyFormat(ItemCost)#</TD> <td bgcolor="##cc0000"> <input type="Text" name="Quantity#Replace(ItemIDPK,"-","_","ALL")#" value="#Quantity#" align="RIGHT" size="3"> </TD> <TD BGCOLOR="##cc0000" ALIGN="RIGHT"> #lscurrencyFormat(ItemCost * Quantity)# </TD> </TR> <!--- Add cost of current item(s) to total cost ---> <CFSET TotalCost = TotalCost + (GetCartItems.ItemCost * GetCartItems.Quantity)> </CFOUTPUT> All seems to work ok except that when I add more and more items to the cart the select drop down lists apend whats in the list to the previous list each time. YOu can see this happening by going here http://217.43.93.212/store select footwear (stilettos & platforms have pics) select an item put this in my basket. Do this a cople of times and then look at the size & colour drop down lists. - Sorry about this but its the best way to explain whats happening. Back to the code .. The tblitems has size = 1,2,3,4,5,6,7,8,9 colour = red,white,blue I loop over the list and check to see if the item is already in the cart (tblcartitems) if it is select it if not just show the list. Why is the list being appended to each time? Nothing is being written to the database that shouldn't (ive checked).... Regards - Paul (BTW its not my colour scheme and yes I hate it ...) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
