Duncan I have changed the query to this ....
<CFQUERY NAME="GetCartItems" datasource="#application.dsn#">
SELECT ItemIDPK, PartNum, ItemName, ItemCost, Quantity,
tblitems.itemsize AS ItemsItemSize, tblCartItems.ItemSize AS CartItemsItemSize
FROM tblItems, tblCartItems
WHERE itemID = ItemIDPK
AND CartIDPK = '#Cookie.CartID#'
</cfquery>
To prevent confusion as to what is being selected
And the loop now looks like this
<select name="selectSize">
<cfloop index = "ListElement"
list = "#GetCartItems.ItemsItemSize#"
delimiters=",">
<cfif #ListElement# eq GetCartItems.ItemsItemSize> <!--- preselect it --->
<option value="#GetCartItems.CartItemsItemSize#" selected>#GetCartItems.CartItemsItemSize#</option>
<cfelse>
<option value="#ListElement#">#ListElement#</option>
</cfif>
</cfloop>
</select>
As I understand it the select is populated withthe list data from itemsItemSize. (which seems to work ok) Inside the loop I check to see if the value of the list from itemsItemSize is equal to that which is held in the cart (cartitemsitemsize) if it is then make this value selected.
It doesn't work still :(
Regards - Paul
-- 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]
