File name not showing up in application.log
There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or processed is: Why is the file name blank and what's the best way to go about troubleshooting this error? This probably has to do with an error withing a CFTHREAD function, but I can't be 100% sure of that... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Empty file name in Application.log
There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or processed is: Why is the file name blank and what's the best way to go about troubleshooting this error? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Compare Two Lists
Hi all, Attempting to clean up a table with email records. In addition to the existing table of good and bad email addresses, I have a csv file with addresses that would need to be matched up to the db table, then deleted (so I just have good addresses). Email addresses are properly formatted in both the db and in the csv, so I won't have to deal with duplicate addresses or hang ups because of improper formatting. The db table has about 10,000 records. The csv file has about 4,000 addresses that will need to be matched and then dropped from the db table. Each recordset only has email addresses, so we're only dealing with one column. I've been working with the following, but I'm not sure this is the best way to go about it, or if it will function properly. And, I'm not sure that the ListGetAt or the delete WHERE clause will work. Conceptually for some reason I have a mental block about arrays. Thanks for your advise. Mark !--- Get the existing db email addresses --- cfquery name=getTableAddresses datasource=#dsnSQL# username=#dsnUID# password=#dsnPWD# SELECT emailaddress FROM someDBTable ORDER BY emailaddress asc /cfquery !--- Get the addresses which are bad from the csv file --- cfhttp name=cleanedAddressestoDelete method=get url=http://www.somesite.com/file.csv; / cfset oldList = ValueList(getTableAddresses.emailaddress) cfset todelete = ValueList(cleanedAddressestoDelete.emailaddress) cfloop From=1 To=#ListLen(oldList)# index=emailaddress cfif ListGetAt(oldList, emailaddress) EQ ListGetAt(todelete,emailaddress) cfquery name=deleteAddress datasource=#dsnSQL# username=#dsnUID# password=#dsnPWD# DELETE FROM someDBTable WHERE emailaddress = #todelete.emailaddress# /cfquery /cfif /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Caching
Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. Thanks, Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Caching
On Wed, Jul 17, 2013 at 10:08 AM, Steve LaBadie wrote: Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. We are up to version 10 of the server now, so no there is nothing about CF specifically that is an inherent problem here. If the homepage isn't resolving correctly that sounds on the surface like a DNS issue, but perhaps you were using poorly chosen vocabulary to describe the problem? If you are also to give more detail about the exact error and/or behavior you are seeing perhaps someone an help you. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Steve, Are you using page caching? Cfcache? More info would be helpful. -Original Message- From: Steve LaBadie [mailto:slaba...@po-box.esu.edu] Sent: Wednesday, July 17, 2013 9:08 AM To: cf-talk Subject: Caching Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. Thanks, Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Compare Two Lists
Mark,
Perhaps I'm missing something... but it seems like you already have your
list to delete. Why are you comparing again? Why not just do:
DELETE FROM someDBTable
WHERE emailaddress IN ('# todelete#')
Using cfqueryparam of course :)
Is the list too large? Sometimes the driver will only handle n number of
items in a list - something like 16k I think.
-Mark
-Original Message-
From: i...@markleder.com i...@markleder.com [mailto:i...@markleder.com]
Sent: Wednesday, July 17, 2013 9:02 AM
To: cf-talk
Subject: Compare Two Lists
Hi all,
Attempting to clean up a table with email records. In addition to the
existing table of good and bad email addresses, I have a csv file with
addresses that would need to be matched up to the db table, then deleted (so
I just have good addresses).
Email addresses are properly formatted in both the db and in the csv, so I
won't have to deal with duplicate addresses or hang ups because of improper
formatting. The db table has about 10,000 records. The csv file has about
4,000 addresses that will need to be matched and then dropped from the db
table. Each recordset only has email addresses, so we're only dealing with
one column.
I've been working with the following, but I'm not sure this is the best way
to go about it, or if it will function properly. And, I'm not sure that the
ListGetAt or the delete WHERE clause will work. Conceptually for some
reason I have a mental block about arrays.
Thanks for your advise. Mark
!--- Get the existing db email addresses ---
cfquery name=getTableAddresses datasource=#dsnSQL# username=#dsnUID#
password=#dsnPWD#
SELECT emailaddress
FROM someDBTable
ORDER BY emailaddress asc
/cfquery
!--- Get the addresses which are bad from the csv file ---
cfhttp
name=cleanedAddressestoDelete
method=get
url=http://www.somesite.com/file.csv;
/
cfset oldList = ValueList(getTableAddresses.emailaddress)
cfset todelete = ValueList(cleanedAddressestoDelete.emailaddress)
cfloop From=1 To=#ListLen(oldList)# index=emailaddress
cfif ListGetAt(oldList, emailaddress) EQ
ListGetAt(todelete,emailaddress)
cfquery name=deleteAddress datasource=#dsnSQL# username=#dsnUID#
password=#dsnPWD#
DELETE FROM someDBTable
WHERE emailaddress = #todelete.emailaddress#
/cfquery
/cfif
/cfloop
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356203
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Cameron, When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:15 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:08 AM, Steve LaBadie wrote: Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. We are up to version 10 of the server now, so no there is nothing about CF specifically that is an inherent problem here. If the homepage isn't resolving correctly that sounds on the surface like a DNS issue, but perhaps you were using poorly chosen vocabulary to describe the problem? If you are also to give more detail about the exact error and/or behavior you are seeing perhaps someone an help you. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Caching
This actually sounds like perhaps the CSS file is being cached. Hitting F5 may be making the browsers reload all the page's included files, including the CSS file. Have you made changes to CSS/JS files lately? One strategy to avoid this is to rename your CSS file when you change it. If it's referenced in a global location like a header include, it's quite simple to change the filename there before you deploy. -Cameron On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: Cameron, When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:15 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:08 AM, Steve LaBadie wrote: Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. We are up to version 10 of the server now, so no there is nothing about CF specifically that is an inherent problem here. If the homepage isn't resolving correctly that sounds on the surface like a DNS issue, but perhaps you were using poorly chosen vocabulary to describe the problem? If you are also to give more detail about the exact error and/or behavior you are seeing perhaps someone an help you. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Steve, I agree with Cameron sounds like a resource is not loading... css, js or image or whatever. Firebug would tell the story probably. -mark -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 9:32 AM To: cf-talk Subject: Re: Caching This actually sounds like perhaps the CSS file is being cached. Hitting F5 may be making the browsers reload all the page's included files, including the CSS file. Have you made changes to CSS/JS files lately? One strategy to avoid this is to rename your CSS file when you change it. If it's referenced in a global location like a header include, it's quite simple to change the filename there before you deploy. -Cameron On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: Cameron, When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:15 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:08 AM, Steve LaBadie wrote: Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. We are up to version 10 of the server now, so no there is nothing about CF specifically that is an inherent problem here. If the homepage isn't resolving correctly that sounds on the surface like a DNS issue, but perhaps you were using poorly chosen vocabulary to describe the problem? If you are also to give more detail about the exact error and/or behavior you are seeing perhaps someone an help you. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Caching
On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many universities tend to have Big Brother Overlord types of content filters in place. If your university has such a filtering device, it may be cacheing an old copy of the CSS file somehow. This problem would manifest itself as being only an inside the network problem. In any case, changing the CSS file's name should resolve this too. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Thank you both for responding. I will give it a try. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:38 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many universities tend to have Big Brother Overlord types of content filters in place. If your university has such a filtering device, it may be cacheing an old copy of the CSS file somehow. This problem would manifest itself as being only an inside the network problem. In any case, changing the CSS file's name should resolve this too. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Mark, Maximum number of cached templates 1024 Trusted cache not checked Save class fileschecked Cache web server paths checked Maximum number of cached queries100 Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Mark A Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, July 17, 2013 10:20 AM To: cf-talk Subject: RE: Caching Steve, Are you using page caching? Cfcache? More info would be helpful. -Original Message- From: Steve LaBadie [mailto:slaba...@po-box.esu.edu] Sent: Wednesday, July 17, 2013 9:08 AM To: cf-talk Subject: Caching Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening in the future as we make more dramatic changes to the website. Thanks, Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
You can also set the caching abd ecpiry meta rags and hears on your pages to force reload. Be careful noy to completely disable browser caching tho or it Will slow down your site. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 17 Jul 2013 15:41, Steve LaBadie slaba...@po-box.esu.edu wrote: Thank you both for responding. I will give it a try. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:38 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many universities tend to have Big Brother Overlord types of content filters in place. If your university has such a filtering device, it may be cacheing an old copy of the CSS file somehow. This problem would manifest itself as being only an inside the network problem. In any case, changing the CSS file's name should resolve this too. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Compare Two Lists
Sure seems like I make things more complicated than they need to be. If the simple delete statement as you show will drop out the 4000 records without looping, then great! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Empty file name in Application.log
The problem has been identified: someone or something has been hitting a blank .cfm template on my site: http://www.someurl.com/..cfm There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or processed is: Why is the file name blank and what's the best way to go about troubleshooting this error? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Regex question
On Wed, Jul 17, 2013 at 11:15 AM, Matthew Allen wrote: Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. I'll let someone else help with regex, but my comment from the peanut gallery: This smells like something you may be able to easily do using jQuery and let the client side manage this. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex question
I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Compare Two Lists
Not exactly It should look like this mark DELETE FROM someDBTable WHERE emailaddress IN (cfqueryparam cfsqltype=CF_SQL_CHAR value=#todelete# list=yes/) I left off the syntax for expediency :) Be sure this is what you want to do! -Original Message- From: i...@markleder.com i...@markleder.com [mailto:i...@markleder.com] Sent: Wednesday, July 17, 2013 10:08 AM To: cf-talk Subject: Re: Compare Two Lists Sure seems like I make things more complicated than they need to be. If the simple delete statement as you show will drop out the 4000 records without looping, then great! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Tag replacement
Hello all, I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Tag replacement
Here's one way to do this using adaptive tags. http://www.coldfusionmuse.com/index.cfm/2006/5/10/adaptive.tags Note.. I whipped this up and it may need debugging. First create a sub folder - call it whatever... let's say /adtags Next create a cfm file within the folder called reference.cfm - the name of the file MUST be reference.cfm. Inside this file place this (as yet untested) snippet of code: !---MAK: make sure we are using cfoutput to granularly control output.--- cfsetting enablecfoutputonly=Yes cfif thistag.executionmode IS 'Start' !--- begin the tag --- cfoutputsup/cfoutput !---MAK: find the ID and output it--- Cfloop collection=#attributes# item=aItem cfif aItem IS 'id'cfoutput#attributes[aItem]#/cfoutput/cfif /CFLOOP !---MAK: end the tag--- cfif thistag.executionmode IS 'End' cfoutput/sup/cfoutput /cfif cfsetting enablecfoutputonly=no Finally at the top of the page where you want this behavior add this command. cfimport taglib=adtags prefix=/ (remember adtags is the name of your subfolder). The result is that CF will see any HTML tag called reference... as a non-prefixed call to the custom tag reference. While this approach is fun and clever you may want to think twice about it ;) Still... it IS a solution. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.932.3318 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: a.matthew14 [mailto:a.matthe...@yahoo.com] Sent: Wednesday, July 17, 2013 11:11 AM To: cf-talk Subject: Tag replacement Hello all, I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Tag replacement
Thanks Mark, will give it a go. Matt. Original message From: Mark A Kruger mkru...@cfwebtools.com Date: 17/07/2013 17:37 (GMT+00:00) To: cf-talk cf-talk@houseoffusion.com Subject: RE: Tag replacement Here's one way to do this using adaptive tags. http://www.coldfusionmuse.com/index.cfm/2006/5/10/adaptive.tags Note.. I whipped this up and it may need debugging. First create a sub folder - call it whatever... let's say /adtags Next create a cfm file within the folder called reference.cfm - the name of the file MUST be reference.cfm. Inside this file place this (as yet untested) snippet of code: !---MAK: make sure we are using cfoutput to granularly control output.--- cfsetting enablecfoutputonly=Yes cfif thistag.executionmode IS 'Start' !--- begin the tag --- cfoutputsup/cfoutput !---MAK: find the ID and output it--- Cfloop collection=#attributes# item=aItem cfif aItem IS 'id'cfoutput#attributes[aItem]#/cfoutput/cfif /CFLOOP !---MAK: end the tag--- cfif thistag.executionmode IS 'End' cfoutput/sup/cfoutput /cfif cfsetting enablecfoutputonly=no Finally at the top of the page where you want this behavior add this command. cfimport taglib=adtags prefix=/ (remember adtags is the name of your subfolder). The result is that CF will see any HTML tag called reference... as a non-prefixed call to the custom tag reference. While this approach is fun and clever you may want to think twice about it ;) Still... it IS a solution. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.932.3318 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: a.matthew14 [mailto:a.matthe...@yahoo.com] Sent: Wednesday, July 17, 2013 11:11 AM To: cf-talk Subject: Tag replacement Hello all, I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Tag replacement
You could also simply use a regular expression to do the replace. cfset *testString* = 'reference-link id=2 type=reference/' / cfset *newstring* = *rereplace*(*testString*,'reference-link id=(\w) type=reference/',sup\1/sup) / The newstring variable would now be sup2/sup Dean On Wed, Jul 17, 2013 at 12:43 PM, a.matthew14 a.matthe...@yahoo.com wrote: Thanks Mark, will give it a go. Matt. Original message From: Mark A Kruger mkru...@cfwebtools.com Date: 17/07/2013 17:37 (GMT+00:00) To: cf-talk cf-talk@houseoffusion.com Subject: RE: Tag replacement Here's one way to do this using adaptive tags. http://www.coldfusionmuse.com/index.cfm/2006/5/10/adaptive.tags Note.. I whipped this up and it may need debugging. First create a sub folder - call it whatever... let's say /adtags Next create a cfm file within the folder called reference.cfm - the name of the file MUST be reference.cfm. Inside this file place this (as yet untested) snippet of code: !---MAK: make sure we are using cfoutput to granularly control output.--- cfsetting enablecfoutputonly=Yes cfif thistag.executionmode IS 'Start' !--- begin the tag --- cfoutputsup/cfoutput !---MAK: find the ID and output it--- Cfloop collection=#attributes# item=aItem cfif aItem IS 'id'cfoutput#attributes[aItem]#/cfoutput/cfif /CFLOOP !---MAK: end the tag--- cfif thistag.executionmode IS 'End' cfoutput/sup/cfoutput /cfif cfsetting enablecfoutputonly=no Finally at the top of the page where you want this behavior add this command. cfimport taglib=adtags prefix=/ (remember adtags is the name of your subfolder). The result is that CF will see any HTML tag called reference... as a non-prefixed call to the custom tag reference. While this approach is fun and clever you may want to think twice about it ;) Still... it IS a solution. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.932.3318 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: a.matthew14 [mailto:a.matthe...@yahoo.com] Sent: Wednesday, July 17, 2013 11:11 AM To: cf-talk Subject: Tag replacement Hello all, I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a superscript tag with the value. Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Tag replacement
Your message is a reply to anothers post and is more than 100 lines of text. If possible, please trim your posts when replying. Thank you. This is just a friendly reminder and your message has not been blocked or altered in any way. You could also simply use a regular expression to do the replace. cfset *testString* = 'reference-link id=2 type=reference/' / cfset *newstring* = *rereplace*(*testString*,'reference-link id=(\w) type=reference/',sup\1/sup) / The newstring variable would now be sup2/sup Dean --- Dean M. Lawrence INTERNET DATA TECHNOLOGY p // 888.438.4381 ext. 701 w // www.idatatech.com f // www.facebook.com/idatatech t // www.twitter.com/idatatech Social Marketing | SEO | Design | Internet Development ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Caching
Russ, I had added META HTTP-EQUIV=Pragma CONTENT=no-cache before posting this thread with no luck. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, July 17, 2013 11:06 AM To: cf-talk Subject: RE: Caching You can also set the caching abd ecpiry meta rags and hears on your pages to force reload. Be careful noy to completely disable browser caching tho or it Will slow down your site. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 17 Jul 2013 15:41, Steve LaBadie slaba...@po-box.esu.edu wrote: Thank you both for responding. I will give it a try. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:38 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many universities tend to have Big Brother Overlord types of content filters in place. If your university has such a filtering device, it may be cacheing an old copy of the CSS file somehow. This problem would manifest itself as being only an inside the network problem. In any case, changing the CSS file's name should resolve this too. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Caching
that by itself may not work, you need to add content expiry headers as well. If you google the topic you will find several code examples. On Wed, Jul 17, 2013 at 6:15 PM, Steve LaBadie slaba...@po-box.esu.eduwrote: Russ, I had added META HTTP-EQUIV=Pragma CONTENT=no-cache before posting this thread with no luck. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, July 17, 2013 11:06 AM To: cf-talk Subject: RE: Caching You can also set the caching abd ecpiry meta rags and hears on your pages to force reload. Be careful noy to completely disable browser caching tho or it Will slow down your site. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 17 Jul 2013 15:41, Steve LaBadie slaba...@po-box.esu.edu wrote: Thank you both for responding. I will give it a try. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:38 AM To: cf-talk Subject: Re: Caching On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many universities tend to have Big Brother Overlord types of content filters in place. If your university has such a filtering device, it may be cacheing an old copy of the CSS file somehow. This problem would manifest itself as being only an inside the network problem. In any case, changing the CSS file's name should resolve this too. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Compare Two Lists
FWIW: I have 4000 records to delete, with CF 9, throws an error: [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. I can break up the routines into three sets to make it work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Compare Two Lists
Depending on where this CSV file is coming from, I'd just not use cfqueryparam. The only real reason to use it in a case like this is to make sure nobody's SQL injecting you. If this is an automated process and you think maybe one day you might not be able to trust the inputs form the CVS file, then you need to still worry. But it's it's just a one time thing, just use the good ole SQL syntax: WHERE emailAddress in (#todelete#) I'd stick to SQL too - comparing lists of this length in CF is going to be a really crappy slow experience. -Cameron On Wed, Jul 17, 2013 at 3:00 PM, i...@markleder.com i...@markleder.com i...@markleder.com wrote: FWIW: I have 4000 records to delete, with CF 9, throws an error: [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. I can break up the routines into three sets to make it work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Compare Two Lists
What database platform are you on? I'd import those email addresses in the CSV to a temporary table and then just use a sub-select in the where clause. Let the database do the work... DELETE FROM someTable WHERE emailaddress in (SELECT email from tempImportTable) Also, if you are on SQL Server and this is a routine that you will need to do every so often, create a SSIS Package to run the import from CSV and clean up the the table. They are pretty easy to create and all you need to do is refresh the CSV file for it to run. --Jeff Original Message From: i...@markleder.com i...@markleder.com i...@markleder.com Sent: Wednesday, July 17, 2013 12:01 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Compare Two Lists FWIW: I have 4000 records to delete, with CF 9, throws an error: [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. I can break up the routines into three sets to make it work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Slow running request
We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. How should we go about finding out the cause of these slow running requests? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Slow running request
On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. You say that same query run at a different time, runs just fine and SQL db queries (as shown by F-R) are running very fast. So is any database query ever running slow? Fusion Reactor should show the query time for the slow running request vs the entire pagetime. What are those numbers? Is the DB taking most of the request time for this slow request or no? -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Slow running request
if you perform a stack trace on the slow requests while they are running this will tell you what it is doing at the time. On Wed, Jul 17, 2013 at 8:18 PM, Cameron Childress camer...@gmail.comwrote: On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. You say that same query run at a different time, runs just fine and SQL db queries (as shown by F-R) are running very fast. So is any database query ever running slow? Fusion Reactor should show the query time for the slow running request vs the entire pagetime. What are those numbers? Is the DB taking most of the request time for this slow request or no? -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Compare Two Lists
If you do it this way you need listQualify() cfset toDelete = listqualify(toDelete,)/ Then you will need to preservesinglequotes in the query as in... WHERE emailAddress IN (#preservesinglequotes(todelete)#) That's one of the reasons that I USE cfqueryparam - to keep me from having to write list code :) -Mark -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 2:10 PM To: cf-talk Subject: Re: Compare Two Lists Depending on where this CSV file is coming from, I'd just not use cfqueryparam. The only real reason to use it in a case like this is to make sure nobody's SQL injecting you. If this is an automated process and you think maybe one day you might not be able to trust the inputs form the CVS file, then you need to still worry. But it's it's just a one time thing, just use the good ole SQL syntax: WHERE emailAddress in (#todelete#) I'd stick to SQL too - comparing lists of this length in CF is going to be a really crappy slow experience. -Cameron On Wed, Jul 17, 2013 at 3:00 PM, i...@markleder.com i...@markleder.com i...@markleder.com wrote: FWIW: I have 4000 records to delete, with CF 9, throws an error: [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. I can break up the routines into three sets to make it work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Slow running request
Richard, You've only scratched the surface of what could be happening (ha). GC or other JVM related stuff could be happening... networking is also a good starting vector - assuming you are right about the SQL and I/O. For example, switches and NICs set to auto negotiate can sometimes exhibit this exact behavior if they are resynching for speed or duplex. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Richard Steele [mailto:r...@photoeye.com] Sent: Wednesday, July 17, 2013 2:12 PM To: cf-talk Subject: Slow running request We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. How should we go about finding out the cause of these slow running requests? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Compare Two Lists
On Wed, Jul 17, 2013 at 5:09 PM, Mark A Kruger wrote: That's one of the reasons that I USE cfqueryparam - to keep me from having to write list code :) Agreed. It's rare that I recommend against cfqueryparam, but in this case I think it might be easier. -Cameron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
