Put the selected sizes in a list, and then when you loop over the query to
create the selectlist options, check if each value is in the list.
E.G
<cfset selectedItems = Valuelist(GetItemSizes.FKSizeIF)>
<select multiple name="ModifiedSize">
<cfoutput query="GetSizes">
<option value="#GetSizes.SizeID#" #IIF(Listcontains(SelectedItems, SizeID),
DE('selected'),DE(''))#>#GetSizes.Size#</option>
</cfoutput>
</select>
Russ
> -----Original Message-----
> From: Paul Swingewood [mailto:[EMAIL PROTECTED]
> Sent: 19 September 2004 21:11
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] Slect Multiple
>
> 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]
>
>
--
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]
