OK. I copied the code into the document. Now it's not liking the first
quote in the CFSELECT statement:
<cfselect name=3D"NewPG" size=3D"3" multiple>
Did I just misunderstand what the 3D represented? Is there just a syntax
error I'm not seeing. Tried to find some reference to it in the books I
have (I assumed it stood for dimension?) with no luck.
TIA,
Athelene
-----Original Message-----
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 7:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Multiple value Select
This is a multi-part message in MIME format.
------=_NextPart_000_00EF_01C001FF.3F8198C0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
RE: Multiple value SelectOk, now we have a bit of information.
Try this:
<cfselect name=3D"NewPG" size=3D"3" multiple>=20
<CFOutput query=3D"GetPG"> <!--- OPENING CFOUTPUT --->=20
<CFIF ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)>=20
<CFSET PGSelected =3D "Selected">=20
<CFELSE>=20
<CFSET PGSelected =3D "">=20
</cfif>=20
<Option #PGSelected# value=3D"#PG#">#PG#</option> <!--- NO=20
CFOUTPUTS --->=20
</cfoutput> <!--- CLOSING CFOUTPUT --->=20
</cfselect>=20
Change the order of the parameters to the =
Listfindnocase()/Listcontains() functions. If EditNameQry.PracticeGroup =
is a comma seperated list and GETPG.PG is a single value, this should =
work.
DC
----- Original Message -----=20
From: Gieseman, Athelene=20
To: '[EMAIL PROTECTED]'=20
Sent: Tuesday, August 08, 2000 21:36
Subject: RE: Multiple value Select
No. That field would have multiple items in a comma-delimited format. =
Not=20
even the first option is selected.=20
Athelene=20
-----Original Message-----=20
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 4:33 PM=20
To: [EMAIL PROTECTED]=20
Subject: RE: Multiple value Select=20
This may be a stupid question but the query EditNameQry is only =
pulling one=20
value for PracticeGroup. Right? If not I'm sure that when you "view=20
source" you'll see that more than one option is "SELECTED". That will =
confuse the browser and it will stay on the first option.=20
--K=20
-----Original Message-----=20
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 2:04 PM=20
To: [EMAIL PROTECTED]=20
Subject: RE: Multiple value Select=20
Yo may have a point.. try putting quotes around =
EditNameQry.PracticeGroup.=20
Plus, if I replace=20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)>=20
with=20
<CFIF ListContains(GetPG.PG,"Agribusiness")>=20
the Agribusiness option is selected. So I think I'm doing something =
wrong=20
in how I'm using the second parameter of the ListContains.=20
-----Original Message-----=20
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 4:18 PM=20
To: '[EMAIL PROTECTED]'=20
Subject: RE: Multiple value Select=20
No luck. I think there's a problem in that the listcontains isn't =
finding=20
any matches. I can't figure out why. I display the previously =
selected=20
items in another part of the form and it is identical to the options =
in the=20
database. There is a comma separating the selected items. For =
example, the=20
record viewed via SQL shows: "Agribusiness,Commercial Litigation" =
(less the=20
quotes) in the field. Both of those practice groups are identically =
listed=20
in the GetPG.PG list. Yet neither of them are showing up selected in =
the=20
control. Plus, if I replace=20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)>=20
with=20
<CFIF ListContains(GetPG.PG,"Agribusiness")>=20
the Agribusiness option is selected. So I think I'm doing something =
wrong=20
in how I'm using the second parameter of the ListContains.=20
Athelene=20
-----Original Message-----=20
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 3:00 PM=20
To: [EMAIL PROTECTED]=20
Subject: RE: Multiple value Select=20
take the cfoutput tags out of the options and put them within the =
entire=20
select tag:=20
<cfselect name=3D"NewPG" size=3D"3" multiple>=20
<CFOutput query=3D"GetPG"> <!--- OPENING CFOUTPUT --->=20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)>=20
<CFSET PGSelected =3D "Selected">=20
<CFELSE>=20
<CFSET PGSelected =3D "">=20
</cfif>=20
<Option #PGSelected# value=3D"#PG#">#PG#</option> <!--- NO =
CFOUTPUTS --->=20
</cfoutput> <!--- CLOSING CFOUTPUT --->=20
</cfselect>=20
-----Original Message-----=20
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 3:44 PM=20
To: '[EMAIL PROTECTED]'=20
Subject: RE: Multiple value Select=20
Still no luck. I also added an rtrim function to each of the fields =
in that=20
line. And I've tried David's suggestion of using listcontainsnocase. =
Still=20
no luck. I also changed the code this way:=20
<CFIF =
listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup))>=20
<CFSET PGSelected =3D "Selected">=20
<CFELSE>=20
<CFSET PGSelected =3D "Not Selected">=20
</cfif>=20
<Option #PGSelected# value=3D"#PG#"><cfoutput>#PG#=20
#PGSelected#</cfoutput></option>=20
so that I would be able to see if the PGSelected was being set at all. =
When=20
I use this code, the output on all of the options has "Not Selected" =
after=20
it. So I believe the problem is that the listcontains never finds a =
match.=20
I've changed the database from a char to a varchar (based on earlier =
posts=20
about that issue), edited all of the records in the file to eliminate =
any=20
extra spaces at the end, used the rtrim function. And still it's not =
ever=20
finding a match.=20
I appreciate the continuing help! This one is making me crazy (well, =
more=20
crazy than usual.)=20
Athelene=20
-----Original Message-----=20
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 1:34 PM=20
To: [EMAIL PROTECTED]=20
Subject: RE: Multiple value Select=20
Try replacing the cfloop with cfoutput like so:=20
<cfquery datasource=3D"FirmDirectory" name=3D"EditNameQry">=20
Select *=20
FROM Employees=20
WHERE ID=3D'#EditGrid.ID#'=20
</cfquery>=20
<cfquery datasource=3D"FirmDirectory" name=3D"GetPG">=20
Select *=20
FROM PracticeGroups=20
ORDER BY PG=20
</cfquery>=20
<cfselect name=3D"NewPG" size=3D"3" multiple>=20
<CFOutput query=3D"GetPG">=20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)>=20
<CFSET PGSelected =3D "Selected">=20
<CFELSE>=20
<CFSET PGSelected =3D "">=20
</cfif>=20
<Option #PGSelected# value=3D"#PG#">#PG#</option>=20
</cfoutput>=20
</cfselect>=20
I had the CFLoop in there because i had cfoutputs around it in my =
code...=20
this should do it for you, if not, let me know...=20
-----Original Message-----=20
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 1:03 PM=20
To: '[EMAIL PROTECTED]'=20
Subject: RE: Multiple value Select=20
OK. I have another application where I do in fact use a table for the =
lookup. I've tried to use your example and apply it here. But =
nothing is=20
selected. My code is as follows:=20
<cfquery datasource=3D"FirmDirectory" name=3D"EditNameQry">=20
Select * from Employees where ID=3D'#EditGrid.ID#'=20
</cfquery>=20
<cfquery datasource=3D"FirmDirectory" name=3D"GetPG">=20
Select * from PracticeGroups order by PG=20
</cfquery>=20
<cfselect name=3D"NewPG" size=3D"3" multiple>=20
<CFLoop query=3D"GetPG">=20
<CFIF=20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=20
<CFSET PGSelected =3D "Selected">=20
<CFELSE>=20
<CFSET PGSelected =3D "">=20
</cfif>=20
<Option #PGSelected#=20
value=3D"#PG#"><cfoutput>#PG#</cfoutput></option>=20
</cfloop>=20
</cfselect>=20
Note that if I replace the : <CFIF=20
ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)>=20
with: <CFIF ListContains(GetPG.PG,"Agribusiness")>=20
Then Agribusiness is in fact selected. So I'm assuming there's =
something=20
wrong with that one line. Do you happen to see where I went wrong?=20
TIA,=20
Athelene=20
-----Original Message-----=20
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]=20
Sent: Tuesday, August 08, 2000 7:44 AM=20
To: [EMAIL PROTECTED]=20
Subject: RE: Multiple value Select=20
I did this sort of thing for an intranet i'm working on with selected=20
company newsgroups... The best way to do it is with a database of your =
finance types. This will allow you to updae the select statement =
without=20
changing the hard coding. So the form will always be right. Query =
that=20
database and the user database. In the user database, you will want =
to save=20
a comma delimited list of the finance types they are assigned for. =
When you=20
bring up the select, you can scroll through all the finance types, and =
if=20
the user had any in his/her list, they will set the FinanceSelected =
variable=20
to 'selected.' if they're not in the list, FinanceSelected will be =
blank.=20
Hope this helps...=20
<CFQuery Name=3D"GetFinances" datasource=3D"#Application.datasource#"> =
SELECT FinanceName=20
FROM tblFinances=20
ORDER By FinanceName=20
</CFQuery>=20
<CFQuery Name=3D"GetCustomer" datasource=3D"#Application.datasource#"> =
SELECT CustomerName,=20
Address,=20
Finances <!--- This Field is a comma delimited =
list=20
of the user's=20
finances --->=20
FROM tblCustomers=20
WHERE CustomerID =3D #Attributes.CustomerID#=20
</cfgquery>=20
Finances:<br>=20
<Select Name=3D"Finances" size=3D"#GetFinances.RecordCount#" multiple> =
<CFLoop query=3D"Finances">=20
<CFIF ListContains(GetCustomer.Finances,#FinanceName#)>=20
<CFSET FinanceSelected =3D "Selected">=20
<CFELSE>=20
<CFSET FinanceSelected =3D "">=20
</cfif>=20
<Option #FiannceSelected# =
value=3D"#FinanceName#">#FinanceName#</option>=20
</cfloop>=20
</select>=20
Mark Armendariz=20
Righteous Design=20
www.sorighteous.com=20
[EMAIL PROTECTED]=20
-----Original Message-----=20
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]=20
Sent: Monday, August 07, 2000 6:34 PM=20
To: [EMAIL PROTECTED]=20
Subject: Multiple value Select=20
I'm trying to set up a CFSELECT using the SELECTED option. I need to =
have=20
the CFSELECT set up as multiple since more than one option is =
permitted.=20
However, I can never seem to get the SELECTED option to properly =
highlight=20
the options that are already stored in the record. (In other words, I =
want=20
to create an edit screen where the previously stored values are =
preselected=20
in this control.) Any thoughts on what I may be doing wrong? The =
code for=20
my select follows: (Note that ViewGrid is a grid from which the user=20
previously selected this record. I've also tried doing this from a =
query=20
with the same result - nothing is selected.)=20
<cfselect name=3D"FinanceType" size=3D"2" =
selected=3D"#ViewGrid.FinanceType#"=20
multiple>=20
<option value=3D"Single Family Housing">Single Family Housing</option> =
<option value=3D"501(c)(3)">501(c)(3)</option>=20
<option value=3D"Hospital Revenue">Hospital Revenue</option>=20
<option value=3D"Leasehold Revenue">Leasehold Revenue</option>=20
<option value=3D"Multifamily Housing">Multifamily Housing</option>=20
<option value=3D"General Obligation">General Obligation</option>=20
<option value=3D"NID">NID</option>=20
<option value=3D"Special Obligation">Special Obligation</option>=20
<option value=3D"Industrial Development">Industrial =
Development</option>=20
<option value=3D"TIF">TIF</option>=20
<option value=3D"TDD/TC">TDD/TC</option>=20
<option value=3D"Other">Other</option>=20
</cfselect>=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
--=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
--=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
--=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
--=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
--=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
--=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
--=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
--=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_00EF_01C001FF.3F8198C0
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>Ok, now we have a bit of =
information.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Try this:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>
<P><FONT size=3D2> <cfselect =
name=3D"NewPG"=20
size=3D"3" multiple></FONT> =
<BR> =20
<FONT size=3D2> <CFOutput query=3D"GetPG"> <!--- =
OPENING=20
CFOUTPUT ---></FONT> </P>
<P> <FONT=20
size=3D2> <CFIF=20
ListFindNoCase(EditNameQry.PracticeGroup,GetPG.PG)></FONT>=20
<BR> =20
<FONT size=3D2><CFSET =
PGSelected =3D=20
"Selected"></FONT> <BR> =
<FONT=20
size=3D2> <CFELSE></FONT> <BR><FONT=20
size=3D2> <CFSET PGSelected =3D=20
""></FONT> <BR> <FONT=20
size=3D2> </cfif></FONT>=20
<BR> <FONT =
size=3D2> =20
<Option #PGSelected# value=3D"#PG#">#PG#</option> =
<!---=20
NO</FONT> <BR><FONT size=3D2>CFOUTPUTS ---></FONT> <BR><FONT=20
size=3D2> =
</cfoutput> =20
<!--- CLOSING CFOUTPUT ---></FONT>=20
<BR> <FONT=20
size=3D2></cfselect></FONT> </P>
<P> </P>
<P>Change the order of the parameters to the =
Listfindnocase()/Listcontains()=20
functions. If EditNameQry.PracticeGroup is a comma seperated list =
and=20
GETPG.PG is a single value, this should work.</P>
<P> </P>
<P>DC</P>
<P> </P></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
21:36</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Multiple value =
Select</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>No. That field would have multiple items in a=20
comma-delimited format. Not</FONT> <BR><FONT size=3D2>even the =
first=20
option is selected.</FONT> </P>
<P><FONT size=3D2>Athelene</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Chapman, Katrina [<A=20
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT> =
<BR><FONT=20
size=3D2>Sent: Tuesday, August 08, 2000 4:33 PM</FONT> <BR><FONT =
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 may be a stupid question but the query =
EditNameQry is=20
only pulling one</FONT> <BR><FONT size=3D2>value for =
PracticeGroup. =20
Right? If not I'm sure that when you "view</FONT> <BR><FONT=20
size=3D2>source" you'll see that more than one option is =
"SELECTED". That=20
will</FONT> <BR><FONT size=3D2>confuse the browser and it will stay on =
the first=20
option.</FONT> </P>
<P><FONT size=3D2>--K</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: Mark=20
Armendariz [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FO=
NT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 2:04 PM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>Yo may have a point.. try putting quotes around=20
EditNameQry.PracticeGroup.</FONT> </P>
<P><FONT size=3D2>Plus, if I replace</FONT> </P>
<P> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)></FONT> =
<BR><FONT=20
size=3D2>with</FONT> </P>
<P> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,"Agribusiness")></FONT> </P>
<P><FONT size=3D2>the Agribusiness option is selected. So I =
think I'm=20
doing something wrong</FONT> <BR><FONT size=3D2>in how I'm using the =
second=20
parameter of the ListContains.</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Gieseman, Athelene [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</=
FONT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 4:18 PM</FONT> =
<BR><FONT=20
size=3D2>To: '[EMAIL PROTECTED]'</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>No luck. I think there's a problem in that the =
listcontains isn't finding</FONT> <BR><FONT size=3D2>any =
matches. I can't=20
figure out why. I display the previously selected</FONT> =
<BR><FONT=20
size=3D2>items in another part of the form and it is identical to the =
options in=20
the</FONT> <BR><FONT size=3D2>database. There is a comma =
separating the=20
selected items. For example, the</FONT> <BR><FONT =
size=3D2>record viewed=20
via SQL shows: "Agribusiness,Commercial Litigation" (less =
the</FONT>=20
<BR><FONT size=3D2>quotes) in the field. Both of those practice =
groups are=20
identically listed</FONT> <BR><FONT size=3D2>in the GetPG.PG =
list. Yet=20
neither of them are showing up selected in the</FONT> <BR><FONT=20
size=3D2>control. Plus, if I replace</FONT> </P>
<P> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)></FONT> =
<BR><FONT=20
size=3D2>with</FONT> </P>
<P> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,"Agribusiness")></FONT> </P>
<P><FONT size=3D2>the Agribusiness option is selected. So I =
think I'm=20
doing something wrong</FONT> <BR><FONT size=3D2>in how I'm using the =
second=20
parameter of the ListContains.</FONT> </P><BR>
<P><FONT size=3D2>Athelene</FONT> </P><BR><BR>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: Mark=20
Armendariz [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FO=
NT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 3:00 PM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>take the cfoutput tags out of the options and put =
them within=20
the entire</FONT> <BR><FONT size=3D2>select tag:</FONT> </P>
<P><FONT size=3D2> <cfselect=20
name=3D"NewPG" size=3D"3" multiple></FONT>=20
<BR> <FONT size=3D2> =20
<CFOutput query=3D"GetPG"> <!--- OPENING CFOUTPUT =
---></FONT>=20
<BR> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)></FONT>=20
<BR> =20
<FONT size=3D2><CFSET =
PGSelected =3D=20
"Selected"></FONT> <BR> =
<FONT=20
size=3D2> <CFELSE></FONT> <BR><FONT=20
size=3D2> <CFSET PGSelected =
=3D=20
""></FONT> <BR> <FONT=20
size=3D2> </cfif></FONT>=20
<BR> <FONT =
size=3D2> =20
<Option #PGSelected# value=3D"#PG#">#PG#</option> =
<!---=20
NO</FONT> <BR><FONT size=3D2>CFOUTPUTS ---></FONT> <BR><FONT=20
size=3D2> =20
</cfoutput> <!--- CLOSING CFOUTPUT ---></FONT>=20
<BR> <FONT=20
size=3D2></cfselect></FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Gieseman, Athelene [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</=
FONT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 3:44 PM</FONT> =
<BR><FONT=20
size=3D2>To: '[EMAIL PROTECTED]'</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>Still no luck. I also added an rtrim function =
to each of=20
the fields in that</FONT> <BR><FONT size=3D2>line. And I've =
tried David's=20
suggestion of using listcontainsnocase. Still</FONT> <BR><FONT =
size=3D2>no=20
luck. I also changed the code this way:</FONT> </P>
<P><FONT size=3D2><CFIF=20
=
listfindnocase(rtrim(getpg.pg),rtrim(EditNameQry.PracticeGroup))></FON=
T>=20
<BR><FONT size=3D2><CFSET PGSelected =3D "Selected"></FONT> =
<BR><FONT=20
size=3D2><CFELSE></FONT> <BR><FONT size=3D2><CFSET PGSelected =
=3D "Not=20
Selected"></FONT> <BR><FONT size=3D2></cfif></FONT> <BR><FONT =
size=3D2><Option #PGSelected# =
value=3D"#PG#"><cfoutput>#PG#</FONT>=20
<BR><FONT size=3D2>#PGSelected#</cfoutput></option></FONT> =
</P>
<P><FONT size=3D2>so that I would be able to see if the PGSelected was =
being set=20
at all. When</FONT> <BR><FONT size=3D2>I use this code, the =
output on all=20
of the options has "Not Selected" after</FONT> <BR><FONT =
size=3D2>it. So I=20
believe the problem is that the listcontains never finds a =
match.</FONT>=20
<BR><FONT size=3D2>I've changed the database from a char to a varchar =
(based on=20
earlier posts</FONT> <BR><FONT size=3D2>about that issue), edited all =
of the=20
records in the file to eliminate any</FONT> <BR><FONT size=3D2>extra =
spaces at=20
the end, used the rtrim function. And still it's not ever</FONT> =
<BR><FONT size=3D2>finding a match.</FONT> </P>
<P><FONT size=3D2>I appreciate the continuing help! This one is =
making me=20
crazy (well, more</FONT> <BR><FONT size=3D2>crazy than usual.)</FONT> =
</P>
<P><FONT size=3D2>Athelene</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: Mark=20
Armendariz [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FO=
NT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 1:34 PM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>Try replacing the cfloop with cfoutput like =
so:</FONT>=20
</P><BR>
<P><FONT size=3D2><cfquery datasource=3D"FirmDirectory"=20
name=3D"EditNameQry"></FONT> <BR><FONT size=3D2> =20
Select *</FONT> <BR><FONT=20
size=3D2> FROM Employees</FONT> <BR><FONT size=3D2> =
WHERE=20
ID=3D'#EditGrid.ID#'</FONT> <BR><FONT size=3D2></cfquery></FONT> =
</P>
<P><FONT size=3D2><cfquery datasource=3D"FirmDirectory" =
name=3D"GetPG"></FONT>=20
<BR><FONT size=3D2> =
Select =20
*</FONT> <BR><FONT size=3D2> FROM PracticeGroups</FONT> =
<BR><FONT=20
size=3D2> ORDER BY PG</FONT> =
<BR><FONT=20
size=3D2></cfquery></FONT> </P>
<P><FONT size=3D2> <cfselect=20
name=3D"NewPG" size=3D"3" multiple></FONT>=20
<BR> <FONT size=3D2> =20
<CFOutput query=3D"GetPG"></FONT>=20
<BR> <FONT =
size=3D2> =20
<CFIF ListContains(GetPG.PG,EditNameQry.PracticeGroup)></FONT>=20
<BR> =20
<FONT size=3D2><CFSET =
PGSelected =3D=20
"Selected"></FONT> <BR> =
<FONT=20
size=3D2> <CFELSE></FONT> <BR><FONT=20
size=3D2> <CFSET PGSelected =
=3D=20
""></FONT> <BR> <FONT=20
size=3D2> </cfif></FONT>=20
<BR> <FONT =
size=3D2> =20
<Option #PGSelected# value=3D"#PG#">#PG#</option></FONT> =
<BR><FONT=20
size=3D2> =20
</cfoutput></FONT> =
<BR> <FONT=20
size=3D2></cfselect></FONT> </P>
<P><FONT size=3D2>I had the CFLoop in there because i had cfoutputs =
around it in=20
my code...</FONT> <BR><FONT size=3D2>this should do it for you, if =
not, let me=20
know...</FONT> </P><BR><BR><BR>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Gieseman, Athelene [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</=
FONT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 1:03 PM</FONT> =
<BR><FONT=20
size=3D2>To: '[EMAIL PROTECTED]'</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>OK. I have another application where I do in =
fact use a=20
table for the</FONT> <BR><FONT size=3D2>lookup. I've tried to =
use your=20
example and apply it here. But nothing is</FONT> <BR><FONT=20
size=3D2>selected. My code is as follows:</FONT> </P>
<P><FONT size=3D2><cfquery datasource=3D"FirmDirectory"=20
name=3D"EditNameQry"></FONT> <BR><FONT size=3D2>Select * from =
Employees where=20
ID=3D'#EditGrid.ID#'</FONT> <BR><FONT size=3D2></cfquery></FONT> =
</P>
<P><FONT size=3D2><cfquery datasource=3D"FirmDirectory" =
name=3D"GetPG"></FONT>=20
<BR><FONT size=3D2>Select * from PracticeGroups order by PG</FONT> =
<BR><FONT=20
size=3D2></cfquery></FONT> </P>
<P><FONT size=3D2> <cfselect=20
name=3D"NewPG" size=3D"3" multiple></FONT>=20
<BR> =20
=20
<FONT size=3D2><CFLoop=20
query=3D"GetPG"></FONT> =
<BR> =20
=20
<FONT =
size=3D2><CFIF</FONT>=20
<BR><FONT =
size=3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)></FONT>=20
<BR> =20
=20
<FONT size=3D2><CFSET =
PGSelected =3D=20
"Selected"></FONT> <BR> =20
=20
<FONT =
size=3D2><CFELSE></FONT>=20
<BR><FONT size=3D2> =20
<CFSET PGSelected =3D=20
""></FONT> <BR> =20
=20
<FONT =
size=3D2></cfif></FONT>=20
<BR> =20
=20
<FONT size=3D2><Option=20
#PGSelected#</FONT> <BR><FONT=20
=
size=3D2>value=3D"#PG#"><cfoutput>#PG#</cfoutput></opti=
on></FONT>=20
<BR> =20
=20
<FONT =
size=3D2></cfloop></FONT>=20
<BR> =20
<FONT=20
size=3D2></cfselect></FONT> </P>
<P><FONT size=3D2>Note that if I replace the : <CFIF</FONT> =
<BR><FONT=20
size=3D2>ListContains(GetPG.PG,#EditNameQry.PracticeGroup#)></FONT> =
<BR><FONT=20
size=3D2>with: <CFIF =
ListContains(GetPG.PG,"Agribusiness")></FONT>=20
</P>
<P><FONT size=3D2>Then Agribusiness is in fact selected. So I'm =
assuming=20
there's something</FONT> <BR><FONT size=3D2>wrong with that one =
line. Do=20
you happen to see where I went wrong?</FONT> </P>
<P><FONT size=3D2>TIA,</FONT> </P>
<P><FONT size=3D2>Athelene</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From: Mark=20
Armendariz [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FO=
NT>=20
<BR><FONT size=3D2>Sent: Tuesday, August 08, 2000 7:44 AM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: RE:=20
Multiple value Select</FONT> </P><BR>
<P><FONT size=3D2>I did this sort of thing for an intranet i'm working =
on with=20
selected</FONT> <BR><FONT size=3D2>company newsgroups... The best way =
to do it=20
is with a database of your</FONT> <BR><FONT size=3D2>finance =
types. This=20
will allow you to updae the select statement without</FONT> <BR><FONT=20
size=3D2>changing the hard coding. So the form will always be =
right. =20
Query that</FONT> <BR><FONT size=3D2>database and the user =
database. In=20
the user database, you will want to save</FONT> <BR><FONT size=3D2>a =
comma=20
delimited list of the finance types they are assigned for. When=20
you</FONT> <BR><FONT size=3D2>bring up the select, you can scroll =
through all=20
the finance types, and if</FONT> <BR><FONT size=3D2>the user had any =
in his/her=20
list, they will set the FinanceSelected variable</FONT> <BR><FONT =
size=3D2>to=20
'selected.' if they're not in the list, FinanceSelected will be=20
blank.</FONT> </P>
<P><FONT size=3D2>Hope this helps...</FONT> </P>
<P><FONT size=3D2><CFQuery Name=3D"GetFinances"=20
datasource=3D"#Application.datasource#"></FONT> <BR><FONT =
size=3D2> =20
SELECT FinanceName</FONT> =
<BR><FONT=20
size=3D2> FROM tblFinances</FONT> <BR><FONT =
size=3D2> ORDER=20
By FinanceName</FONT> <BR><FONT=20
size=3D2></CFQuery></FONT> </P>
<P><FONT size=3D2><CFQuery Name=3D"GetCustomer"=20
datasource=3D"#Application.datasource#"></FONT> <BR><FONT =
size=3D2> =20
SELECT CustomerName,</FONT>=20
<BR> =20
<FONT =
size=3D2>Address,</FONT>=20
<BR> =20
<FONT=20
size=3D2>Finances <!--- =
This Field=20
is a comma delimited list</FONT> <BR><FONT size=3D2>of the =
user's</FONT>=20
<BR><FONT size=3D2>finances ---></FONT> <BR><FONT size=3D2> =
FROM =20
tblCustomers</FONT> <BR><FONT size=3D2> WHERE CustomerID =3D=20
#Attributes.CustomerID#</FONT> <BR><FONT =
size=3D2></cfgquery></FONT>=20
</P><BR>
<P><FONT size=3D2>Finances:<br></FONT> </P>
<P><FONT size=3D2><Select Name=3D"Finances" =
size=3D"#GetFinances.RecordCount#"=20
multiple></FONT> <BR><FONT size=3D2> <CFLoop=20
query=3D"Finances"></FONT> <BR><FONT size=3D2> =
<CFIF=20
ListContains(GetCustomer.Finances,#FinanceName#)></FONT> <BR><FONT=20
size=3D2> <CFSET FinanceSelected =3D=20
"Selected"></FONT> <BR><FONT size=3D2> =20
<CFELSE></FONT> <BR><FONT =
size=3D2> =20
<CFSET FinanceSelected =3D ""></FONT> <BR><FONT =
size=3D2> =20
</cfif></FONT> <BR><FONT size=3D2> <Option=20
#FiannceSelected# =
value=3D"#FinanceName#">#FinanceName#</option></FONT>=20
<BR><FONT size=3D2> </cfloop></FONT> <BR><FONT=20
size=3D2></select></FONT> </P><BR><BR>
<P><FONT size=3D2>Mark Armendariz</FONT> <BR><FONT size=3D2>Righteous=20
Design</FONT> <BR><FONT size=3D2>www.sorighteous.com</FONT> <BR><FONT=20
size=3D2>[EMAIL PROTECTED]</FONT> </P><BR>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Gieseman, Athelene [<A=20
=
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</=
FONT>=20
<BR><FONT size=3D2>Sent: Monday, August 07, 2000 6:34 PM</FONT> =
<BR><FONT=20
size=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>Subject: Multiple=20
value Select</FONT> </P><BR>
<P><FONT size=3D2>I'm trying to set up a CFSELECT using the SELECTED=20
option. I need to have</FONT> <BR><FONT size=3D2>the CFSELECT =
set up as=20
multiple since more than one option is permitted.</FONT> <BR><FONT=20
size=3D2>However, I can never seem to get the SELECTED option to =
properly=20
highlight</FONT> <BR><FONT size=3D2>the options that are already =
stored in the=20
record. (In other words, I want</FONT> <BR><FONT size=3D2>to =
create an=20
edit screen where the previously stored values are preselected</FONT>=20
<BR><FONT size=3D2>in this control.) Any thoughts on what I may =
be doing=20
wrong? The code for</FONT> <BR><FONT size=3D2>my select =
follows: =20
(Note that ViewGrid is a grid from which the user</FONT> <BR><FONT=20
size=3D2>previously selected this record. I've also tried doing =
this from=20
a query</FONT> <BR><FONT size=3D2>with the same result - nothing is=20
selected.)</FONT> </P>
<P><FONT size=3D2><cfselect name=3D"FinanceType" size=3D"2"=20
selected=3D"#ViewGrid.FinanceType#"</FONT> <BR><FONT =
size=3D2>multiple></FONT>=20
<BR><FONT size=3D2><option value=3D"Single Family =
Housing">Single Family=20
Housing</option></FONT> <BR><FONT size=3D2><option=20
value=3D"501(c)(3)">501(c)(3)</option></FONT> <BR><FONT=20
size=3D2><option value=3D"Hospital Revenue">Hospital=20
Revenue</option></FONT> <BR><FONT size=3D2><option =
value=3D"Leasehold=20
Revenue">Leasehold Revenue</option></FONT> <BR><FONT=20
size=3D2><option value=3D"Multifamily Housing">Multifamily=20
Housing</option></FONT> <BR><FONT size=3D2><option =
value=3D"General=20
Obligation">General Obligation</option></FONT> <BR><FONT=20
size=3D2><option value=3D"NID">NID</option></FONT> =
<BR><FONT=20
size=3D2><option value=3D"Special Obligation">Special=20
Obligation</option></FONT> <BR><FONT size=3D2><option =
value=3D"Industrial=20
Development">Industrial Development</option></FONT> <BR><FONT =
size=3D2><option value=3D"TIF">TIF</option></FONT> =
<BR><FONT=20
size=3D2><option value=3D"TDD/TC">TDD/TC</option></FONT> =
<BR><FONT=20
size=3D2><option value=3D"Other">Other</option></FONT> =
<BR><FONT=20
size=3D2></cfselect></FONT> <BR><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> </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>--</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> </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>--</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> </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>--</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> </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>--</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_00EF_01C001FF.3F8198C0--
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
