Sorry its coldfusion MX with SQL 2K. Sorry I should have mentioned that ....
Regards - Paul
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: [ cf-dev ] loop the loop loopiness
Date: Fri, 16 Jul 2004 11:27:15 +0100
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]
--
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]
