I have a modify form. I want to show the multiple values of a select that
were cosen when the user entered the data.
I have this....
<!--- This query gets those sizes that were selected --->
<cfquery name="GetItemSizes" datasource="#application.dsn#">
SELECT FKSizeID,
FKItemID
FROM tblItemSizes
WHERE (FKItemID = #url.ItemID#)
</cfquery>
<!--- This query gets all possible sizes -->
<cfquery name="GetSizes" datasource="#application.dsn#">
SELECT SizeID, Size
FROM tblSizes
WHERE 0=0
ORDER BY size ASC
</cfquery>
Ok now show the selection ...
<tr>
<td valign="top">Size :</td>
<td valign="top">
<select multiple name="ModifiedSize">
<cfoutput query="GetSizes">
<cfif GetSizes.SizeID eq #GetItemsizes.FKSizeID#>
<option value="#SizeID#" selected>#GetSizes.Size#</option>
<cfelse>
<option value="#GetSizes.SizeID#">#GetSizes.Size#</option>
</cfif>
</cfoutput>
</select>
</td>
</tr>
The thing is this shows only one selection :-(
How do I loop coorectly to show all of the previous selections?
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]
