Re: [ cf-dev ] Slect Multiple

2004-09-20 Thread Stephen Moretti (cfmaster)
Russ Michaels (Snake) wrote: 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

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
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

Re: [ cf-dev ] Slect Multiple

2004-09-20 Thread Paul Swingewood
Thanks for that guys. It makes sense and seems to work all ok... Regards - Paul From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Slect Multiple Date: Mon, 20 Sep 2004 07:39:41 +0100 Russ Michaels (Snake) wrote: Put

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
Ar$e ... I missed the 'multiple' in the select - it's Monday morning :) Andy Quoting Andy Allan [EMAIL PROTECTED]: Wouldn't this do the trick... select multiple name=ModifiedSize cfoutput query=GetSizes cfif SizeID eq GetItemsizes.FKSizeID option value=#SizeID#

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Slect Multiple Russ Michaels (Snake) wrote: 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

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
Oh don't start with that IIF performance , you must save 1th 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

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
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

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
Sorry but I just get sick of people quoting that in some attempt to be smart when they obviously haven't tested it. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 11:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Slect Multiple No need

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Andy Allan
: Andy Allan [mailto:[EMAIL PROTECTED] Sent: 20 September 2004 11:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Slect Multiple No need to be nasty ... the intention wasn't meant to start a debate about IIF. Andy Quoting Russ Michaels (Snake) [EMAIL PROTECTED]: Oh

RE: [ cf-dev ] Slect Multiple

2004-09-20 Thread Russ Michaels \(Snake\)
silentmust not start another thread on IIF() /silent Russ -- 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