Re: removing chr(10), chr(13), chr(9), chr(12)
You might want to replace runs of consecutive unacceptable whitespace characters with a single space. Otherwise, two sentences that used to have CRs and/or LFs between them will be jammed against each other, with no space at all between them. Dave On Mon, Aug 23, 2010 at 12:10 AM, Matthew Smith chedders...@gmail.com wrote: That got it. Thank you so much. On Sun, Aug 22, 2010 at 9:12 PM, Wil Genovese jugg...@trunkful.com wrote: This is what I use to remove all control characters from a string. Which includes linefeed chr(10) and carriage return chr(13). REReplaceNoCase(string,'([[:cntrl:]])','','All') Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting wilg...@trunkful.com www.trunkful.com On Aug 22, 2010, at 8:58 PM, Justin Scott wrote: Thank you for the help. It seems I am still missing the line feed somehow. In the replaceList() put a comma between char 13 and 10 so it will catch them individually instead of only when they're together (and add another comma to the second attribute as well). Sometimes text will only have a line break (10) without the carriage return (13). -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrading to Coldfusion 8
List, Can I install Coldfusion 9 multi-server on a server already running Coldfusion 8 multi-server? I'd like to get it installed, get all the instances set up and configured BEFORE taking the site down reconfigure the web server connections... but I'm not sure if this is possible. I have googled and found instructions for installing both, but it requires installing the new version FIRST (CF9) and then installing CF8 in J2EE mode, and that doesn't really work for this kind of upgrade Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Upgrading to Coldfusion 8
Rick, I've not done this for multi-server but I just did it for stand-alone so I suspect it's possible. In installed using the internal web server so I could configure the server using car files and manual settings. So I had both of them running. Then I changed the JVM file for CF9 to the prod settings, removed the apache connectors for cf 8 and installed the ones for CF 9. That worked well. With multiserver I suspect you will have to be careful with the ports and port conflicts - and I would sort of hesitate to do this on a live server without a test bed to proof the procedure. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Monday, August 23, 2010 8:46 AM To: cf-talk Subject: Upgrading to Coldfusion 8 List, Can I install Coldfusion 9 multi-server on a server already running Coldfusion 8 multi-server? I'd like to get it installed, get all the instances set up and configured BEFORE taking the site down reconfigure the web server connections... but I'm not sure if this is possible. I have googled and found instructions for installing both, but it requires installing the new version FIRST (CF9) and then installing CF8 in J2EE mode, and that doesn't really work for this kind of upgrade Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading to Coldfusion 8
It's fairly easy to do. * Choose multi-server EAR/WAR during the CF install. Choose the EAR specifically. * Create a new folder in jrunhome/servers/yournamefolder. * Expand the EAR/WAR into folders. Use the CF8 folders as an example. cfusion-ear will have a cfusion-war folder and a META-INF folder. cfusion-war will have CFIDE and WEB-INF. There also appears to be a crossdomain.xml in my cfusion-war folder for CF9. * COPY the application.xml from the working CF8 cfusion-ear/cfusion-war/META-INF folder into the new folder cfusion-ear/cfusion-war/META-INF. The application.xml created by the install will NOT work with JRun. Go figure. * Load up the JRun admin at port 8000. I have this service set to manual, but it may already be on. The username is admin, password is the password from when you first installed CF8. It can be found (unencrypted) in jrunhome/servers/admin/SERVER-INF/jrun-users.xml. * You should see a link to create a new instance. Go for it. * Name the instance the yourfoldername. It will automagically pic up the EAR/WAR you exploded into that folder * Create a service for it with jrunhome/bin/jrunsvc -install yourfoldername yourfoldername Macromedia JRun whatever Macromedia JRun whatever * profit Now, I'm not sure you're going to get SOLR along with this, but I'm fairly sure you can find that separate somewhere in the install folders. Some optional steps include downloading an updated JRE. You could also create a separate jvm.config and specify that during jrunsvc -install. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dump to Excel from CF 5
Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
On Mon, Aug 23, 2010 at 11:46 AM, Eric J. Ehlers ericjehl...@gmail.comwrote: Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. Read up on cffile. I don't have cf5 to test against but I think creating a string and writing it to a cffile should work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
http://cflib.org/udf/Query2Excel On Mon, Aug 23, 2010 at 10:46 AM, Eric J. Ehlers ericjehl...@gmail.comwrote: Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dump to Excel from CF 5
Can you post what you have tried with cfcontent and cfheader? Also, keep in mind if you are doing this in IE it will cache the first mime type - so you can't do it once as HTML To test and then again as XLS ... it will end up showing as html again. Test in FF. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Eric J. Ehlers [mailto:ericjehl...@gmail.com] Sent: Monday, August 23, 2010 10:47 AM To: cf-talk Subject: Dump to Excel from CF 5 Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: IT job vacancies up in first quarter
In case you missed my tweet... At the same time, demand for specific skills, notably Sybase, C#, Coldfusion, .NET, SQL and Swing also increased over at least three consecutive quarters. http://www.managementconsultancy.co.uk/computing/news/2268566/number-advertised-vacancies-ict -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
It's been a while since I've used IE much but I *think* if you refresh using CTRL+R it refreshes and clears cache for that page. On Mon, Aug 23, 2010 at 12:13 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Can you post what you have tried with cfcontent and cfheader? Also, keep in mind if you are doing this in IE it will cache the first mime type - so you can't do it once as HTML To test and then again as XLS ... it will end up showing as html again. Test in FF. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Eric J. Ehlers [mailto:ericjehl...@gmail.com] Sent: Monday, August 23, 2010 10:47 AM To: cf-talk Subject: Dump to Excel from CF 5 Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Dump to Excel from CF 5
Michael, Cool... I did not know that trick - I though CTR-F5 was supposed to do that - but it never worked for the mime type. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Monday, August 23, 2010 11:26 AM To: cf-talk Subject: Re: Dump to Excel from CF 5 It's been a while since I've used IE much but I *think* if you refresh using CTRL+R it refreshes and clears cache for that page. On Mon, Aug 23, 2010 at 12:13 PM, Mark A. Kruger mkru...@cfwebtools.comwrote: Can you post what you have tried with cfcontent and cfheader? Also, keep in mind if you are doing this in IE it will cache the first mime type - so you can't do it once as HTML To test and then again as XLS ... it will end up showing as html again. Test in FF. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Eric J. Ehlers [mailto:ericjehl...@gmail.com] Sent: Monday, August 23, 2010 10:47 AM To: cf-talk Subject: Dump to Excel from CF 5 Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
Assuming you are outputing HTML tables for your excel file, just use this code: cfheader name=Content-Disposition value=attachment; filename=somefile.xls cfcontent type=application/msexcel reset=true !--- now output HTML tables --- Or, if your code outputs the HTML document to a file, just add the file= attribute to cfcontent Remember, in the cfheader tag, the filename part of the value simply tells the browser what to name the file by default, it has nothing to do with the actual filename of anything (though if you leave it out, the browser will call it yourtemplate.cfm instead of somefile.xls and that's never good) This should work for CF5 just fine. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Grabbing Keywords from Referers
I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Grabbing Keywords from Referers
This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop On Mon, Aug 23, 2010 at 11:52 AM, Che Vilnonis ch...@asitv.com wrote: I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:00 PM To: cf-talk Subject: Re: Grabbing Keywords from Referers This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop On Mon, Aug 23, 2010 at 11:52 AM, Che Vilnonis ch...@asitv.com wrote: I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx: Grabbing Keywords from Referers
I wonder if the regex gurus have a solution as well. Oh, I'm sure. :-) On Mon, Aug 23, 2010 at 12:54 PM, Che Vilnonis ch...@asitv.com wrote: Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:00 PM To: cf-talk Subject: Re: Grabbing Keywords from Referers This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop On Mon, Aug 23, 2010 at 11:52 AM, Che Vilnonis ch...@asitv.com wrote: I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
This regex would search through a string and return all occurences of q=followed by any character that's NOT an . q=[^]+ Given this string: http://www.google.com/search?source=ighl=enrlz=q=coldfusionaq=faqi=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It matches q=coldfusion q=f Not sure where the second q= came from. I just did a search on the Google homepage for ColdFusion. andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 12:54 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:00 PM To: cf-talk Subject: Re: Grabbing Keywords from Referers This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx: Grabbing Keywords from Referers
Not sure where the second q= came from. From this: aq=f On Mon, Aug 23, 2010 at 1:44 PM, Andy Matthews li...@commadelimited.comwrote: This regex would search through a string and return all occurences of q=followed by any character that's NOT an . q=[^]+ Given this string: http://www.google.com/search?source=ighl=enrlz=q=coldfusionaq=faqi=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It matches q=coldfusion q=f Not sure where the second q= came from. I just did a search on the Google homepage for ColdFusion. andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 12:54 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:00 PM To: cf-talk Subject: Re: Grabbing Keywords from Referers This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Ah. The text was so small in my testing app that I couldn't tell what that was. Try this instead: [?|]q=[^]+ That only looks for q= when immediately following a ? or an . Given the same string: http://www.google.com/search?q=coldfusionsource=ighl=enrlz=aq=faqi=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It only matches ?q=coldfusion or q=coldfusion -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:48 PM To: cf-talk Subject: Re: RegEx: Grabbing Keywords from Referers Not sure where the second q= came from. From this: aq=f On Mon, Aug 23, 2010 at 1:44 PM, Andy Matthews li...@commadelimited.comwrote: This regex would search through a string and return all occurences of q=followed by any character that's NOT an . q=[^]+ Given this string: http://www.google.com/search?source=ighl=enrlz=q=coldfusionaq=faq i=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It matches q=coldfusion q=f Not sure where the second q= came from. I just did a search on the Google homepage for ColdFusion. andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 12:54 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
Eric, Here is what I used with CF5 and it worked well for me. cfheader name=Content-Disposition value=inline; filename=filename.xls cfheader name=Expires value=#Now()# cfcontent type=application/vnd.ms-excel This forced the page to be an excel sheet. Be sure to have this in a frame or window and you will not see the rest of the your page when done. Best, Drew Nathanson Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. -- The E ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfproperty getters
I'm using a component that has a variable of dsn. I set a cfproperty tag to get access to the dsn using the implicit getter ability of CF 9. cfproperty name=dsn It fails in all cases giving me a response of: The method getdsn was not found in component XXX Is there something simple I'm missing? Thanks -- Michael Dinowitz Lead Author - Adobe Coldfusion Anthology http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfproperty getters
And the answer is that the cfcomponent tag has to have accessors=true On Mon, Aug 23, 2010 at 3:24 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: I'm using a component that has a variable of dsn. I set a cfproperty tag to get access to the dsn using the implicit getter ability of CF 9. cfproperty name=dsn It fails in all cases giving me a response of: The method getdsn was not found in component XXX Is there something simple I'm missing? Thanks -- Michael Dinowitz Lead Author - Adobe Coldfusion Anthology http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336479 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Wow. That works very well. Thanks! -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 23, 2010 2:55 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Ah. The text was so small in my testing app that I couldn't tell what that was. Try this instead: [?|]q=[^]+ That only looks for q= when immediately following a ? or an . Given the same string: http://www.google.com/search?q=coldfusionsource=ighl=enrlz=aq=faqi=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It only matches ?q=coldfusion or q=coldfusion -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:48 PM To: cf-talk Subject: Re: RegEx: Grabbing Keywords from Referers Not sure where the second q= came from. From this: aq=f On Mon, Aug 23, 2010 at 1:44 PM, Andy Matthews li...@commadelimited.comwrote: This regex would search through a string and return all occurences of q=followed by any character that's NOT an . q=[^]+ Given this string: http://www.google.com/search?source=ighl=enrlz=q=coldfusionaq=faq i=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It matches q=coldfusion q=f Not sure where the second q= came from. I just did a search on the Google homepage for ColdFusion. andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 12:54 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Andy thanks again so much... this seems to work with Yahoo,Bing Google. My RegEx skills are a work in progress. cfset referer = http://search.yahoo.com/search;_ylt=Aqj24Omsi1LGKlDY4_G1hi6bvZx4?fr=yfp-t-7 01-stoggle=1cop=mssei=UTF8p=children%20karate%20uniform cfset keywords = reMatchNoCase([?|][p|q]=[^]+, referer) cfset keywords = urlDecode(reReplace(keywords[1],[?|][p|q]=, ,ALL)) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Awesome Che! Glad I could be of help! andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 3:01 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Andy thanks again so much... this seems to work with Yahoo,Bing Google. My RegEx skills are a work in progress. cfset referer = http://search.yahoo.com/search;_ylt=Aqj24Omsi1LGKlDY4_G1hi6bvZx4?fr=yfp-t-7 01-stoggle=1cop=mssei=UTF8p=children%20karate%20uniform cfset keywords = reMatchNoCase([?|][p|q]=[^]+, referer) cfset keywords = urlDecode(reReplace(keywords[1],[?|][p|q]=, ,ALL)) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading to Coldfusion 8
Synchronicity: Installing Multiple Versions of ColdFusion Together, with Daria Norris http://www.meetup.com/coldfusionmeetup/calendar/14515796/ http://www.meetup.com/coldfusionmeetup/calendar/14515796/ On Mon, Aug 23, 2010 at 9:44 AM, Matthew Williams mai...@geodesicgrafx.comwrote: It's fairly easy to do. * Choose multi-server EAR/WAR during the CF install. Choose the EAR specifically. * Create a new folder in jrunhome/servers/yournamefolder. * Expand the EAR/WAR into folders. Use the CF8 folders as an example. cfusion-ear will have a cfusion-war folder and a META-INF folder. cfusion-war will have CFIDE and WEB-INF. There also appears to be a crossdomain.xml in my cfusion-war folder for CF9. * COPY the application.xml from the working CF8 cfusion-ear/cfusion-war/META-INF folder into the new folder cfusion-ear/cfusion-war/META-INF. The application.xml created by the install will NOT work with JRun. Go figure. * Load up the JRun admin at port 8000. I have this service set to manual, but it may already be on. The username is admin, password is the password from when you first installed CF8. It can be found (unencrypted) in jrunhome/servers/admin/SERVER-INF/jrun-users.xml. * You should see a link to create a new instance. Go for it. * Name the instance the yourfoldername. It will automagically pic up the EAR/WAR you exploded into that folder * Create a service for it with jrunhome/bin/jrunsvc -install yourfoldername yourfoldername Macromedia JRun whatever Macromedia JRun whatever * profit Now, I'm not sure you're going to get SOLR along with this, but I'm fairly sure you can find that separate somewhere in the install folders. Some optional steps include downloading an updated JRE. You could also create a separate jvm.config and specify that during jrunsvc -install. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
calling a cfc function from the same cfc
I currently have a cfc to handle 404's that is called by my 404.cfm. It is working fine, but I need to use the same cfc for different sites. This works (very simplified, much more going on): cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent But this does not: cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfargument name=current_site_name type=string required=yes cfif arguments.current_site_name eq www_domain1_com cfset variables.tmp = domain1_404(arguments.requested_template) /cfif /cffunction cffunction name=domain1_404 access=public returntype=void output=no cfargument name=requested_template required=yes type=string cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent I don't know if I am just calling the second function improperly? What would be the best way to accomplish what I am doing? -- Regards, Matthew Smith ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: calling a cfc function from the same cfc
You are calling it correctly, but what is the error message that you are getting? Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Tuesday, 24 August 2010 6:50 AM To: cf-talk Subject: calling a cfc function from the same cfc I currently have a cfc to handle 404's that is called by my 404.cfm. It is working fine, but I need to use the same cfc for different sites. This works (very simplified, much more going on): cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent But this does not: cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfargument name=current_site_name type=string required=yes cfif arguments.current_site_name eq www_domain1_com cfset variables.tmp = domain1_404(arguments.requested_template) /cfif /cffunction cffunction name=domain1_404 access=public returntype=void output=no cfargument name=requested_template required=yes type=string cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent I don't know if I am just calling the second function improperly? What would be the best way to accomplish what I am doing? -- Regards, Matthew Smith ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:336484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: calling a cfc function from the same cfc
Actually I don't think it will make a difference, but you should do this cfset domain1_404(arguments.requested_template) / Not this cfset variables.tmp = domain1_404(arguments.requested_template) / Reason being is that you are not returning anything from this method as it is set to void. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Tuesday, 24 August 2010 6:50 AM To: cf-talk Subject: calling a cfc function from the same cfc I currently have a cfc to handle 404's that is called by my 404.cfm. It is working fine, but I need to use the same cfc for different sites. This works (very simplified, much more going on): cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent But this does not: cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfargument name=current_site_name type=string required=yes cfif arguments.current_site_name eq www_domain1_com cfset variables.tmp = domain1_404(arguments.requested_template) /cfif /cffunction cffunction name=domain1_404 access=public returntype=void output=no cfargument name=requested_template required=yes type=string cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent I don't know if I am just calling the second function improperly? What would be the best way to accomplish what I am doing? -- Regards, Matthew Smith ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:336484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: calling a cfc function from the same cfc
cfset domain1_404(arguments.requested_template) / Hmm, that's a weird syntax. output needed to be set to yes. Thank you both for the help. On Mon, Aug 23, 2010 at 3:52 PM, Andrew Scott andr...@andyscott.id.auwrote: Actually I don't think it will make a difference, but you should do this cfset domain1_404(arguments.requested_template) / Not this cfset variables.tmp = domain1_404(arguments.requested_template) / Reason being is that you are not returning anything from this method as it is set to void. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Tuesday, 24 August 2010 6:50 AM To: cf-talk Subject: calling a cfc function from the same cfc I currently have a cfc to handle 404's that is called by my 404.cfm. It is working fine, but I need to use the same cfc for different sites. This works (very simplified, much more going on): cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent But this does not: cfcomponent cffunction name=handle_404 access=public returntype=void cfargument name=requested_template type=string required=yes cfargument name=current_site_name type=string required=yes cfif arguments.current_site_name eq www_domain1_com cfset variables.tmp = domain1_404(arguments.requested_template) /cfif /cffunction cffunction name=domain1_404 access=public returntype=void output=no cfargument name=requested_template required=yes type=string cfif arguments.requested_template eq /art-cat/ cfmodule template=/index.cfm fuseaction=TheGallery.displayCategory key=#variables.category# requested_template=#arguments.requested_template# page_num=#variables.page_num# ignoresupresslayout=1 /cfif /cffunction /cfcomponent I don't know if I am just calling the second function improperly? What would be the best way to accomplish what I am doing? -- Regards, Matthew Smith ~~ ~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf- talk/message.cfm/messageid:336484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Site issue with Safari 5.01 on Mac
Looks like the problem here was related to Flash - we've got an on site IM client that was built with Flash, and of course it only shows up when you're logged in, which is why none of you saw the problem. And it only affected people with Flash on Safari 5.0.1 on Mac! Still not sure what the root cause is, but at least we're a little closer and the guy who built our IM client can maybe figure it out. Rick On Mon, Aug 16, 2010 at 2:17 AM, mac jordan mac.jor...@gmail.com wrote: On Mon, Aug 16, 2010 at 1:44 AM, Rick Root rick.r...@gmail.com wrote: We've got a user saying that their site is scred up on Safari 5.01 on Mac Looks fine in Safari 5.1 here, on my Mac Pro running Snow Leopard patched up to date. -- mac jordan www.kestrel.org | www.reactivecooking.com | www.jordan-cats.org twitter: @ramtops ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm