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
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
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
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#
: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
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
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
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
: 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
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
10 matches
Mail list logo