No need to be nasty ... the intention wasn't meant to start a debate about IIF.
Andy Quoting "Russ Michaels (Snake)" <[EMAIL PROTECTED]>: > Oh don't start with that IIF performance , you must save 10000th of a > millisend crap please... It's pathetic. > > > > -----Original Message----- > > From: Andy Allan [mailto:[EMAIL PROTECTED] > > Sent: 20 September 2004 09:33 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] Slect Multiple > > > > 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] > > > > > > > > -- > 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]
