don't use cfselect.
<cfform>
<select name="select_size" size="4">
<cfloop query="getItem">
<option value="#getItem.ItemSize#">
#getItem.ItemSize#</option>
</cfloop>
</select>
</cfform>
I'm assuming the top-level loop around the form is incorrect?
in fact, hang on, the query has maxrows 1, so there's no point looping.
let me rethink what you're trying to do: have a select from 1 to 9, with
the size of this shoe pre-selected?
<cfset shoesizes = "1,2,3,4,5,6,7,8,9">
<cfform>
<select name="select_size" size="4">
<cfloop index="size" list="#shoesizes#">
<cfif getItem.ItemSize = size> <!--- preselect it --->
<option value="#size#" selected>#size#</option>
<cfelse>
<option value="#size#">#size#</option>
</cfif>
</cfloop>
</select>
</cfform>
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: Re: [ cf-dev ] OnChange?
08/07/2004 17:29
Please respond to
dev
Oh yeah one other quick question ...
I have a cell with shoes sizes like this 1,2,3,4,5,6,7,8,9 (a list)
I want to populate a <cfselect> from the list ...
So,
<CFQUERY NAME="GetItem" MAXROWS="1" DATASOURCE="#application.dsn#">
SELECT DISTINCT tblitems.itemID, tblitems.partNum,
tblitems.itemName,
tblitems.itemDescription, tblitems.itemCost, tblitems.itemImage,
tblitems.itemColour, tblitems.itemSize, tblitems.itembigimage
FROM tblitems
WHERE (((tblitems.itemID)=#url.itemID#))
</CFQUERY>
Get the item
Now I guess I need some kind of loop to loop the list ....
<cfloop index = "listelements"
list = "#getItem.itemSize#"
delimiters = ",">
<cfform>
<cfselect query = "getItem"
name = "select_size"
size = "4"
value = "#getItem.itemSize#"
display = "#getItem.itemSize#">
</cfselect>
</cfform>
</cfloop>
As expected this is not right but I think you get the idea of what I am
trying to do ...
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]
