I understand I was just teasing. But you got it to work this time. Perhaps
because my message was in plain text. The list is set to filter out
attachments, which is how HTML mail is sent, and therefore puts them in the
body as text. Makes for some pretty ugly messages but hey it saves us from
infection.
--K
-----Original Message-----
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 10:25 AM
To: [EMAIL PROTECTED]
Subject: Re: Multiple value Select
I am using Outlook Express, and have it set up to reply to messages in their
original format, which in this case is HTML, or to compose new messages in
plain text. For some reason the list is not properly handling the mime
conversion. To see if perhaps this is fixed, I have changed it to send in
plain text only, regardless of the format of the incoming message. It has
been annoying to me, because other messages besides mine have been turned to
mush.
DC
----- Original Message -----
From: "Chapman, Katrina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 17:03
Subject: RE: Multiple value Select
> The 3D shouldn't be there. It's because a very bad David;) is sending
> messages in HTML format, or some format other than plain text. Just
> remove
> any 3D's you may have copied and it should work.
>
> --K
>
> -----Original Message-----
> From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 09, 2000 8:50 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Multiple value Select
>
>
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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_t
> a=
> 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>]</F
> O=
> 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>]</F
> O=
> 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))></FO
> N=
> 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>]</F
> O=
> 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>=2
> 0
> <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></opt
> i=
> 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>]</F
> O=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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&a
> m=
> 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.
> ------------------------------------------------------------------------
> ------
> 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.
------------------------------------------------------------------------------
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.
