HO HO HO! Its Christmas!
MAGIC - !
It works a treat now - I'm still not sure why it didn't work before but I see you used valuelist() which I presume makes the data in the list more sensible. I can only assume that the EQ wasn't being triggered as the items didn't match as I expected...
Many thanks for this Duncan once again you've saved the day and whats left of my sanity.
All I have to do know is replicate this for the colour and Roberts your mothers brother ...
Regards - Paul
preselect itFrom: [EMAIL PROTECTED] Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: [ cf-dev ] Whats wrong please? Date: Thu, 8 Jul 2004 19:53:09 +0100
how about this:
<select name="selectSize">
<cfloop index = "ListElement" list = "
#ValueList(GetCartItems.ItemsItemSize)#">
<cfif #ListElement# eq GetCartItems.CartItemsItemSize> <!---
preselect it --->
<option value="#ListElement#"
selected>#ListElement#</option>
<cfelse>
<option value="#ListElement#">#ListElement#</option>
</cfif>
</cfloop>
</select>
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: Re: [ cf-dev ] Whats wrong please?
08/07/2004 19:38
Please respond to
dev
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> <!---
--->
<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]
--
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]
