This is a multi-part message in MIME format.
------=_NextPart_000_025D_01C0015C.FC0970B0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
RE: Multiple value SelectTry
listfindnocase(getpg.pg,EditNameQry.PracticeGroup)
and see if that works.
----- Original Message -----=20
From: Gieseman, Athelene=20
To: '[EMAIL PROTECTED]'=20
Sent: Tuesday, August 08, 2000 17:09
Subject: RE: Multiple value Select
Thanks for the quick response. Tried that and no luck. =20
Athelene=20
-----Original Message-----=20
From: David E. Crawford [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 12:10 PM=20
To: [EMAIL PROTECTED]=20
Subject: Re: Multiple value Select=20
This is a multi-part message in MIME format.=20
------=3D_NextPart_000_0242_01C0015B.7347C930=20
Content-Type: text/plain;=20
charset=3D"Windows-1252"=20
Content-Transfer-Encoding: quoted-printable=20
RE: Multiple value SelectSee if changing:=20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)=20
to=20
ListContains(GetPG.PG,EditNameQry.PracticeGroup)=20
Makes a difference. The # signs are not required inside CF functions. =
DC=20
----- Original Message -----=3D20=20
From: Gieseman, Athelene=3D20=20
To: '[EMAIL PROTECTED]'=3D20=20
Sent: Tuesday, August 08, 2000 17:03=20
Subject: RE: Multiple value Select=20
OK. I have another application where I do in fact use a table for =
the =3D=20
lookup. I've tried to use your example and apply it here. But =3D=20
nothing is=3D20=20
selected. My code is as follows:=3D20=20
<cfquery datasource=3D3D"FirmDirectory" name=3D3D"EditNameQry">=3D20 =
Select * from Employees where ID=3D3D'#EditGrid.ID#'=3D20=20
</cfquery>=3D20=20
<cfquery datasource=3D3D"FirmDirectory" name=3D3D"GetPG">=3D20=20
Select * from PracticeGroups order by PG=3D20=20
</cfquery>=3D20=20
<cfselect name=3D3D"NewPG" size=3D3D"3" multiple>=3D20=20
<CFLoop query=3D3D"GetPG">=3D20=20
<CFIF=3D20=20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=3D20=20
<CFSET PGSelected =3D3D "Selected">=3D20=20
<CFELSE>=3D20=20
<CFSET PGSelected =3D3D "">=3D20=20
</cfif>=3D20=20
<Option #PGSelected#=3D20=20
value=3D3D"#PG#"><cfoutput>#PG#</cfoutput></option>=3D20=20
</cfloop>=3D20=20
</cfselect>=3D20=20
Note that if I replace the : <CFIF=3D20=20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=3D20=20
with: <CFIF ListContains(GetPG.PG,"Agribusiness")>=3D20=20
Then Agribusiness is in fact selected. So I'm assuming there's =3D=20
something=3D20=20
wrong with that one line. Do you happen to see where I went =
wrong?=3D20=20
TIA,=3D20=20
Athelene=3D20=20
-----Original Message-----=3D20=20
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=3D20=20
Sent: Tuesday, August 08, 2000 7:44 AM=3D20=20
To: [EMAIL PROTECTED]=3D20=20
Subject: RE: Multiple value Select=3D20=20
I did this sort of thing for an intranet i'm working on with =
selected=3D20=20
company newsgroups... The best way to do it is with a database of =
your =3D=20
finance types. This will allow you to updae the select statement =
=3D=20
without=3D20=20
changing the hard coding. So the form will always be right. Query =
=3D=20
that=3D20=20
database and the user database. In the user database, you will want =
=3D=20
to save=3D20=20
a comma delimited list of the finance types they are assigned for. =
=3D=20
When you=3D20=20
bring up the select, you can scroll through all the finance types, =
and =3D=20
if=3D20=20
the user had any in his/her list, they will set the FinanceSelected =
=3D=20
variable=3D20=20
to 'selected.' if they're not in the list, FinanceSelected will be =
=3D=20
blank.=3D20=20
Hope this helps...=3D20=20
<CFQuery Name=3D3D"GetFinances" =
datasource=3D3D"#Application.datasource#"> =3D=20
SELECT FinanceName=3D20=20
FROM tblFinances=3D20=20
ORDER By FinanceName=3D20=20
</CFQuery>=3D20=20
<CFQuery Name=3D3D"GetCustomer" =
datasource=3D3D"#Application.datasource#"> =3D=20
SELECT CustomerName,=3D20=20
Address,=3D20=20
Finances <!--- This Field is a comma =
delimited =3D=20
list=3D20=20
of the user's=3D20=20
finances --->=3D20=20
FROM tblCustomers=3D20=20
WHERE CustomerID =3D3D #Attributes.CustomerID#=3D20=20
</cfgquery>=3D20=20
Finances:<br>=3D20=20
<Select Name=3D3D"Finances" size=3D3D"#GetFinances.RecordCount#" =
multiple> =3D=20
<CFLoop query=3D3D"Finances">=3D20=20
<CFIF ListContains(GetCustomer.Finances,#FinanceName#)>=3D20=20
<CFSET FinanceSelected =3D3D "Selected">=3D20=20
<CFELSE>=3D20=20
<CFSET FinanceSelected =3D3D "">=3D20=20
</cfif>=3D20=20
<Option #FiannceSelected# =3D=20
value=3D3D"#FinanceName#">#FinanceName#</option>=3D20=20
</cfloop>=3D20=20
</select>=3D20=20
Mark Armendariz=3D20=20
Righteous Design=3D20=20
www.sorighteous.com=3D20=20
[EMAIL PROTECTED]=3D20=20
-----Original Message-----=3D20=20
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=3D20=20
Sent: Monday, August 07, 2000 6:34 PM=3D20=20
To: [EMAIL PROTECTED]=3D20=20
Subject: Multiple value Select=3D20=20
I'm trying to set up a CFSELECT using the SELECTED option. I need =
to =3D=20
have=3D20=20
the CFSELECT set up as multiple since more than one option is =3D=20
permitted.=3D20=20
However, I can never seem to get the SELECTED option to properly =3D =
highlight=3D20=20
the options that are already stored in the record. (In other words, =
I =3D=20
want=3D20=20
to create an edit screen where the previously stored values are =3D=20
preselected=3D20=20
in this control.) Any thoughts on what I may be doing wrong? The =
=3D=20
code for=3D20=20
my select follows: (Note that ViewGrid is a grid from which the =
user=3D20=20
previously selected this record. I've also tried doing this from a =
=3D=20
query=3D20=20
with the same result - nothing is selected.)=3D20=20
<cfselect name=3D3D"FinanceType" size=3D3D"2" =3D=20
selected=3D3D"#ViewGrid.FinanceType#"=3D20=20
multiple>=3D20=20
<option value=3D3D"Single Family Housing">Single Family =
Housing</option> =3D=20
<option value=3D3D"501(c)(3)">501(c)(3)</option>=3D20=20
<option value=3D3D"Hospital Revenue">Hospital Revenue</option>=3D20=20
<option value=3D3D"Leasehold Revenue">Leasehold =
Revenue</option>=3D20=20
<option value=3D3D"Multifamily Housing">Multifamily =
Housing</option>=3D20=20
<option value=3D3D"General Obligation">General =
Obligation</option>=3D20=20
<option value=3D3D"NID">NID</option>=3D20=20
<option value=3D3D"Special Obligation">Special =
Obligation</option>=3D20=20
<option value=3D3D"Industrial Development">Industrial =3D=20
Development</option>=3D20=20
<option value=3D3D"TIF">TIF</option>=3D20=20
<option value=3D3D"TDD/TC">TDD/TC</option>=3D20=20
<option value=3D3D"Other">Other</option>=3D20=20
</cfselect>=3D20=20
=3D=20
=
-------------------------------------------------------------------------=
=3D=20
---=3D20=20
--=3D20=20
Archives: =
http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20=20
To Unsubscribe visit=3D20=20
=3D=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D3Dlists/c=
f_ta=3D=20
lk or=3D20=20
send a message to [EMAIL PROTECTED] with =
'unsubscribe' =3D=20
in=3D20=20
the body.=3D20=20
=3D=20
=
-------------------------------------------------------------------------=
=3D=20
---=3D20=20
--=3D20=20
Archives: =
http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20=20
To Unsubscribe visit=3D20=20
=3D=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D3Dlists/c=
f_ta=3D=20
lk or=3D20=20
send a message to [EMAIL PROTECTED] with =
'unsubscribe' =3D=20
in=3D20=20
the body.=3D20=20
=3D=20
=
-------------------------------------------------------------------------=
=3D=20
-----=3D20=20
Archives: =
http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20=20
To Unsubscribe visit =3D=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D3Dlists/c=
f_ta=3D=20
lk or send a message to [EMAIL PROTECTED] with =3D=20
'unsubscribe' in the body.=20
------=3D_NextPart_000_0242_01C0015B.7347C930=20
Content-Type: text/html;=20
charset=3D"Windows-1252"=20
Content-Transfer-Encoding: quoted-printable=20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">=20
<HTML><HEAD><TITLE>RE: Multiple value Select</TITLE>=20
<META content=3D3D"text/html; charset=3D3Dwindows-1252" =3D=20
http-equiv=3D3DContent-Type>=20
<META content=3D3D"MSHTML 5.00.3018.900" name=3D3DGENERATOR>=20
<STYLE></STYLE>=20
</HEAD>=20
<BODY bgColor=3D3D#ffffff>=20
<DIV><FONT face=3D3DArial size=3D3D2>See if changing:</FONT></DIV>=20
<DIV> </DIV>=20
<DIV><FONT face=3D3DArial size=3D3D2><FONT=3D20=20
=
size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)</FONT></FON=
T>=3D=20
</DIV>=20
<DIV> </DIV>=20
<DIV><FONT face=3D3DArial size=3D3D2>to</FONT></DIV>=20
<DIV> </DIV>=20
<DIV><FONT face=3D3DArial size=3D3D2><FONT=3D20=20
=
size=3D3D2>ListContains(GetPG.PG,EditNameQry.PracticeGroup)</FONT></FONT>=
</=3D=20
DIV>=20
<DIV> </DIV>=20
<DIV><FONT face=3D3DArial size=3D3D2>Makes a difference. The # =
signs =3D=20
are not=3D20=20
required inside CF functions.</FONT></DIV>=20
<DIV> </DIV>=20
<DIV><FONT face=3D3DArial size=3D3D2>DC</FONT></DIV>=20
<DIV> </DIV>=20
<BLOCKQUOTE=3D20=20
style=3D3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: =3D=20
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">=20
<DIV style=3D3D"FONT: 10pt arial">----- Original Message ----- =
</DIV>=20
<DIV=3D20=20
style=3D3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =3D=20
black"><B>From:</B>=3D20=20
<A href=3D3D"mailto:[EMAIL PROTECTED]" =3D=20
[EMAIL PROTECTED]>Gieseman,=3D20=20
Athelene</A> </DIV>=20
<DIV style=3D3D"FONT: 10pt arial"><B>To:</B> <A=3D20=20
href=3D3D"mailto:'[EMAIL PROTECTED]'"=3D20=20
[EMAIL PROTECTED]>'[EMAIL PROTECTED]'</A> =
=3D=20
</DIV>=20
<DIV style=3D3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, August 08, =
2000=3D20=20
17:03</DIV>=20
<DIV style=3D3D"FONT: 10pt arial"><B>Subject:</B> RE: Multiple value =
=3D=20
Select</DIV>=20
<DIV><BR></DIV>=20
<P><FONT size=3D3D2>OK. I have another application where I do =
in =3D=20
fact use a=3D20=20
table for the</FONT> <BR><FONT size=3D3D2>lookup. I've tried =
to =3D=20
use your=3D20=20
example and apply it here. But nothing is</FONT> =
<BR><FONT=3D20=20
size=3D3D2>selected. My code is as follows:</FONT> </P>=20
<P><FONT size=3D3D2><cfquery datasource=3D3D"FirmDirectory"=3D20=20
name=3D3D"EditNameQry"></FONT> <BR><FONT size=3D3D2>Select * from =
=3D=20
Employees where=3D20=20
ID=3D3D'#EditGrid.ID#'</FONT> <BR><FONT =
size=3D3D2></cfquery></FONT> =3D=20
</P>=20
<P><FONT size=3D3D2><cfquery datasource=3D3D"FirmDirectory" =3D=20
name=3D3D"GetPG"></FONT>=3D20=20
<BR><FONT size=3D3D2>Select * from PracticeGroups order by PG</FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2></cfquery></FONT> </P>=20
<P><FONT size=3D3D2> =
<cfselect=3D20=20
name=3D3D"NewPG" size=3D3D"3" multiple></FONT>=3D20=20
<BR> =3D20=20
=3D20=20
<FONT =
size=3D3D2><CFLoop=3D20=20
query=3D3D"GetPG"></FONT> =3D=20
<BR> =3D20=20
=3D20=20
<FONT =3D=20
size=3D3D2><CFIF</FONT>=3D20=20
<BR><FONT =3D=20
=
size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)></FONT>=3D=
20=20
<BR> =3D20=20
=3D20=20
<FONT =
size=3D3D2><CFSET =3D=20
PGSelected =3D3D=3D20=20
"Selected"></FONT> =
<BR> =3D20=20
=3D20=20
<FONT =3D=20
size=3D3D2><CFELSE></FONT>=3D20=20
<BR><FONT size=3D3D2> =3D20=20
<CFSET PGSelected =
=3D3D=3D20=20
""></FONT> <BR> =3D20=20
=3D20=20
<FONT =3D=20
size=3D3D2></cfif></FONT>=3D20=20
<BR> =3D20=20
=3D20=20
<FONT =
size=3D3D2><Option=3D20=20
#PGSelected#</FONT> <BR><FONT=3D20=20
=3D=20
=
size=3D3D2>value=3D3D"#PG#"><cfoutput>#PG#</cfoutput></=
opti=3D=20
on></FONT>=3D20=20
<BR> =3D20=20
=3D20=20
<FONT =3D=20
size=3D3D2></cfloop></FONT>=3D20=20
<BR> =3D20=20
<FONT=3D20=20
size=3D3D2></cfselect></FONT> </P>=20
<P><FONT size=3D3D2>Note that if I replace the : =
<CFIF</FONT> =3D=20
<BR><FONT=3D20=20
=
size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)></FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2>with: <CFIF =3D=20
ListContains(GetPG.PG,"Agribusiness")></FONT>=3D20=20
</P>=20
<P><FONT size=3D3D2>Then Agribusiness is in fact selected. So =
I'm =3D=20
assuming=3D20=20
there's something</FONT> <BR><FONT size=3D3D2>wrong with that one =
=3D=20
line. Do=3D20=20
you happen to see where I went wrong? </FONT></P>=20
<P><FONT size=3D3D2>TIA,</FONT> </P>=20
<P><FONT size=3D3D2>Athelene </FONT></P>=20
<P><FONT size=3D3D2>-----Original Message-----</FONT> <BR><FONT =3D=20
size=3D3D2>From: Mark=3D20=20
Armendariz [<A=3D20=20
=3D=20
=
href=3D3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</=
FO=3D=20
NT>=3D20=20
<BR><FONT size=3D3D2>Sent: Tuesday, August 08, 2000 7:44 AM</FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =3D=20
size=3D3D2>Subject: RE:=3D20=20
Multiple value Select</FONT> </P><BR>=20
<P><FONT size=3D3D2>I did this sort of thing for an intranet i'm =
working =3D=20
on with=3D20=20
selected</FONT> <BR><FONT size=3D3D2>company newsgroups... The best =
way =3D=20
to do it=3D20=20
is with a database of your</FONT> <BR><FONT size=3D3D2>finance =3D=20
types. This=3D20=20
will allow you to updae the select statement without</FONT> =
<BR><FONT=3D20=20
size=3D3D2>changing the hard coding. So the form will always =
be =3D=20
right. =3D20=20
Query that</FONT> <BR><FONT size=3D3D2>database and the user =3D=20
database. In=3D20=20
the user database, you will want to save</FONT> <BR><FONT =
size=3D3D2>a =3D=20
comma=3D20=20
delimited list of the finance types they are assigned for. =
When=3D20=20
you</FONT> <BR><FONT size=3D3D2>bring up the select, you can scroll =
=3D=20
through all=3D20=20
the finance types, and if</FONT> <BR><FONT size=3D3D2>the user had =
any =3D=20
in his/her=3D20=20
list, they will set the FinanceSelected variable</FONT> <BR><FONT =
=3D=20
size=3D3D2>to=3D20=20
'selected.' if they're not in the list, FinanceSelected will =
be=3D20=20
blank.</FONT> </P>=20
<P><FONT size=3D3D2>Hope this helps...</FONT> </P>=20
<P><FONT size=3D3D2><CFQuery Name=3D3D"GetFinances"=3D20=20
datasource=3D3D"#Application.datasource#"></FONT> <BR><FONT =3D=20
size=3D3D2> =3D20=20
SELECT FinanceName</FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2> FROM tblFinances</FONT> <BR><FONT =3D=20
size=3D3D2> ORDER=3D20=20
By FinanceName</FONT> <BR><FONT=3D20=20
size=3D3D2></CFQuery></FONT> </P>=20
<P><FONT size=3D3D2><CFQuery Name=3D3D"GetCustomer"=3D20=20
datasource=3D3D"#Application.datasource#"></FONT> <BR><FONT =3D=20
size=3D3D2> =3D20=20
SELECT =
CustomerName,</FONT>=3D20=20
<BR> =3D20=20
<FONT =3D=20
size=3D3D2>Address,</FONT>=3D20=20
<BR> =3D20=20
<FONT=3D20=20
size=3D3D2>Finances =
<!--- =3D=20
This Field=3D20=20
is a comma delimited list</FONT> <BR><FONT size=3D3D2>of the =3D=20
user's</FONT>=3D20=20
<BR><FONT size=3D3D2>finances ---></FONT> <BR><FONT =
size=3D3D2> =3D=20
FROM =3D20=20
tblCustomers</FONT> <BR><FONT size=3D3D2> WHERE CustomerID =
=3D3D=3D20=20
#Attributes.CustomerID#</FONT> <BR><FONT =3D=20
size=3D3D2></cfgquery></FONT>=3D20=20
</P><BR>=20
<P><FONT size=3D3D2>Finances:<br></FONT> </P>=20
<P><FONT size=3D3D2><Select Name=3D3D"Finances" =3D=20
size=3D3D"#GetFinances.RecordCount#"=3D20=20
multiple></FONT> <BR><FONT size=3D3D2> <CFLoop=3D20=20
query=3D3D"Finances"></FONT> <BR><FONT =
size=3D3D2> =3D=20
<CFIF=3D20=20
ListContains(GetCustomer.Finances,#FinanceName#)></FONT> =
<BR><FONT=3D20=20
size=3D3D2> <CFSET FinanceSelected =
=3D3D=3D20=20
"Selected"></FONT> <BR><FONT size=3D3D2> =3D20=20
<CFELSE></FONT> <BR><FONT =3D=20
size=3D3D2> =3D20=20
<CFSET FinanceSelected =3D3D ""></FONT> <BR><FONT =3D=20
size=3D3D2> =3D20=20
</cfif></FONT> <BR><FONT size=3D3D2> =
<Option=3D20=20
#FiannceSelected# =3D=20
value=3D3D"#FinanceName#">#FinanceName#</option></FONT>=3D20=20
<BR><FONT size=3D3D2> </cfloop></FONT> <BR><FONT=3D20=20
size=3D3D2></select></FONT> </P><BR><BR>=20
<P><FONT size=3D3D2>Mark Armendariz</FONT> <BR><FONT =
size=3D3D2>Righteous=3D20=20
Design</FONT> <BR><FONT size=3D3D2>www.sorighteous.com</FONT> =
<BR><FONT=3D20=20
size=3D3D2>[EMAIL PROTECTED]</FONT> </P><BR>=20
<P><FONT size=3D3D2>-----Original Message-----</FONT> <BR><FONT =3D=20
size=3D3D2>From:=3D20=20
Gieseman, Athelene [<A=3D20=20
=3D=20
=
href=3D3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]=
</=3D=20
FONT>=3D20=20
<BR><FONT size=3D3D2>Sent: Monday, August 07, 2000 6:34 PM</FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =3D=20
size=3D3D2>Subject: Multiple=3D20=20
value Select</FONT> </P><BR>=20
<P><FONT size=3D3D2>I'm trying to set up a CFSELECT using the =
SELECTED=3D20=20
option. I need to have</FONT> <BR><FONT size=3D3D2>the =
CFSELECT =3D=20
set up as=3D20=20
multiple since more than one option is permitted.</FONT> =
<BR><FONT=3D20=20
size=3D3D2>However, I can never seem to get the SELECTED option to =
=3D=20
properly=3D20=20
highlight</FONT> <BR><FONT size=3D3D2>the options that are already =
=3D=20
stored in the=3D20=20
record. (In other words, I want</FONT> <BR><FONT size=3D3D2>to =
=3D=20
create an=3D20=20
edit screen where the previously stored values are =
preselected</FONT>=3D20=20
<BR><FONT size=3D3D2>in this control.) Any thoughts on what I =
may =3D=20
be doing=3D20=20
wrong? The code for</FONT> <BR><FONT size=3D3D2>my select =3D=20
follows: =3D20=20
(Note that ViewGrid is a grid from which the user</FONT> =
<BR><FONT=3D20=20
size=3D3D2>previously selected this record. I've also tried =
doing =3D=20
this from=3D20=20
a query</FONT> <BR><FONT size=3D3D2>with the same result - nothing =
is=3D20=20
selected.)</FONT> </P>=20
<P><FONT size=3D3D2><cfselect name=3D3D"FinanceType" =
size=3D3D"2"=3D20=20
selected=3D3D"#ViewGrid.FinanceType#"</FONT> <BR><FONT =3D=20
size=3D3D2>multiple></FONT>=3D20=20
<BR><FONT size=3D3D2><option value=3D3D"Single Family =3D=20
Housing">Single Family=3D20=20
Housing</option></FONT> <BR><FONT size=3D3D2><option=3D20=20
value=3D3D"501(c)(3)">501(c)(3)</option></FONT> =
<BR><FONT=3D20=20
size=3D3D2><option value=3D3D"Hospital Revenue">Hospital=3D20=20
Revenue</option></FONT> <BR><FONT size=3D3D2><option =3D=20
value=3D3D"Leasehold=3D20=20
Revenue">Leasehold Revenue</option></FONT> <BR><FONT=3D20=20
size=3D3D2><option value=3D3D"Multifamily =
Housing">Multifamily=3D20=20
Housing</option></FONT> <BR><FONT size=3D3D2><option =3D=20
value=3D3D"General=3D20=20
Obligation">General Obligation</option></FONT> =
<BR><FONT=3D20=20
size=3D3D2><option value=3D3D"NID">NID</option></FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2><option value=3D3D"Special Obligation">Special=3D20 =
Obligation</option></FONT> <BR><FONT size=3D3D2><option =3D =
value=3D3D"Industrial=3D20=20
Development">Industrial Development</option></FONT> =
<BR><FONT =3D=20
size=3D3D2><option value=3D3D"TIF">TIF</option></FONT> =
=3D=20
<BR><FONT=3D20=20
size=3D3D2><option =
value=3D3D"TDD/TC">TDD/TC</option></FONT> =3D=20
<BR><FONT=3D20=20
size=3D3D2><option =
value=3D3D"Other">Other</option></FONT> =3D=20
<BR><FONT=3D20=20
size=3D3D2></cfselect></FONT> <BR><FONT=3D20=20
=3D=20
=
size=3D3D2>--------------------------------------------------------------=
--=3D=20
------------</FONT>=3D20=20
<BR><FONT size=3D3D2>--</FONT> <BR><FONT size=3D3D2>Archives: =
<A=3D20=20
=
href=3D3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/<=
/A=3D=20
></FONT>=3D20=20
<BR><FONT size=3D3D2>To Unsubscribe visit</FONT> <BR><FONT =
size=3D3D2><A=3D20=20
=3D=20
=
href=3D3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D=
3D=3D=20
lists/cf_talk"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlist=
s&am=3D=20
p;body=3D3Dlists/cf_talk</A>=3D20=20
or</FONT> <BR><FONT size=3D3D2>send a message to =3D=20
[EMAIL PROTECTED]=3D20=20
with 'unsubscribe' in</FONT> <BR><FONT size=3D3D2>the body.</FONT> =
</P>=20
<P><FONT=3D20=20
=3D=20
=
size=3D3D2>--------------------------------------------------------------=
--=3D=20
------------</FONT>=3D20=20
<BR><FONT size=3D3D2>--</FONT> <BR><FONT size=3D3D2>Archives: =
<A=3D20=20
=
href=3D3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/<=
/A=3D=20
></FONT>=3D20=20
<BR><FONT size=3D3D2>To Unsubscribe visit</FONT> <BR><FONT =
size=3D3D2><A=3D20=20
=3D=20
=
href=3D3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D=
3D=3D=20
lists/cf_talk"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlist=
s&am=3D=20
p;body=3D3Dlists/cf_talk</A>=3D20=20
or</FONT> <BR><FONT size=3D3D2>send a message to =3D=20
[EMAIL PROTECTED]=3D20=20
with 'unsubscribe' in</FONT> <BR><FONT size=3D3D2>the body.</FONT> =
=3D=20
<BR><FONT=3D20=20
=3D=20
=
size=3D3D2>--------------------------------------------------------------=
--=3D=20
--------------</FONT>=3D20=20
<BR><FONT size=3D3D2>Archives: <A=3D20=20
=
href=3D3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/<=
/A=3D=20
></FONT>=3D20=20
<BR><FONT size=3D3D2>To Unsubscribe visit <A=3D20=20
=3D=20
=
href=3D3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=3D=
3D=3D=20
lists/cf_talk"=3D20=20
=3D=20
=
target=3D3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlist=
s&am=3D=20
p;body=3D3Dlists/cf_talk</A>=3D20=20
or send a message to [EMAIL PROTECTED] with =3D=20
'unsubscribe' in=3D20=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>=20
------=3D_NextPart_000_0242_01C0015B.7347C930--=20
=
-------------------------------------------------------------------------=
---=20
--=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit=20
=
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or=20
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in=20
the body.=20
=
-------------------------------------------------------------------------=
-----=20
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20
To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
------=_NextPart_000_025D_01C0015C.FC0970B0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Multiple value Select</TITLE>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Try</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial=20
size=3D2>listfindnocase(getpg.pg,EditNameQry.PracticeGroup)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>and see if that works.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Gieseman,=20
Athelene</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:'[EMAIL PROTECTED]'"=20
[EMAIL PROTECTED]>'[EMAIL PROTECTED]'</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, August 08, 2000=20
17:09</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Multiple value =
Select</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>Thanks for the quick response. Tried that and =
no=20
luck. </FONT></P>
<P><FONT size=3D2>Athelene</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: David=20
E. Crawford [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:dcrawford@yalesecurity.=
com</A>]</FONT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 12:10 PM</FONT> =
<BR><FONT=20
size=3D2>To: <A=20
=
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A></=
FONT>=20
<BR><FONT size=3D2>Subject: Re: Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>This is a multi-part message in MIME format.</FONT> =
</P>
<P><FONT size=3D2>------=3D_NextPart_000_0242_01C0015B.7347C930</FONT> =
<BR><FONT=20
size=3D2>Content-Type: text/plain;</FONT>=20
<BR> <FONT=20
size=3D2>charset=3D"Windows-1252"</FONT> <BR><FONT=20
size=3D2>Content-Transfer-Encoding: quoted-printable</FONT> </P>
<P><FONT size=3D2>RE: Multiple value SelectSee if changing:</FONT> =
</P>
<P><FONT =
size=3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)</FONT> </P>
<P><FONT size=3D2>to</FONT> </P>
<P><FONT =
size=3D2>ListContains(GetPG.PG,EditNameQry.PracticeGroup)</FONT> </P>
<P><FONT size=3D2>Makes a difference. The # signs are not =
required inside=20
CF functions.</FONT> </P>
<P><FONT size=3D2>DC</FONT> </P>
<P><FONT size=3D2> ----- Original Message -----=3D20</FONT> =
<BR><FONT=20
size=3D2> From: Gieseman, Athelene=3D20</FONT> <BR><FONT =
size=3D2> To:=20
'[EMAIL PROTECTED]'=3D20</FONT> <BR><FONT size=3D2> =
Sent: Tuesday,=20
August 08, 2000 17:03</FONT> <BR><FONT size=3D2> Subject: RE: =
Multiple=20
value Select</FONT> </P><BR>
<P><FONT size=3D2> OK. I have another application where I =
do in fact=20
use a table for the =3D</FONT> </P>
<P><FONT size=3D2> lookup. I've tried to use your example =
and apply=20
it here. But =3D</FONT> <BR><FONT size=3D2>nothing =
is=3D20</FONT> <BR><FONT=20
size=3D2> selected. My code is as follows:=3D20</FONT> =
</P>
<P><FONT size=3D2> <cfquery datasource=3D3D"FirmDirectory"=20
name=3D3D"EditNameQry">=3D20</FONT> <BR><FONT size=3D2> =
Select * from=20
Employees where ID=3D3D'#EditGrid.ID#'=3D20</FONT> <BR><FONT =
size=3D2> =20
</cfquery>=3D20</FONT> </P>
<P><FONT size=3D2> <cfquery datasource=3D3D"FirmDirectory"=20
name=3D3D"GetPG">=3D20</FONT> <BR><FONT size=3D2> Select * =
from=20
PracticeGroups order by PG=3D20</FONT> <BR><FONT size=3D2> =20
</cfquery>=3D20</FONT> </P>
<P><FONT =
size=3D2> =20
<cfselect name=3D3D"NewPG" size=3D3D"3" multiple>=3D20</FONT> =
<BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
<CFLoop query=3D3D"GetPG">=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
<CFIF=3D20</FONT> <BR><FONT size=3D2> =20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=3D20</FONT> =
<BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
<CFSET PGSelected =3D3D "Selected">=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
<CFELSE>=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p; =20
<CFSET PGSelected =3D3D "">=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
</cfif>=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
<Option #PGSelected#=3D20</FONT> <BR><FONT size=3D2> =20
=
value=3D3D"#PG#"><cfoutput>#PG#</cfoutput></option>=3D=
20</FONT>=20
<BR><FONT=20
=
size=3D2> &nbs=
p;  =
; =20
</cfloop>=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p; =20
</cfselect>=3D20</FONT> </P>
<P><FONT size=3D2> Note that if I replace the : =
<CFIF=3D20</FONT>=20
<BR><FONT size=3D2> =20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=3D20</FONT> =
<BR><FONT=20
size=3D2> with: <CFIF=20
ListContains(GetPG.PG,"Agribusiness")>=3D20</FONT> </P>
<P><FONT size=3D2> Then Agribusiness is in fact selected. =
So I'm=20
assuming there's =3D</FONT> <BR><FONT size=3D2>something=3D20</FONT> =
<BR><FONT=20
size=3D2> wrong with that one line. Do you happen to see =
where I=20
went wrong?=3D20</FONT> </P>
<P><FONT size=3D2> TIA,=3D20</FONT> </P>
<P><FONT size=3D2> Athelene=3D20</FONT> </P>
<P><FONT size=3D2> -----Original Message-----=3D20</FONT> =
<BR><FONT=20
size=3D2> From: Mark Armendariz [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]=3D2=
0</FONT>=20
<BR><FONT size=3D2> Sent: Tuesday, August 08, 2000 7:44 =
AM=3D20</FONT>=20
<BR><FONT size=3D2> To: [EMAIL PROTECTED]=3D20</FONT> =
<BR><FONT=20
size=3D2> Subject: RE: Multiple value Select=3D20</FONT> =
</P><BR><BR>
<P><FONT size=3D2> I did this sort of thing for an intranet i'm =
working on=20
with selected=3D20</FONT> <BR><FONT size=3D2> company =
newsgroups... The best=20
way to do it is with a database of your =3D</FONT> </P>
<P><FONT size=3D2> finance types. This will allow you to =
updae the=20
select statement =3D</FONT> <BR><FONT size=3D2>without=3D20</FONT> =
<BR><FONT=20
size=3D2> changing the hard coding. So the form will =
always be=20
right. Query =3D</FONT> <BR><FONT size=3D2>that=3D20</FONT> =
<BR><FONT=20
size=3D2> database and the user database. In the user =
database, you=20
will want =3D</FONT> <BR><FONT size=3D2>to save=3D20</FONT> <BR><FONT =
size=3D2> =20
a comma delimited list of the finance types they are assigned =
for. =20
=3D</FONT> <BR><FONT size=3D2>When you=3D20</FONT> <BR><FONT =
size=3D2> bring up=20
the select, you can scroll through all the finance types, and =
=3D</FONT>=20
<BR><FONT size=3D2>if=3D20</FONT> <BR><FONT size=3D2> the user =
had any in=20
his/her list, they will set the FinanceSelected =3D</FONT> <BR><FONT=20
size=3D2>variable=3D20</FONT> <BR><FONT size=3D2> to =
'selected.' if=20
they're not in the list, FinanceSelected will be =3D</FONT> <BR><FONT=20
size=3D2>blank.=3D20</FONT> </P>
<P><FONT size=3D2> Hope this helps...=3D20</FONT> </P>
<P><FONT size=3D2> <CFQuery Name=3D3D"GetFinances"=20
datasource=3D3D"#Application.datasource#"> =3D</FONT> </P>
<P><FONT size=3D2> =20
SELECT =
FinanceName=3D20</FONT>=20
<BR><FONT size=3D2> FROM =
tblFinances=3D20</FONT> <BR><FONT=20
size=3D2> ORDER By =20
FinanceName=3D20</FONT> <BR><FONT size=3D2> =
</CFQuery>=3D20</FONT> </P>
<P><FONT size=3D2> <CFQuery Name=3D3D"GetCustomer"=20
datasource=3D3D"#Application.datasource#"> =3D</FONT> </P>
<P><FONT size=3D2> =20
SELECT =
CustomerName,=3D20</FONT>=20
<BR><FONT=20
=
size=3D2> &nbs=
p; =20
Address,=3D20</FONT> <BR><FONT=20
=
size=3D2> &nbs=
p; =20
Finances <!--- This Field =
is a=20
comma delimited =3D</FONT> <BR><FONT size=3D2>list=3D20</FONT> =
<BR><FONT=20
size=3D2> of the user's=3D20</FONT> <BR><FONT size=3D2> =
finances=20
--->=3D20</FONT> <BR><FONT size=3D2> FROM =20
tblCustomers=3D20</FONT> <BR><FONT size=3D2> WHERE =
CustomerID=20
=3D3D #Attributes.CustomerID#=3D20</FONT> <BR><FONT size=3D2> =20
</cfgquery>=3D20</FONT> </P><BR><BR>
<P><FONT size=3D2> Finances:<br>=3D20</FONT> </P>
<P><FONT size=3D2> <Select Name=3D3D"Finances"=20
size=3D3D"#GetFinances.RecordCount#" multiple> =3D</FONT> </P>
<P><FONT size=3D2> <CFLoop =
query=3D3D"Finances">=3D20</FONT>=20
<BR><FONT size=3D2> <CFIF=20
ListContains(GetCustomer.Finances,#FinanceName#)>=3D20</FONT> =
<BR><FONT=20
size=3D2> <CFSET =
FinanceSelected=20
=3D3D "Selected">=3D20</FONT> <BR><FONT =
size=3D2> =20
<CFELSE>=3D20</FONT> <BR><FONT=20
size=3D2> <CFSET =
FinanceSelected=20
=3D3D "">=3D20</FONT> <BR><FONT =
size=3D2> =20
</cfif>=3D20</FONT> <BR><FONT =
size=3D2> =20
<Option #FiannceSelected# =3D</FONT> <BR><FONT=20
=
size=3D2>value=3D3D"#FinanceName#">#FinanceName#</option>=3D20</=
FONT>=20
<BR><FONT size=3D2> </cfloop>=3D20</FONT> =
<BR><FONT=20
size=3D2> </select>=3D20</FONT> </P><BR><BR><BR>
<P><FONT size=3D2> Mark Armendariz=3D20</FONT> <BR><FONT =
size=3D2> =20
Righteous Design=3D20</FONT> <BR><FONT size=3D2> =20
www.sorighteous.com=3D20</FONT> <BR><FONT size=3D2> =20
[EMAIL PROTECTED]=3D20</FONT> </P><BR><BR>
<P><FONT size=3D2> -----Original Message-----=3D20</FONT> =
<BR><FONT=20
size=3D2> From: Gieseman, Athelene [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]=3D=
20</FONT>=20
<BR><FONT size=3D2> Sent: Monday, August 07, 2000 6:34 =
PM=3D20</FONT>=20
<BR><FONT size=3D2> To: [EMAIL PROTECTED]=3D20</FONT> =
<BR><FONT=20
size=3D2> Subject: Multiple value Select=3D20</FONT> =
</P><BR><BR>
<P><FONT size=3D2> I'm trying to set up a CFSELECT using the =
SELECTED=20
option. I need to =3D</FONT> <BR><FONT size=3D2>have=3D20</FONT> =
<BR><FONT=20
size=3D2> the CFSELECT set up as multiple since more than one =
option is=20
=3D</FONT> <BR><FONT size=3D2>permitted.=3D20</FONT> <BR><FONT =
size=3D2> =20
However, I can never seem to get the SELECTED option to properly =
=3D</FONT>=20
<BR><FONT size=3D2>highlight=3D20</FONT> <BR><FONT size=3D2> the =
options that=20
are already stored in the record. (In other words, I =3D</FONT> =
<BR><FONT=20
size=3D2>want=3D20</FONT> <BR><FONT size=3D2> to create an edit =
screen where=20
the previously stored values are =3D</FONT> <BR><FONT=20
size=3D2>preselected=3D20</FONT> <BR><FONT size=3D2> in this =
control.) =20
Any thoughts on what I may be doing wrong? The =3D</FONT> =
<BR><FONT=20
size=3D2>code for=3D20</FONT> <BR><FONT size=3D2> my select =
follows: =20
(Note that ViewGrid is a grid from which the user=3D20</FONT> =
<BR><FONT=20
size=3D2> previously selected this record. I've also tried =
doing=20
this from a =3D</FONT> <BR><FONT size=3D2>query=3D20</FONT> <BR><FONT =
size=3D2> =20
with the same result - nothing is selected.)=3D20</FONT> </P>
<P><FONT size=3D2> <cfselect name=3D3D"FinanceType" =
size=3D3D"2" =3D</FONT>=20
<BR><FONT size=3D2>selected=3D3D"#ViewGrid.FinanceType#"=3D20</FONT> =
<BR><FONT=20
size=3D2> multiple>=3D20</FONT> <BR><FONT size=3D2> =
<option=20
value=3D3D"Single Family Housing">Single Family =
Housing</option>=20
=3D</FONT> </P>
<P><FONT size=3D2> <option=20
value=3D3D"501(c)(3)">501(c)(3)</option>=3D20</FONT> =
<BR><FONT=20
size=3D2> <option value=3D3D"Hospital Revenue">Hospital=20
Revenue</option>=3D20</FONT> <BR><FONT size=3D2> =
<option=20
value=3D3D"Leasehold Revenue">Leasehold =
Revenue</option>=3D20</FONT>=20
<BR><FONT size=3D2> <option value=3D3D"Multifamily=20
Housing">Multifamily Housing</option>=3D20</FONT> <BR><FONT=20
size=3D2> <option value=3D3D"General Obligation">General=20
Obligation</option>=3D20</FONT> <BR><FONT size=3D2> =
<option=20
value=3D3D"NID">NID</option>=3D20</FONT> <BR><FONT =
size=3D2> =20
<option value=3D3D"Special Obligation">Special=20
Obligation</option>=3D20</FONT> <BR><FONT size=3D2> =
<option=20
value=3D3D"Industrial Development">Industrial =3D</FONT> <BR><FONT=20
size=3D2>Development</option>=3D20</FONT> <BR><FONT =
size=3D2> <option=20
value=3D3D"TIF">TIF</option>=3D20</FONT> <BR><FONT =
size=3D2> =20
<option value=3D3D"TDD/TC">TDD/TC</option>=3D20</FONT> =
<BR><FONT=20
size=3D2> <option =
value=3D3D"Other">Other</option>=3D20</FONT>=20
<BR><FONT size=3D2> </cfselect>=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
---------=3D</FONT>=20
<BR><FONT size=3D2>---=3D20</FONT> <BR><FONT size=3D2> =
--=3D20</FONT> <BR><FONT=20
size=3D2> Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D=
20</A></FONT>=20
<BR><FONT size=3D2> To Unsubscribe visit=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3Dlists/cf_ta=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3Dlists/cf_ta=3D</A></FONT>=20
<BR><FONT size=3D2>lk or=3D20</FONT> <BR><FONT size=3D2> send a =
message to=20
[EMAIL PROTECTED] with 'unsubscribe' =3D</FONT> =
<BR><FONT=20
size=3D2>in=3D20</FONT> <BR><FONT size=3D2> the =
body.=3D20</FONT> </P>
<P><FONT size=3D2> =3D</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
---------=3D</FONT>=20
<BR><FONT size=3D2>---=3D20</FONT> <BR><FONT size=3D2> =
--=3D20</FONT> <BR><FONT=20
size=3D2> Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D=
20</A></FONT>=20
<BR><FONT size=3D2> To Unsubscribe visit=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3Dlists/cf_ta=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3Dlists/cf_ta=3D</A></FONT>=20
<BR><FONT size=3D2>lk or=3D20</FONT> <BR><FONT size=3D2> send a =
message to=20
[EMAIL PROTECTED] with 'unsubscribe' =3D</FONT> =
<BR><FONT=20
size=3D2>in=3D20</FONT> <BR><FONT size=3D2> the =
body.=3D20</FONT> <BR><FONT=20
size=3D2> =3D</FONT> <BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
---------=3D</FONT>=20
<BR><FONT size=3D2>-----=3D20</FONT> <BR><FONT size=3D2> =
Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D20"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/=3D=
20</A></FONT>=20
<BR><FONT size=3D2> To Unsubscribe visit =3D</FONT> <BR><FONT =
size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3Dlists/cf_ta=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3Dlists/cf_ta=3D</A></FONT>=20
<BR><FONT size=3D2>lk or send a message to =
[EMAIL PROTECTED]=20
with =3D</FONT> <BR><FONT size=3D2>'unsubscribe' in the body.</FONT> =
</P><BR>
<P><FONT size=3D2>------=3D_NextPart_000_0242_01C0015B.7347C930</FONT> =
<BR><FONT=20
size=3D2>Content-Type: text/html;</FONT>=20
<BR> <FONT=20
size=3D2>charset=3D"Windows-1252"</FONT> <BR><FONT=20
size=3D2>Content-Transfer-Encoding: quoted-printable</FONT> </P>
<P><FONT size=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0=20
Transitional//EN"></FONT> <BR><FONT=20
size=3D2><HTML><HEAD><TITLE>RE: Multiple value=20
Select</TITLE></FONT> <BR><FONT size=3D2><META =
content=3D3D"text/html;=20
charset=3D3Dwindows-1252" =3D</FONT> <BR><FONT=20
size=3D2>http-equiv=3D3DContent-Type></FONT> <BR><FONT =
size=3D2><META=20
content=3D3D"MSHTML 5.00.3018.900" name=3D3DGENERATOR></FONT> =
<BR><FONT=20
size=3D2><STYLE></STYLE></FONT> <BR><FONT=20
size=3D2></HEAD></FONT> <BR><FONT size=3D2><BODY=20
bgColor=3D3D#ffffff></FONT> <BR><FONT size=3D2><DIV><FONT =
face=3D3DArial=20
size=3D3D2>See if changing:</FONT></DIV></FONT> =
<BR><FONT=20
size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><DIV><FONT face=3D3DArial =
size=3D3D2><FONT=3D20</FONT>=20
<BR><FONT=20
=
size=3D2>size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)=
</FONT></FONT>=3D</FONT>=20
<BR><FONT size=3D2></DIV></FONT> <BR><FONT=20
size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><DIV><FONT face=3D3DArial=20
size=3D3D2>to</FONT></DIV></FONT> <BR><FONT=20
size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><DIV><FONT face=3D3DArial =
size=3D3D2><FONT=3D20</FONT>=20
<BR><FONT=20
=
size=3D2>size=3D3D2>ListContains(GetPG.PG,EditNameQry.PracticeGroup)&l=
t;/FONT></FONT></=3D</FONT>=20
<BR><FONT size=3D2>DIV></FONT> <BR><FONT=20
size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><DIV><FONT face=3D3DArial size=3D3D2>Makes a=20
difference.&nbsp; The # signs =3D</FONT> <BR><FONT size=3D2>are =
not=3D20</FONT>=20
<BR><FONT size=3D2>required inside CF =
functions.</FONT></DIV></FONT>=20
<BR><FONT size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><DIV><FONT face=3D3DArial=20
size=3D3D2>DC</FONT></DIV></FONT> <BR><FONT=20
size=3D2><DIV>&nbsp;</DIV></FONT> <BR><FONT=20
size=3D2><BLOCKQUOTE=3D20</FONT> <BR><FONT =
size=3D2>style=3D3D"BORDER-LEFT: #000000=20
2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =3D</FONT> <BR><FONT =
size=3D2>0px;=20
PADDING-LEFT: 5px; PADDING-RIGHT: 0px"></FONT> <BR><FONT =
size=3D2> =20
<DIV style=3D3D"FONT: 10pt arial">----- Original Message -----=20
</DIV></FONT> <BR><FONT size=3D2> <DIV=3D20</FONT> =
<BR><FONT=20
size=3D2> style=3D3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; =
font-color:=20
=3D</FONT> <BR><FONT =
size=3D2>black"><B>From:</B>=3D20</FONT>=20
<BR><FONT size=3D2> <A href=3D3D"<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>" =
=3D</FONT>=20
<BR><FONT =
size=3D2>[EMAIL PROTECTED]>Gieseman,=3D20</FONT>=20
<BR><FONT size=3D2> Athelene</A> </DIV></FONT> =
<BR><FONT=20
size=3D2> <DIV style=3D3D"FONT: 10pt =
arial"><B>To:</B>=20
<A=3D20</FONT> <BR><FONT size=3D2> href=3D3D"<A=20
=
href=3D"mailto:'[EMAIL PROTECTED]'">mailto:'cf-talk@houseoffusion=
.com'</A>"=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
[EMAIL PROTECTED]>'[EMAIL PROTECTED]'</A&=
gt;=20
=3D</FONT> <BR><FONT size=3D2></DIV></FONT> <BR><FONT =
size=3D2> <DIV=20
style=3D3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, =
August 08,=20
2000=3D20</FONT> <BR><FONT size=3D2>17:03</DIV></FONT> <BR><FONT =
size=3D2> <DIV style=3D3D"FONT: 10pt=20
arial"><B>Subject:</B> RE: Multiple value =3D</FONT> =
<BR><FONT=20
size=3D2>Select</DIV></FONT> <BR><FONT size=3D2> =20
<DIV><BR></DIV></FONT> <BR><FONT size=3D2> =20
<P><FONT size=3D3D2>OK.&nbsp; I have another =
application where I=20
do in =3D</FONT> <BR><FONT size=3D2>fact use a=3D20</FONT> <BR><FONT =
size=3D2> =20
table for the</FONT> <BR><FONT =
size=3D3D2>lookup.&nbsp;=20
I've tried to =3D</FONT> <BR><FONT size=3D2>use your=3D20</FONT> =
<BR><FONT=20
size=3D2> example and apply it here.&nbsp; But nothing =
is</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>selected.&nbsp; My code is as follows:</FONT>=20
</P></FONT> <BR><FONT size=3D2> <P><FONT=20
size=3D3D2>&lt;cfquery =
datasource=3D3D"FirmDirectory"=3D20</FONT> <BR><FONT=20
size=3D2> name=3D3D"EditNameQry"&gt;</FONT> =
<BR><FONT=20
size=3D3D2>Select * from =3D</FONT> <BR><FONT size=3D2>Employees =
where=3D20</FONT>=20
<BR><FONT size=3D2> ID=3D3D'#EditGrid.ID#'</FONT> =
<BR><FONT=20
size=3D3D2>&lt;/cfquery&gt;</FONT> =3D</FONT> =
<BR><FONT=20
size=3D2></P></FONT> <BR><FONT size=3D2> <P><FONT =
size=3D3D2>&lt;cfquery datasource=3D3D"FirmDirectory" =
=3D</FONT> <BR><FONT=20
size=3D2>name=3D3D"GetPG"&gt;</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>Select * from PracticeGroups order by =
PG</FONT> =3D</FONT> <BR><FONT =
size=3D2><BR><FONT=3D20</FONT>=20
<BR><FONT size=3D2> =
size=3D3D2>&lt;/cfquery&gt;</FONT>=20
</P></FONT> <BR><FONT size=3D2> <P><FONT=20
size=3D3D2>&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;=20
&lt;cfselect=3D20</FONT> <BR><FONT size=3D2> =
name=3D3D"NewPG" size=3D3D"3"=20
multiple&gt;</FONT>=3D20</FONT> <BR><FONT size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT size=3D3D2>&lt;CFLoop=3D20</FONT> <BR><FONT =
size=3D2> =20
query=3D3D"GetPG"&gt;</FONT> =3D</FONT> <BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>&lt;CFIF</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT =3D</FONT> <BR><FONT=20
=
size=3D2>size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)=
&gt;</FONT>=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT size=3D3D2>&lt;CFSET =3D</FONT> <BR><FONT =
size=3D2>PGSelected=20
=3D3D=3D20</FONT> <BR><FONT size=3D2> =
"Selected"&gt;</FONT>=20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>&lt;CFELSE&gt;</FONT>=3D20</FONT> =
<BR><FONT=20
size=3D2> <BR><FONT=20
size=3D3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;=3D20</FONT> <BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;CFSET PGSelected =3D3D=3D20</FONT> <BR><FONT size=3D2> =20
""&gt;</FONT>=20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>&lt;/cfif&gt;</FONT>=3D20</FONT> =
<BR><FONT=20
size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT size=3D3D2>&lt;Option=3D20</FONT> <BR><FONT =
size=3D2> =20
#PGSelected#</FONT> <BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT=20
=
size=3D2>size=3D3D2>value=3D3D"#PG#"&gt;&lt;cfoutput&gt;#P=
G#&lt;/cfoutput&gt;&lt;/opti=3D</FONT>=20
<BR><FONT size=3D2>on&gt;</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=3D=
20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT =3D</FONT> <BR><FONT=20
=
size=3D2>size=3D3D2>&lt;/cfloop&gt;</FONT>=3D20</FONT> =
<BR><FONT=20
size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&lt;/cfselect&gt;</FONT> </P></FONT> =
<BR><FONT=20
size=3D2> <P><FONT size=3D3D2>Note that if I replace =
the=20
:&nbsp; &lt;CFIF</FONT> =3D</FONT> <BR><FONT=20
size=3D2><BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
=
size=3D3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)&gt;&=
lt;/FONT>=20
=3D</FONT> <BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>with:&nbsp; &lt;CFIF =3D</FONT> <BR><FONT=20
=
size=3D2>ListContains(GetPG.PG,"Agribusiness")&gt;</FONT>=3D20<=
/FONT>=20
<BR><FONT size=3D2> </P></FONT> <BR><FONT size=3D2> =20
<P><FONT size=3D3D2>Then Agribusiness is in fact =
selected.&nbsp;=20
So I'm =3D</FONT> <BR><FONT size=3D2>assuming=3D20</FONT> <BR><FONT =
size=3D2> =20
there's something</FONT> <BR><FONT size=3D3D2>wrong =
with that=20
one =3D</FONT> <BR><FONT size=3D2>line.&nbsp; Do=3D20</FONT> =
<BR><FONT=20
size=3D2> you happen to see where I went wrong?=20
</FONT></P></FONT> <BR><FONT size=3D2> =
<P><FONT=20
size=3D3D2>TIA,</FONT> </P></FONT> <BR><FONT =
size=3D2> =20
<P><FONT size=3D3D2>Athelene =
</FONT></P></FONT>=20
<BR><FONT size=3D2> <P><FONT =
size=3D3D2>-----Original=20
Message-----</FONT> <BR><FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>From: Mark=3D20</FONT> <BR><FONT =
size=3D2> Armendariz=20
[<A=3D20</FONT> <BR><FONT size=3D2> =3D</FONT> <BR><FONT =
size=3D2>href=3D3D"<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>">=
<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A></=
A>]</FO=3D</FONT>=20
<BR><FONT size=3D2>NT>=3D20</FONT> <BR><FONT size=3D2> =
<BR><FONT=20
size=3D3D2>Sent: Tuesday, August 08, 2000 7:44 AM</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>To: [EMAIL PROTECTED]</FONT> =
<BR><FONT=20
=3D</FONT> <BR><FONT size=3D2>size=3D3D2>Subject: RE:=3D20</FONT> =
<BR><FONT=20
size=3D2> Multiple value Select</FONT> =
</P><BR></FONT>=20
<BR><FONT size=3D2> <P><FONT size=3D3D2>I did this =
sort of thing=20
for an intranet i'm working =3D</FONT> <BR><FONT size=3D2>on =
with=3D20</FONT>=20
<BR><FONT size=3D2> selected</FONT> <BR><FONT=20
size=3D3D2>company newsgroups... The best way =3D</FONT> <BR><FONT =
size=3D2>to do=20
it=3D20</FONT> <BR><FONT size=3D2> is with a database of =
your</FONT>=20
<BR><FONT size=3D3D2>finance =3D</FONT> <BR><FONT=20
size=3D2>types.&nbsp; This=3D20</FONT> <BR><FONT size=3D2> =
will allow you=20
to updae the select statement without</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =
size=3D3D2>changing the=20
hard coding.&nbsp; So the form will always be =3D</FONT> <BR><FONT =
size=3D2>right.&nbsp;=3D20</FONT> <BR><FONT size=3D2> Query=20
that</FONT> <BR><FONT size=3D3D2>database and the =
user=20
=3D</FONT> <BR><FONT size=3D2>database.&nbsp; In=3D20</FONT> =
<BR><FONT=20
size=3D2> the user database, you will want to save</FONT>=20
<BR><FONT size=3D3D2>a =3D</FONT> <BR><FONT =
size=3D2>comma=3D20</FONT>=20
<BR><FONT size=3D2> delimited list of the finance types they are =
assigned=20
for.&nbsp; When=3D20</FONT> <BR><FONT size=3D2> =
you</FONT>=20
<BR><FONT size=3D3D2>bring up the select, you can scroll =
=3D</FONT>=20
<BR><FONT size=3D2>through all=3D20</FONT> <BR><FONT size=3D2> =
the finance=20
types, and if</FONT> <BR><FONT size=3D3D2>the user =
had any=20
=3D</FONT> <BR><FONT size=3D2>in his/her=3D20</FONT> <BR><FONT =
size=3D2> list,=20
they will set the FinanceSelected variable</FONT> =
<BR><FONT=20
=3D</FONT> <BR><FONT size=3D2>size=3D3D2>to=3D20</FONT> <BR><FONT =
size=3D2> =20
'selected.'&nbsp; if they're not in the list, FinanceSelected will =
be=3D20</FONT> <BR><FONT size=3D2> blank.</FONT> =
</P></FONT>=20
<BR><FONT size=3D2> <P><FONT size=3D3D2>Hope this=20
helps...</FONT> </P></FONT> <BR><FONT size=3D2> =20
<P><FONT size=3D3D2>&lt;CFQuery =
Name=3D3D"GetFinances"=3D20</FONT>=20
<BR><FONT size=3D2> =20
datasource=3D3D"#Application.datasource#"&gt;</FONT>=20
<BR><FONT =3D</FONT> <BR><FONT =
size=3D2>size=3D3D2>&nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
FinanceName</FONT> =3D</FONT> <BR><FONT=20
size=3D2><BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&nbsp; FROM&nbsp; tblFinances</FONT>=20
<BR><FONT =3D</FONT> <BR><FONT =
size=3D2>size=3D3D2>&nbsp;=20
ORDER=3D20</FONT> <BR><FONT size=3D2> =20
By&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
FinanceName</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&lt;/CFQuery&gt;</FONT> </P></FONT> =
<BR><FONT=20
size=3D2> <P><FONT size=3D3D2>&lt;CFQuery=20
Name=3D3D"GetCustomer"=3D20</FONT> <BR><FONT size=3D2> =20
datasource=3D3D"#Application.datasource#"&gt;</FONT>=20
<BR><FONT =3D</FONT> <BR><FONT =
size=3D2>size=3D3D2>&nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
CustomerName,</FONT>=3D20</FONT> <BR><FONT size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT =3D</FONT> <BR><FONT =
size=3D2>size=3D3D2>Address,</FONT>=3D20</FONT>=20
<BR><FONT size=3D2> =20
=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&am=
p;nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> =20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<FONT=3D20</FONT> <BR><FONT size=3D2> =20
=
size=3D3D2>Finances&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
amp;nbsp;&nbsp;=20
&lt;!--- =3D</FONT> <BR><FONT size=3D2>This Field=3D20</FONT> =
<BR><FONT=20
size=3D2> is a comma delimited list</FONT> =
<BR><FONT=20
size=3D3D2>of the =3D</FONT> <BR><FONT =
size=3D2>user's</FONT>=3D20</FONT>=20
<BR><FONT size=3D2> <BR><FONT size=3D3D2>finances=20
---&gt;</FONT> <BR><FONT size=3D3D2>&nbsp; =
=3D</FONT>=20
<BR><FONT size=3D2>FROM&nbsp;=3D20</FONT> <BR><FONT =
size=3D2> =20
tblCustomers</FONT> <BR><FONT size=3D3D2>&nbsp; =
WHERE=20
CustomerID =3D3D=3D20</FONT> <BR><FONT size=3D2> =20
#Attributes.CustomerID#</FONT> <BR><FONT =3D</FONT> =
<BR><FONT=20
=
size=3D2>size=3D3D2>&lt;/cfgquery&gt;</FONT>=3D20</FONT>=
<BR><FONT=20
size=3D2> </P><BR></FONT> <BR><FONT size=3D2> =20
<P><FONT =
size=3D3D2>Finances:&lt;br&gt;</FONT>=20
</P></FONT> <BR><FONT size=3D2> <P><FONT=20
size=3D3D2>&lt;Select Name=3D3D"Finances" =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D"#GetFinances.RecordCount#"=3D20</FONT> <BR><FONT =
size=3D2> =20
multiple&gt;</FONT> <BR><FONT =
size=3D3D2>&nbsp;=20
&lt;CFLoop=3D20</FONT> <BR><FONT size=3D2> =20
query=3D3D"Finances"&gt;</FONT> <BR><FONT=20
size=3D3D2>&nbsp;&nbsp;&nbsp; =3D</FONT> <BR><FONT=20
size=3D2>&lt;CFIF=3D20</FONT> <BR><FONT size=3D2> =20
ListContains(GetCustomer.Finances,#FinanceName#)&gt;</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;CFSET=20
FinanceSelected =3D3D=3D20</FONT> <BR><FONT size=3D2> =20
"Selected"&gt;</FONT> <BR><FONT=20
size=3D3D2>&nbsp;&nbsp;&nbsp;=3D20</FONT> <BR><FONT =
size=3D2> =20
&lt;CFELSE&gt;</FONT> <BR><FONT =3D</FONT> =
<BR><FONT=20
=
size=3D2>size=3D3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=3D20</FONT>=20
<BR><FONT size=3D2> &lt;CFSET FinanceSelected =3D3D=20
""&gt;</FONT> <BR><FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>&nbsp;&nbsp;&nbsp;=3D20</FONT> =
<BR><FONT=20
size=3D2> &lt;/cfif&gt;</FONT> <BR><FONT=20
size=3D3D2>&nbsp;&nbsp;&nbsp; =
&lt;Option=3D20</FONT> <BR><FONT=20
size=3D2> #FiannceSelected# =3D</FONT> <BR><FONT=20
=
size=3D2>value=3D3D"#FinanceName#"&gt;#FinanceName#&lt;/option&am=
p;gt;</FONT>=3D20</FONT>=20
<BR><FONT size=3D2> <BR><FONT size=3D3D2>&nbsp;=20
&lt;/cfloop&gt;</FONT> <BR><FONT=3D20</FONT> =
<BR><FONT=20
size=3D2> size=3D3D2>&lt;/select&gt;</FONT>=20
</P><BR><BR></FONT> <BR><FONT size=3D2> =20
<P><FONT size=3D3D2>Mark Armendariz</FONT> =
<BR><FONT=20
size=3D3D2>Righteous=3D20</FONT> <BR><FONT size=3D2> =
Design</FONT>=20
<BR><FONT size=3D3D2>www.sorighteous.com</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>[EMAIL PROTECTED]</FONT> =
</P><BR></FONT>=20
<BR><FONT size=3D2> <P><FONT =
size=3D3D2>-----Original=20
Message-----</FONT> <BR><FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>From:=3D20</FONT> <BR><FONT size=3D2> =
Gieseman, Athelene=20
[<A=3D20</FONT> <BR><FONT size=3D2> =3D</FONT> <BR><FONT =
size=3D2>href=3D3D"<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>"&g=
t;<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A><=
;/A>]</=3D</FONT>=20
<BR><FONT size=3D2>FONT>=3D20</FONT> <BR><FONT size=3D2> =
<BR><FONT=20
size=3D3D2>Sent: Monday, August 07, 2000 6:34 PM</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>To: [EMAIL PROTECTED]</FONT> =
<BR><FONT=20
=3D</FONT> <BR><FONT size=3D2>size=3D3D2>Subject: =
Multiple=3D20</FONT> <BR><FONT=20
size=3D2> value Select</FONT> </P><BR></FONT> =
<BR><FONT=20
size=3D2> <P><FONT size=3D3D2>I'm trying to set up a =
CFSELECT=20
using the SELECTED=3D20</FONT> <BR><FONT size=3D2> =
option.&nbsp; I need=20
to have</FONT> <BR><FONT size=3D3D2>the CFSELECT =
=3D</FONT>=20
<BR><FONT size=3D2>set up as=3D20</FONT> <BR><FONT size=3D2> =
multiple since=20
more than one option is permitted.</FONT> =
<BR><FONT=3D20</FONT>=20
<BR><FONT size=3D2> size=3D3D2>However, I can never seem to =
get the=20
SELECTED option to =3D</FONT> <BR><FONT size=3D2>properly=3D20</FONT> =
<BR><FONT=20
size=3D2> highlight</FONT> <BR><FONT =
size=3D3D2>the=20
options that are already =3D</FONT> <BR><FONT size=3D2>stored in =
the=3D20</FONT>=20
<BR><FONT size=3D2> record.&nbsp; (In other words, I =
want</FONT>=20
<BR><FONT size=3D3D2>to =3D</FONT> <BR><FONT =
size=3D2>create=20
an=3D20</FONT> <BR><FONT size=3D2> edit screen where the =
previously stored=20
values are preselected</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>in this control.)&nbsp; Any =
thoughts on=20
what I may =3D</FONT> <BR><FONT size=3D2>be doing=3D20</FONT> =
<BR><FONT=20
size=3D2> wrong?&nbsp; The code for</FONT> =
<BR><FONT=20
size=3D3D2>my select =3D</FONT> <BR><FONT =
size=3D2>follows:&nbsp;=3D20</FONT>=20
<BR><FONT size=3D2> (Note that ViewGrid is a grid from which the =
user</FONT> <BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>previously selected this record.&nbsp; I've also =
tried doing=20
=3D</FONT> <BR><FONT size=3D2>this from=3D20</FONT> <BR><FONT =
size=3D2> a=20
query</FONT> <BR><FONT size=3D3D2>with the same =
result -=20
nothing is=3D20</FONT> <BR><FONT size=3D2> =
selected.)</FONT>=20
</P></FONT> <BR><FONT size=3D2> <P><FONT=20
size=3D3D2>&lt;cfselect name=3D3D"FinanceType" =
size=3D3D"2"=3D20</FONT>=20
<BR><FONT size=3D2> =
selected=3D3D"#ViewGrid.FinanceType#"</FONT>=20
<BR><FONT =3D</FONT> <BR><FONT=20
size=3D2>size=3D3D2>multiple&gt;</FONT>=3D20</FONT> =
<BR><FONT=20
size=3D2> <BR><FONT size=3D3D2>&lt;option =
value=3D3D"Single=20
Family =3D</FONT> <BR><FONT size=3D2>Housing"&gt;Single =
Family=3D20</FONT>=20
<BR><FONT size=3D2> Housing&lt;/option&gt;</FONT>=20
<BR><FONT size=3D3D2>&lt;option=3D20</FONT> <BR><FONT=20
size=3D2> =20
=
value=3D3D"501(c)(3)"&gt;501(c)(3)&lt;/option&gt;</FONT>=
;=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&lt;option value=3D3D"Hospital=20
Revenue"&gt;Hospital=3D20</FONT> <BR><FONT size=3D2> =20
Revenue&lt;/option&gt;</FONT> <BR><FONT=20
size=3D3D2>&lt;option =3D</FONT> <BR><FONT=20
size=3D2>value=3D3D"Leasehold=3D20</FONT> <BR><FONT size=3D2> =20
Revenue"&gt;Leasehold Revenue&lt;/option&gt;</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&lt;option value=3D3D"Multifamily=20
Housing"&gt;Multifamily=3D20</FONT> <BR><FONT size=3D2> =20
Housing&lt;/option&gt;</FONT> <BR><FONT=20
size=3D3D2>&lt;option =3D</FONT> <BR><FONT=20
size=3D2>value=3D3D"General=3D20</FONT> <BR><FONT size=3D2> =20
Obligation"&gt;General =
Obligation&lt;/option&gt;</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =20
size=3D3D2>&lt;option=20
value=3D3D"NID"&gt;NID&lt;/option&gt;</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>&lt;option value=3D3D"Special=20
Obligation"&gt;Special=3D20</FONT> <BR><FONT size=3D2> =20
Obligation&lt;/option&gt;</FONT> <BR><FONT=20
size=3D3D2>&lt;option =3D</FONT> <BR><FONT=20
size=3D2>value=3D3D"Industrial=3D20</FONT> <BR><FONT size=3D2> =20
Development"&gt;Industrial =
Development&lt;/option&gt;</FONT>=20
<BR><FONT =3D</FONT> </P>
<P><FONT size=3D2> size=3D3D2>&lt;option=20
value=3D3D"TIF"&gt;TIF&lt;/option&gt;</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>&lt;option=20
value=3D3D"TDD/TC"&gt;TDD/TC&lt;/option&gt;</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>&lt;option=20
value=3D3D"Other"&gt;Other&lt;/option&gt;</FONT> =
=3D</FONT>=20
<BR><FONT size=3D2><BR><FONT=3D20</FONT> <BR><FONT =
size=3D2> =20
size=3D3D2>&lt;/cfselect&gt;</FONT>=20
<BR><FONT=3D20</FONT> <BR><FONT size=3D2> =3D</FONT> =
<BR><FONT=20
=
size=3D2>size=3D3D2>--------------------------------------------------=
--------------=3D</FONT>=20
<BR><FONT size=3D2>------------</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>--</FONT> <BR><FONT=20
size=3D3D2>Archives: <A=3D20</FONT> <BR><FONT size=3D2> =
href=3D3D"<A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
>"=3D20</FONT>=20
<BR><FONT size=3D2> =3D</FONT> <BR><FONT =
size=3D2>target=3D3D_blank><A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></A=3D</FONT>=20
<BR><FONT size=3D2>></FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>To Unsubscribe visit</FONT>=20
<BR><FONT size=3D3D2><A=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT size=3D2>href=3D3D"<A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3D=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3D=3D</A></FONT>=20
<BR><FONT size=3D2>lists/cf_talk"=3D20</FONT> <BR><FONT =
size=3D2> =3D</FONT>=20
<BR><FONT size=3D2>target=3D3D_blank><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&am=3D=
"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;am=3D</A></FONT>=20
<BR><FONT size=3D2>p;body=3D3Dlists/cf_talk</A>=3D20</FONT> =
<BR><FONT=20
size=3D2> or</FONT> <BR><FONT size=3D3D2>send =
a message to=20
=3D</FONT> <BR><FONT =
size=3D2>[EMAIL PROTECTED]=3D20</FONT>=20
<BR><FONT size=3D2> with 'unsubscribe' in</FONT> =
<BR><FONT=20
size=3D3D2>the body.</FONT> </P></FONT> <BR><FONT =
size=3D2> =20
<P><FONT=3D20</FONT> <BR><FONT size=3D2> =3D</FONT> =
<BR><FONT=20
=
size=3D2>size=3D3D2>--------------------------------------------------=
--------------=3D</FONT>=20
<BR><FONT size=3D2>------------</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>--</FONT> <BR><FONT=20
size=3D3D2>Archives: <A=3D20</FONT> <BR><FONT size=3D2> =
href=3D3D"<A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
>"=3D20</FONT>=20
<BR><FONT size=3D2> =3D</FONT> <BR><FONT =
size=3D2>target=3D3D_blank><A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></A=3D</FONT>=20
<BR><FONT size=3D2>></FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>To Unsubscribe visit</FONT>=20
<BR><FONT size=3D3D2><A=3D20</FONT> <BR><FONT =
size=3D2> =20
=3D</FONT> <BR><FONT size=3D2>href=3D3D"<A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3D=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3D=3D</A></FONT>=20
<BR><FONT size=3D2>lists/cf_talk"=3D20</FONT> <BR><FONT =
size=3D2> =3D</FONT>=20
<BR><FONT size=3D2>target=3D3D_blank><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&am=3D=
"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;am=3D</A></FONT>=20
<BR><FONT size=3D2>p;body=3D3Dlists/cf_talk</A>=3D20</FONT> =
<BR><FONT=20
size=3D2> or</FONT> <BR><FONT size=3D3D2>send =
a message to=20
=3D</FONT> <BR><FONT =
size=3D2>[EMAIL PROTECTED]=3D20</FONT>=20
<BR><FONT size=3D2> with 'unsubscribe' in</FONT> =
<BR><FONT=20
size=3D3D2>the body.</FONT> =3D</FONT> <BR><FONT=20
size=3D2><BR><FONT=3D20</FONT> <BR><FONT size=3D2> =
=3D</FONT> <BR><FONT=20
=
size=3D2>size=3D3D2>--------------------------------------------------=
--------------=3D</FONT>=20
<BR><FONT size=3D2>--------------</FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>Archives: <A=3D20</FONT> <BR><FONT =
size=3D2> href=3D3D"<A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
>"=3D20</FONT>=20
<BR><FONT size=3D2> =3D</FONT> <BR><FONT =
size=3D2>target=3D3D_blank><A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></A=3D</FONT>=20
<BR><FONT size=3D2>></FONT>=3D20</FONT> <BR><FONT =
size=3D2> =20
<BR><FONT size=3D3D2>To Unsubscribe visit =
<A=3D20</FONT> <BR><FONT=20
size=3D2> =3D</FONT> <BR><FONT size=3D2>href=3D3D"<A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&body=
=3D3D=3D"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;body=3D3D=3D</A></FONT>=20
<BR><FONT size=3D2>lists/cf_talk"=3D20</FONT> <BR><FONT =
size=3D2> =3D</FONT>=20
<BR><FONT size=3D2>target=3D3D_blank><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&am=3D=
"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3D3Dlists&=
amp;am=3D</A></FONT>=20
<BR><FONT size=3D2>p;body=3D3Dlists/cf_talk</A>=3D20</FONT> =
<BR><FONT=20
size=3D2> or send a message to [EMAIL PROTECTED] =
with=20
=3D</FONT> <BR><FONT size=3D2>'unsubscribe' in=3D20</FONT> <BR><FONT =
size=3D2> =20
the=20
=
body.</FONT></P></BLOCKQUOTE></BODY></HTML>=
</FONT>=20
</P>
<P><FONT =
size=3D2>------=3D_NextPart_000_0242_01C0015B.7347C930--</FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
------------</FONT>=20
<BR><FONT size=3D2>--</FONT> <BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit</FONT> <BR><FONT size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or</FONT> <BR><FONT size=3D2>send a message to =
[EMAIL PROTECTED]=20
with 'unsubscribe' in</FONT> <BR><FONT size=3D2>the body.</FONT> =
<BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/"=20
=
target=3D_blank>http://www.mail-archive.com/cf-talk@houseoffusion.com/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_025D_01C0015C.FC0970B0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.