Wouldn't this do the trick...
<select multiple name="ModifiedSize">
<cfoutput query="GetSizes">
<cfif SizeID eq GetItemsizes.FKSizeID>
<option value="#SizeID#" selected="selected">#Size#</option>
</cfif>
<option value="#SizeID#">#Size#</option>
</cfoutput>
</select>
And it's certainly better performance wise to use a normal cfif over IIF.
Andy
Quoting "Russ Michaels (Snake)" <[EMAIL PROTECTED]>:
> 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]
>
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
--
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]
