RE: Embedding CF in CMS Content
Thanks. I found another way around it. Just dealing with something that was already put together strangely, where some embedded functional code into a CMS WYSIWYG editor. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Embedding CF in CMS Content
I have a situation where I need to embed a CFINCLUDE in a CMS data field which is output. How do I get the include to render? Can I even do that? Example is like cfoutput#mydata#/cfoutput . the include is in the mydata output. Can I evaluate or something? Thanks Robert Harrison Full Stack Developer AIMG mailto:rharri...@aimg.com rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 http://www.aimg.com/ www.aimg.com ~| 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:360464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Server and Nulls
In an update query, to a tinyint field which allows nulls, I have the update dbfield=#mydatefield# If mydatefield has no value, sql is throwing an error. The field allows nulls. I've never had to say if then NULL before. What the heck? Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ajax Post Value on CF Side
Let me make this simpler. The value being send via an ajax post is: Object {name: rid, value: 1} If I just want to dump that value/object how to I do it? I have no idea what name CF see that as. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ajax Post Value on CF Side
Solved. The problem was I was overcomplicating this and treating it like JSON just like everyone else has been advising. With an AJAX post, the string: Object {name: rid, value: 1} Appears to Coldfusion as form values. The values #form.name# and #form.value# give me rid and 1. Too simple, so it confused me. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ajax Post Value on CF Side
I'm sending an Ajax post to a CF page. The post data looks like (below) in the counsel: Object {name: rid, value: 1} How in the heck to I get that value on the ColdFusion page? Robert Harrison Full Stack Developer AIMG mailto:rharri...@aimg.com rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 http://www.aimg.com/ www.aimg.com ~| 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:360413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Handling invalid recipient in mailing list
The CFTRY and CFCATCH method described earlier is a great method for a partial scrub. That method will scrub those email addresses which are malformed or have invalid syntax. That's a great start, but there are two additional things you should do as well: 1. Use the FAILTO feature of the CFMAIL tag and send the failed mail to an alternate return address. This will allow you to identify the mail where the email address has a valid syntax but is undeliverable. Of course, you'll need to parse through the mail to see why it's undeliverable based on the system messages. Some will be hard failures which are undeliverable because the email address is invalid or the account is discontinued. Those are sure fire mails to remove. Others will be soft failures with messages mailbox full or temporarily unable to connect with server. Those are suspect mails and if you keep a history of those, you may see some patterns like a mail box which is always full. After several of those type returns you can probably assume no one is collecting the mail and purge those as well. 2. You should also be sure to provide an Unsubscribe option on the mail. I'd assume you are most likely doing that as that's required by the CAN SPAM ACT. You can hook that up to a query so people can just do it themselves with no action needed from you. When sending bulk mail to a mail list it's important that you clean the list of failed mail and provide an opt-out option. Failure to do either could get your mail server blacklisted. and that's a headache you don't want to deal with. A high rate of failed mail and no opt-out feature will get you blacklisted very quickly. If you are going to this a lot, it's also a good idea you allow the mail so spool (cfmail spoolenable=yes) and you may even want to write a trickle program to slow down the outbound mail stream. If you have a bunch a mail going to the same server (or servers) and you're not trickling the mail, the server will try to send a bunch very quickly and your mail server could make multiple connections to the other server. Too many concurrent connections is another thing that's sets of the SPAM alarms and could also get you blacklisted. Lastly, to ensure your mail does not go the SPAM box, be sure you test the content in a SPAM RATING service. There are a lot of filters you can run the mail content through and get a rating telling you how 'spamy' the mail looks. There are a bunch of things they look - various trigger words like FREE, BUY NOW, VIAGRA, etc., malformed HTML, too many pictures and not enough text content, etc. Hope this was helpful. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Handling invalid recipient in mailing list
I never use anything but Mail Chimp for bulk mail sends Honestly, I too highly recommend a service like Mail Chimp or Constant Contact, or Emma. They clearly have their place and the headache of getting blacklisted is miserable, but sometimes you have a situation where the options and functions are built-into and integrated with the core site (or sites). In that case it may be best to 'roll you own' as they say. Thanks Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Handling invalid recipient in mailing list
I agree that using a third part service is highly desirable, but depending on the integration and the client it may not be feasible. I clearly have clients that would never allow their mail list or the mail content to be placed on any third-party server for compliance and/or security reasons... real or perceived. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Handling invalid recipient in mailing list
It is true that using a service like Mail Chimp to validate a mail list is an easy way to validate a mail list, but the steps I detailed are a valid alternative for any full blown system you may be managing. I've written systems that have opt-in, opt-out features and utilize a variety of merged lists, like customer lists, prospect lists, interest lists, etc. These are lists which are constantly changing based on user actions and other factors. If you're managing a dynamic, living list, those steps probably are the most valid. For one-offs, the service, as you suggest, is probably the best solution. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
File Upload/Management
I have a client who wants to be able to manage a file library on the server with multi-file uploads, file renaming, and directory organization. I've used Plupload and it's a good tool for multi file uploads, but I'm not really familiar with any tools that allows for directory management on the server. They want to be able to browse, upload, rename, and add descriptions of files; almost like an FTP program but something that runs in the browser and can be integrated into forms. Anyone familiar with any plugs-ins or third-party packages that may be useful... any links to any packages you may know of would be helpful. Thanks Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Test
Working. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Claude Schnéegans schneeg...@internetique.com [mailto:=?ISO-8859-1?Q?Claude Schn=E9egans schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Monday, March 30, 2015 10:29 PM To: cf-talk Subject: Test Is this list working? ~| 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:360324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Scheduler directory missing.
Just curious, but couldn't you install it on a different computer (even a laptop) and just copy the directly you need over without all the complications? Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jQuery: firing a click event from a class instead of an ID
I think you need to add an event listener for the class: classname.addEventListener('click', myFunction, false); Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: Friday, March 20, 2015 12:13 PM To: cf-talk Subject: jQuery: firing a click event from a class instead of an ID I have a button on a page with a class attached to it (several buttons actually) shouldn't I be able to attach a jQuery click event to the buttons using a class as a selector: $(.editPathway).click(function(){ var x = $(this).data(id); $('#pathEditFrm').jqm({ modal:true, ajax:'index.cfm?action=loadPathEditid=' + x + 'nolayout', closeOnEsc: true }).jqmShow(); }); a variation on this code fires just fine from an ID selector.. but won't fire at all from a class. Thanks in advance -- -- Scott Stewart Adobe Certified Instructor, ColdFusion 8 9 Adobe Certified Expert, ColdFusion 8 9 Blog: http://www.sstwebworks.com Email: webmas...@sstwebworks.com ~| 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:360273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Decrypting MD5
It looks like you can if you know the salt: http://www.hashkiller.co.uk/md5-decrypter.aspx http://www.md5online.org/ http://md5decryption.com/ http://www.md5decrypter.com/ Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Decrypting MD5
So basically MD5 is useless if you can't decrypt the value! That sucks. Maybe, if you're storing data you need to retrieve. Generally I use if for data I need to compare (like passwords), then I just encrypt the values the same way and compare the encrypted values. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Speech to text
Yes. Dragon software seems to integrate rather well... but really it's not a CF issue, it more of an HTML issue. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: John Allen [mailto:johnfal...@gmail.com] Sent: Friday, February 06, 2015 4:14 PM To: cf-talk Subject: Speech to text Hey List, Anyone done any Speech to text stuff with CF? Thanks list. ~| 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:360077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Speech to text
What are you going to do with it? If you going to voice drive your websites it's an HTML issue. You can speak and it will record in test fields, etc. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: PATH_INFO missing in CF 11
Is that ColdFusion or IIS? Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Alex DeMarco [mailto:alex.dema...@suny.edu] Sent: Wednesday, February 04, 2015 2:23 PM To: cf-talk Subject: PATH_INFO missing in CF 11 Has anyone noticed that cgi.PATH_INFO is missing in CF 11. We are working to upgrade from 9 to 11 and use PATH_INFO in various places.. Is this a known issue? Any ideas on how to remedy it? thanks! ~| 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:360057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
Were you using relative paths to the CFCs. That could become hairy if you move things around. I'll generally define a CFC path variable in the application.cfm then use that everywhere. Never had a problem. Of course, this assumes all the CFC's are in the same location. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
What other method than session variables can I use to pass a common variable that won't require me to include it as a parameter of every calling routine? Since you've moved your CFCs out of the application I cannot think of any other method beside passing them all as arguments. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
If you moved your cfc's above the application.cfc (or application.cfm) file, the session variables will not be accessible. Session and application vars are accessible from the application file down. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
You shouldn't, as it breaks encapsulation Honestly, I too think you should reconsider moving the CFC out of the web root. Maybe if you moved them out then created objects from them in the application.cfc, then you may be able to use session vars, as I think the objects would still be in the application. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
Well, I'd hate to do this, but you could define an application.myvar type variable and put all the variables you need to pass in that as a structure or list, then send that variable in your arguments. That would get to one variable ... but then you're still going to need to deconstruct it before you could use them in the CFC's. Personally I think you should put your CFC's back and fix the problem that's making you move them in the first place. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Cannot access session variables in a cfc
try adding an Application.cfc in the root physical directory I don't that that will work. It would still be a separate application pool, and I think you need the CFID and CFTOKEN cookies to have session vars. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| 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:360031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Call Rail API / CF
Below is a call rail API request in PHP. This works in PHP, but I need to run this in ColdFusion. I've tried every combination of cfhttp and cfhttpparam I can think of that looks correct, and have tried it using JSON, but I always get a 401 Unauthorized response. Anyone ever done the Call Rail API in CF or have any ideas on the code below. I'm about out of ideas. Thanks ?php $api_url = 'https://api.callrail.com/v1/companies.json'; // Replace with your API Key $api_key = 'MYKEYHERE'; $ch = curl_init($api_url); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, array(Authorization: Token token=\{$api_key}\)); $json_data = curl_exec($ch); $parsed_data = json_decode($json_data); curl_close($ch); // Examine meta data from the response $total_entries = $parsed_data-total_entries; echo Total entries: {$parsed_data-total_entries} \n; // Loop through companies foreach($parsed_data-companies as $company){ echo Company: {$company-name} \n; } ? Robert Harrison Full Stack Developer AIMG mailto:rharri...@aimg.com rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 http://www.aimg.com/ www.aimg.com ~| 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:359991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
The two most promising have been: cfset tmp = {} / cfset tmp['Authorization'] = Token token='MYKEYHERE' / cfhttp url=https://api.callrail.com/v1/companies.json; result=r method=post cfhttpparam type=header name=content-type value=application/json / !---cfhttpparam type=body value=#origTemp# /--- cfhttpparam type=body value=#serializeJson(tmp)# / /cfhttp cfdump var=#r# / AND cfhttp url=https://api.callrail.com/v1/companies.json; result=r method=post cfhttpparam type=header name=Authorization value=Token token=' MYKEYHERE'' / /cfhttp cfdump var=#r# / Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, January 19, 2015 11:22 AM To: cf-talk Subject: Re: Call Rail API / CF Robert, can you share the code that you have tried? On Mon, Jan 19, 2015 at 9:31 AM, Robert Harrison rharri...@aimg.com wrote: Below is a call rail API request in PHP. This works in PHP, but I need to run this in ColdFusion. I've tried every combination of cfhttp and cfhttpparam I can think of that looks correct, and have tried it using JSON, but I always get a 401 Unauthorized response. Anyone ever done the Call Rail API in CF or have any ideas on the code below. I'm about out of ideas. Thanks ?php $api_url = 'https://api.callrail.com/v1/companies.json'; // Replace with your API Key $api_key = 'MYKEYHERE'; $ch = curl_init($api_url); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER, array(Authorization: Token token=\{$api_key}\)); $json_data = curl_exec($ch); $parsed_data = json_decode($json_data); curl_close($ch); // Examine meta data from the response $total_entries = $parsed_data-total_entries; echo Total entries: {$parsed_data-total_entries} \n; // Loop through companies foreach($parsed_data-companies as $company){ echo Company: {$company-name} \n; } ? Robert Harrison Full Stack Developer AIMG mailto:rharri...@aimg.com rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 http://www.aimg.com/ www.aimg.com ~| 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:359995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
I'm not using my key here... I just not posting my key to a public forum that's indexed in Google. And I've treid get also... I've tried every variation I can think of. I got a 200 response from GET but no data. Otherwise I get 401. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, January 19, 2015 11:31 AM To: cf-talk Subject: Re: Call Rail API / CF You are more on track with the second one than the first. I have two comments. First, you are using a POST method and the documentation for the companies method states that it should be a GET method. Second, you are replacing MYKEYHERE with your assigned assigned API key, correct? On Mon, Jan 19, 2015 at 11:25 AM, Robert Harrison rharri...@aimg.com wrote: The two most promising have been: cfset tmp = {} / cfset tmp['Authorization'] = Token token='MYKEYHERE' / cfhttp url=https://api.callrail.com/v1/companies.json; result=r method=post cfhttpparam type=header name=content-type value=application/json / !---cfhttpparam type=body value=#origTemp# /--- cfhttpparam type=body value=#serializeJson(tmp)# / /cfhttp cfdump var=#r# / AND cfhttp url=https://api.callrail.com/v1/companies.json; result=r method=post cfhttpparam type=header name=Authorization value=Token token=' MYKEYHERE'' / /cfhttp cfdump var=#r# / Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -- [image: profile picture] *Dean Lawrence* *President* Internet Data Technology *Phone:* 888-438-4381 x701 *Web:* www.idatatech.com *Email:* d...@idatatech.com Programming | Database | Consulting | Training ~| 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:359997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
Nada! Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, January 19, 2015 12:01 PM To: cf-talk Subject: Re: Call Rail API / CF So when you dump the results of the cfhttp call, is it empty? If not, is there anything that is listed in the Filecontent key within the dump structure? On Mon, Jan 19, 2015 at 11:47 AM, Robert Harrison rharri...@aimg.com wrote: Yes. The PHP version does pull the data. The CF version comes up empty. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -- [image: profile picture] *Dean Lawrence* *President* Internet Data Technology *Phone:* 888-438-4381 x701 *Web:* www.idatatech.com *Email:* d...@idatatech.com Programming | Database | Consulting | Training ~| 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:360001 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
Yes. The PHP version does pull the data. The CF version comes up empty. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, January 19, 2015 11:46 AM To: cf-talk Subject: Re: Call Rail API / CF Ok, good, I just wanted to make sure. So, when you use a GET, it sounds like you are authenticating correctly, no? This my sound stupid, but do you have any companies added to the system for the API to return? Also, have you tried removing the single quotes from your API key in the header? In the API documentation, it does not have quotes around it, Authorization: Token token=abc1234. On Mon, Jan 19, 2015 at 11:37 AM, Robert Harrison rharri...@aimg.com wrote: I'm not using my key here... I just not posting my key to a public forum that's indexed in Google. And I've treid get also... I've tried every variation I can think of. I got a 200 response from GET but no data. Otherwise I get 401. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com [image: profile picture] *Dean Lawrence* *President* Internet Data Technology *Phone:* 888-438-4381 x701 *Web:* www.idatatech.com *Email:* d...@idatatech.com Programming | Database | Consulting | Training ~| 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:35 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Call Rail API / CF
Yep tried double quotes too. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Monday, January 19, 2015 12:06 PM To: cf-talk Subject: RE: Call Rail API / CF This line in the PHP seems to indicate that they are using double quotes around the key. curl_setopt($ch, CURLOPT_HTTPHEADER, array(Authorization: Token token=\{$api_key}\)); Have you tried using double quotes around the key? cfhttpparam type=header name=Authorization value='Token token=MYKEYHERE' / -- William Seiter -Original Message- From: Robert Harrison [mailto:rharri...@aimg.com] Sent: Monday, January 19, 2015 8:48 AM To: cf-talk Subject: RE: Call Rail API / CF Yes. The PHP version does pull the data. The CF version comes up empty. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, January 19, 2015 11:46 AM To: cf-talk Subject: Re: Call Rail API / CF Ok, good, I just wanted to make sure. So, when you use a GET, it sounds like you are authenticating correctly, no? This my sound stupid, but do you have any companies added to the system for the API to return? Also, have you tried removing the single quotes from your API key in the header? In the API documentation, it does not have quotes around it, Authorization: Token token=abc1234. On Mon, Jan 19, 2015 at 11:37 AM, Robert Harrison rharri...@aimg.com wrote: I'm not using my key here... I just not posting my key to a public forum that's indexed in Google. And I've treid get also... I've tried every variation I can think of. I got a 200 response from GET but no data. Otherwise I get 401. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com [image: profile picture] *Dean Lawrence* *President* Internet Data Technology *Phone:* 888-438-4381 x701 *Web:* www.idatatech.com *Email:* d...@idatatech.com Programming | Database | Consulting | Training ~| 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:360003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PHP To Cold Fusion
I have an API I need to work with. No problem converting most to ColdFusion, but two strings I'm unsure of: 1. The PHP encode format is: $signature = base64_encode(hash_hmac('sha256', $mystring, true)); I think in CF the equivalent would be: cfset signature=hash(mystring, SHA-256, Base64) 2. The other part is : $ts=time(); Not sure what format the above outputs. Could it be the same as: cfset ts=now() Any thoughts? Thanks Robert Harrison Full Stack Developer AIMG mailto:rharri...@aimg.com rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 http://www.aimg.com/ www.aimg.com ~| 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:359978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: PHP To Cold Fusion
Thanks. I got through that one. Now I'm trying to set up the call rail API. Anyone done that in CF before? Thanks Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: validating email CF11
I had similar issues with this... use the script below instead of CF. You can do an onBlur=validateEmail(); on the email field. function validateEmail(){ var emailRegEx = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/; str = document.userform.email.value; if(!str.match(emailRegEx)){ alert(Please enter a valid email address (n...@domain.com).); userform.email.focus(); return false; } } Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Thursday, January 15, 2015 9:49 AM To: cf-talk Subject: validating email CF11 Hi Folks Using CF11 isValid(email,name@gmail) is returning a Yes Am I missing something or is this a bug. As far as I know CF9 would have returned NO Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry http://www.clergyleadership.com/ 503-647-2378 or 503-647-2382 ~| 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:359967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: validating email CF11
Thanks, I'm aware. You can change that if you'd like, but so far from the 200 plus sites I've done, I've never has a .museum address. It could happen; someone does the museum sites :-) If you want another that uses CF and allows museum, you could try the function below... someone on the list gave me this ages ago. cffunction name=isEmail returntype=boolean access=public output=false cfargument name=email_address type=string required=true / cfscript var isOK = false; //supports new top level tlds if ( REFindNoCase(^['_a-z0-9-]+(\.['_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a -z]{2,3})|(aero|coop|info|museum|name))$,arguments.email_address)) { isOK = true; } return isOK; /cfscript Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Adobe ColdFusion Blog futzed?
Looks OK to me... Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Eliminating CFM extensions in IIS 7
I'm no expert on this, and struggle with IIS config, so hopefully someone on the list can help. I'm trying to use URLs like mysite.com/news/2014/the-article. Below is a url rewrite that rewrites a request like mysite.com/news/ to myside/news.cfm. That part works. But, if you add another directory like mysite.com/news/2014 it tries to rewrite to mysite.com/news/2014.cfm and that does no good. Does anyone know if there is a way to get it this to rewrite the .cfm only on the first url var after the first /? Thanks ?xml version=1.0 encoding=UTF-8? configuration system.webServer rewrite rules rule name=AddCFM enabled=true match url=.* negate=false / conditions add input={REQUEST_FILENAME} matchType=IsFile negate=true / add input={REQUEST_FILENAME} matchType=IsDirectory negate=true / add input={URL} pattern=(.*)\.(.*) negate=true / /conditions action type=Rewrite url={R:0}.cfm / /rule /rules /rewrite /system.webServer /configuration Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Eliminating CFM extensions in IIS 7
News was just an example. Can I do it for every first level item mysite.com/this or mysite.com/that without needing to add a specific rule for each? Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Jon Clausen [mailto:jon_clau...@silowebworks.com] Sent: Wednesday, December 10, 2014 10:05 AM To: cf-talk Subject: Re: Eliminating CFM extensions in IIS 7 You need to specify a rewrite handler for everything in the /news/ path. Assuming /news.cfm handles all of your requests for that path, your rule would look something like this: rule name=News Handler stopProcessing=true match url=^news/(.*) ignoreCase=false /action type=Rewrite url=/news.cfm?{R:1} appendQueryString=false / /rule If you add this rule above the AddCFM rule, it will stop processing subsequent rules and should give you the behavior you are looking for. HTH, Jon On Dec 10, 2014, at 9:42 AM, Robert Harrison rharri...@aimg.com wrote: I'm no expert on this, and struggle with IIS config, so hopefully someone on the list can help. I'm trying to use URLs like mysite.com/news/2014/the-article. Below is a url rewrite that rewrites a request like mysite.com/news/ to myside/news.cfm. That part works. But, if you add another directory like mysite.com/news/2014 it tries to rewrite to mysite.com/news/2014.cfm and that does no good. Does anyone know if there is a way to get it this to rewrite the .cfm only on the first url var after the first /? Thanks ?xml version=1.0 encoding=UTF-8? configuration system.webServer rewrite rules rule name=AddCFM enabled=true match url=.* negate=false / conditions add input={REQUEST_FILENAME} matchType=IsFile negate=true / add input={REQUEST_FILENAME} matchType=IsDirectory negate=true / add input={URL} pattern=(.*)\.(.*) negate=true / /conditions action type=Rewrite url={R:0}.cfm / /rule /rules /rewrite /system.webServer /configuration Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Eliminating CFM extensions in IIS 7
Thank you. I was able to use this and adjust to the solution I needed. Really appreciate the assist. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Jon Clausen [mailto:jon_clau...@silowebworks.com] Sent: Wednesday, December 10, 2014 10:05 AM To: cf-talk Subject: Re: Eliminating CFM extensions in IIS 7 You need to specify a rewrite handler for everything in the /news/ path. Assuming /news.cfm handles all of your requests for that path, your rule would look something like this: rule name=News Handler stopProcessing=true match url=^news/(.*) ignoreCase=false /action type=Rewrite url=/news.cfm?{R:1} appendQueryString=false / /rule If you add this rule above the AddCFM rule, it will stop processing subsequent rules and should give you the behavior you are looking for. HTH, Jon On Dec 10, 2014, at 9:42 AM, Robert Harrison rharri...@aimg.com wrote: I'm no expert on this, and struggle with IIS config, so hopefully someone on the list can help. I'm trying to use URLs like mysite.com/news/2014/the-article. Below is a url rewrite that rewrites a request like mysite.com/news/ to myside/news.cfm. That part works. But, if you add another directory like mysite.com/news/2014 it tries to rewrite to mysite.com/news/2014.cfm and that does no good. Does anyone know if there is a way to get it this to rewrite the .cfm only on the first url var after the first /? Thanks ?xml version=1.0 encoding=UTF-8? configuration system.webServer rewrite rules rule name=AddCFM enabled=true match url=.* negate=false / conditions add input={REQUEST_FILENAME} matchType=IsFile negate=true / add input={REQUEST_FILENAME} matchType=IsDirectory negate=true / add input={URL} pattern=(.*)\.(.*) negate=true / /conditions action type=Rewrite url={R:0}.cfm / /rule /rules /rewrite /system.webServer /configuration Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com ~| 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:359790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail causing problems for our server
Use a mail relay like STMP.com. Just change the smtp server for your mail blast to send through the relay. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Wednesday, December 10, 2014 1:23 PM To: cf-talk Subject: cfmail causing problems for our server My customer's site allows interested visitors to subscribe to intermittent e-mail notifications regarding his annual event. My hosting provider tells me that use of cfmail to contact his 5,000+ mailing list is triggering blacklisting when we use it to notify subscribers of event changes and additions. He (the hosting provider) insists we use a third party e-mail service instead. Can anyone recommended such a service that can be trusted not to resell the DB? Thank you. Dave Long NorthGoods Merchant Services ~| 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:359792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: test
Test from address2. Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.121 Direct Line: 516-302-4345 www.aimg.com -Original Message- From: rob...@creativecyberspace.com [mailto:rob...@creativecyberspace.com] Sent: Tuesday, December 09, 2014 5:10 PM To: cf-talk Subject: test test ~| 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:359783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Not able to read a RSS feed from a WordPress website
That was my original suggestion was to check the firewall of the receiving server :-) -Original Message- From: Ben [mailto:b...@webworldinc.com] Sent: Friday, September 26, 2014 6:55 PM To: cf-talk Subject: Re: Not able to read a RSS feed from a WordPress website Ah. Good call! I'm surprised they had them. Ben On Sep 26, 2014, at 3:39 PM, Chris h h_chris...@yahoo.com wrote: Wow. How in hell did you figure that out? Ben Hi Ben, I asked for the firewall logs of the server running WordPress and saw that the IP address of server running ColdFusion was blocked. ~| 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:359366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Test - Ignore
Test from new account... also ignore. ~| 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:359302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Not able to read a RSS feed from a WordPress website
Just to clarify: from the machine running CF, if you use a browser, can you get to the site correctly? No, I cannot access the site from the machine running CF. It's possible the issue is not on your side. It could be on the side of the site you are trying to read from. You can't display the site in a browser on the CF machine... try displaying it in a browser that shows the same external IP address as your server. It's possible your IP has been blocked by the firewall on the sending side. If that's the issue it will have to be fixed on their side. Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:359277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Not able to read a RSS feed from a WordPress website
but don't think they(hostingcompanyA) would block a particular IP address(server running CF which belongs to hosting company B) Yes, they would if they detected something funny coming your server... like a bunch of pings or form bots or something... for that matter a bunch of unexpected reads of the RSS file your reading could have set off some kind of alarm that caused them to block the IP. It depends on them and what they see as an intrusion. A lot of hosting companies are great professional companies that can really analyze threats... a lot of them are some guy with a server or two in basement too and anything odd they see they block. Yes, it's possible they blocked you intentionally if they saw a lot of unexplained requests coming from your server. try displaying it in a browser that shows the same external IP address as your server How do I do that? If your server is on your network its likely most of the machines on your network are on the same firewall and show the same public IP. Google what's my IP from the server and from another machine on that network. If they show the same public IP, try accessing the site from the alternate machine. If it doesn't work, you may be blocked. If the server is at a separate location (hosting company), you may have to ask them for help with this. Honestly, at this point with what you know this does not sound like a job for a programming issue and it may not be best for a programmer to be troubleshooting it. You should get a network engineer to take a look. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:359280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Link checker
I use http://home.snafu.de/tilman/xenulink.html . The icon looks like an alien but it works great for link checking. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Wednesday, September 10, 2014 2:47 PM To: cf-talk Subject: Re: Link checker Hi Byron I use html validator https://www.htmlvalidator.com You can batch test an entire website. Not only checks links but html, accessibility etc. Rob On 10 Sep 2014 at 14:36, Byron Mann wrote: I know there was a previous thread about spidering a site to check links and some people recommended a certain utility other than wget. I went through the archives and wasn't able to find that thread. ~| 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:359283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFTRY / CFCATCH not working
I have a script that returns image properties to me (below). After years of using it I've hit some sort of file that crashes it. The error I'm getting is: Numbers of source Raster bands and source color space components do not match null I'm assuming that from a corrupt image file, but the real problem is I wrapped this in a cftry / cfcatch (as shown below) and it's ignoring the CFTRY and giving me a hard error. cftry cfscript function get_imageinfo(imgfile){ jFileIn = createObject(java,java.io.File).init(imgfile); ImageInfo = StructNew(); ImageObject = createObject(java,javax.imageio.ImageIO).read(jFileIn); -THIS IS THE OFFENDING LINE imageFile = CreateObject(java, java.io.File); imageFile.init(imgfile); sizeb = imageFile.length(); sizekb = numberformat(sizeb / 1024, 9.99); sizemb = numberformat(sizekb / 1024, .99); get_imginfo = StructNew(); get_imginfo.ImgWidth = ImageObject.getWidth(); get_imginfo.ImgHeight = ImageObject.getHeight(); get_imginfo.SizeKB = sizekb; get_imginfo.SizeMB = sizemb; get_imginfo.ImageFormat = ListLast(ListLast(imgfile, \), .); } /cfscript cfcatch type=Anycfset get_imginfo.ImgWidth=0cfset get_imginfo.ImgHeight=0/cfcatch /cftry It runs this in a loop over a bunch of images and works until it hits the bad file... but it's ignoring my CFTRY and still throwing a hard error. Anyone have any ideas on why the CRFTY/CFCATCH is not working. Is there a problem because I'm catching a cfscript block? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams ~| 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:359254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFTRY / CFCATCH not working
Thanks, but that had no effect at all. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, September 09, 2014 1:25 PM To: cf-talk Subject: Re: CFTRY / CFCATCH not working If there is an error in your error handling code you will get a hard error. It may be because you are still attempting to work with the corrupt file in your catch. Change this: cfcatch type=Anycfset get_imginfo.ImgWidth=0cfset get_imginfo.ImgHeight=0/cfcatch To this: cfcatch type=Any/cfcatch ...and see if it makes the error go away. -Cameron On Tue, Sep 9, 2014 at 1:02 PM, Robert Harrison rob...@austin-williams.com wrote: I have a script that returns image properties to me (below). After years of using it I've hit some sort of file that crashes it. The error I'm getting is: Numbers of source Raster bands and source color space components do not match null I'm assuming that from a corrupt image file, but the real problem is I wrapped this in a cftry / cfcatch (as shown below) and it's ignoring the CFTRY and giving me a hard error. cftry cfscript function get_imageinfo(imgfile){ jFileIn = createObject(java,java.io.File).init(imgfile); ImageInfo = StructNew(); ImageObject = createObject(java,javax.imageio.ImageIO).read(jFileIn); -THIS IS THE OFFENDING LINE imageFile = CreateObject(java, java.io.File); imageFile.init(imgfile); sizeb = imageFile.length(); sizekb = numberformat(sizeb / 1024, 9.99); sizemb = numberformat(sizekb / 1024, .99); get_imginfo = StructNew(); get_imginfo.ImgWidth = ImageObject.getWidth(); get_imginfo.ImgHeight = ImageObject.getHeight(); get_imginfo.SizeKB = sizekb; get_imginfo.SizeMB = sizemb; get_imginfo.ImageFormat = ListLast(ListLast(imgfile, \), .); } /cfscript cfcatch type=Anycfset get_imginfo.ImgWidth=0cfset get_imginfo.ImgHeight=0/cfcatch /cftry It runs this in a loop over a bunch of images and works until it hits the bad file... but it's ignoring my CFTRY and still throwing a hard error. Anyone have any ideas on why the CRFTY/CFCATCH is not working. Is there a problem because I'm catching a cfscript block? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams ~| 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:359256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFTRY / CFCATCH not working
It's a seven year old site but it's on a CF10 server. Tried using CFIMAGE but it's too slow. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:359259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: EMail Injection Attack
Can you explain a bit more what you mean by email injection attack? Do you mean someone is spamming forms that generate forms email, or is someone using some application you have to generate spam? Can you provide a slightly better explanation of what's happening? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:359130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: EMail Injection Attack
There are a bunch of things you can do depending on exactly how this is happening. Using STMP authentication is one... but if you think your forms are being spoofed, you may be able to use cgi vars to get some info. You can use CGI referrer to see if the request is coming from the correct page... wrap your cfmail code in CFif referrer is the expected source with an else. If it's coming from the correct page, let it process. If else, dump the vars and referrer IP to a log or send it to yourself in a mail. If you need some help with that I may be able to mock up some sample code tomorrow, but I'm on client need at the moment. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_wi ~| 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:359137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: protection from sql attacks with regex++
Uhm... cfqueryparam Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Stephens, Larry V [mailto:steph...@iu.edu] Sent: Friday, August 15, 2014 1:51 PM To: cf-talk Subject: protection from sql attacks with regex++ Using information from a Ben Nadel atricle, jsStringFormat( htmlEditFormat()) seems to be catching insertions like b and escaping them. However, I have tried a number of regex routines from http://www.symantec.com/connect/articles/detection-sql-injection-and-cross-site-scripting-attacks plus another from a CF article that I can't place at the moment, to catch statements like select * from tblX inserted into a text field. None of them seem to work. The number of articles and pages making recommendations and giving examples is overwhelming. Can someone provide a suggestion for protecting a site in addition to what I got from Nadel and using ScriptProtect? ~| 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:359119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Sort by file extension in CFDIRECTORY
Interesting... You might be able to use a query of queries after you gotten the file list... Or you might recourse the directory to get the extension then do a separate query on each extension. That's an interesting question... I'm going to watch for what others say. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:359037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: need a host
These guys have been great: http://www.edgewebhosting.net/ Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Script Protect Question
I've recently moved to a new host who has global script protect turned on in CFAdmin. All in all it's not a bad thing, but I have some e-commerce pages where the gateway processes on another server then responds by sending back some form variables which contain data like the approval code, confirmation number, etc. Script protect is blocking the form variables and I'm recording blanks for these transactions. I don't really want to turn off script protect globally, but I do want to shut of the forms protect on selected pages. How can I list the pages and/or form variables I want to allow as an exception? I looked at the CF documentation and did not find it to be that clear. Thanks, Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Script Protect Question
Do you know of any code samples for the first solution where you may be able to send a link? I read the documentation and agree this seems to be the way to do, but I'd sure like to see some sample code on that. Thanks Robert Harrison -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, May 13, 2014 10:30 AM To: cf-talk Subject: Re: Script Protect Question Script protect is blocking the form variables and I'm recording blanks for these transactions. I don't really want to turn off script protect globally, but I do want to shut of the forms protect on selected pages. How can I list the pages and/or form variables I want to allow as an exception? You could probably do this by adding conditional logic in Application.cfc that turns the feature off for a specific list of pages. Otherwise, you could put the problematic pages in a separate directory and give them their own Application.cfc. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:358626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Script Protect Question
Understood, unfortunately I'm not in a position to revamp all the 21 sites we just moved right now and change the structure. I'm just looking for a fix to solve on issue on a few selected pages in this new environment. Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, May 13, 2014 11:39 AM To: cf-talk Subject: Re: Script Protect Question or you could consider taking a look at Fusegaurd instead which will give you far more granular control. There are also various web application firewall modules available for IIS and Apache which you could use for more generic security that is not CF specific. Yeah, honestly, I'd also recommend any of these approaches over CF's script protect, which is very weak. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:358631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd CSV Results
I would assume you are doing a loop to generate the CSV content. Are you adding CHR13 to the end of each line? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:01 PM To: cf-talk Subject: Odd CSV Results Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| 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:358642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd CSV Results
Good. Glad it's solved. I've done a lot of CSV files and they do seem to work well once you get the syntax correct. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:19 PM To: cf-talk Subject: RE: Odd CSV Results I am and the issue now appears to have worked itself out. I had to clear my cache even though I had Always Refresh From Server selected in dev tools. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, May 13, 2014 2:03 PM To: cf-talk Subject: RE: Odd CSV Results I would assume you are doing a loop to generate the CSV content. Are you adding CHR13 to the end of each line? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:01 PM To: cf-talk Subject: Odd CSV Results Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| 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:358645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: stripping characters for meta description
For meta tags I just use a simple replace list to strip the quotes. I use the list so I can replace the standard quotes and those left and right smart quotes from word. I'm assuming you're doing this because your meta description is getting truncated when it hits the first in-line quote. The HTML thinks that's the end of the string, yes? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Testing new account
Test to see if this post to a new account I just added to the list. Please ignore. ~| 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:358569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF11... Live?
And yet it isn't visible on the main adobe page. As a matter of fact if you go to products it isn't listed there. Even when you click see all products. I just don't get Adobe at all. I'm so disappointed in them. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spam management for forms handling
Image captchas are undetectable by screen reading packages such as those used by the blind and lock out legitimate visitors. What is [random value from earlier] plus twenty: ___ Yes, but then you'll lock out the stupid... oh, I mean the mathematically challenged. :-) Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spam management for forms handling
Personnaly, I consider such methods that require the visitor to do something quite unfriendly, especially for blind people, even insulting. It is much easier and transparent to use Javascript to add some value in some hidden field. I tend to agree. The Honey Pot field, while simple, has actually been very effective. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spam management for forms handling
You can use: 1. A honey pot field (a field hidden by CSS, with an indicator to leave this field blank); if it's filled it's probably a bot, so don't process... or 2. CFCAPTCHA to generate a captcha and make the user type what's shown; send only if it's a match... or 3. CFFORMPROTECT - http://cfformprotect.riaforge.org/ These are pretty much listed in order of the least effort first. They all work to varying degrees, but I've found just the honey pot will knock out most of it. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spam management for forms handling
Oh, that's funny! I'll have to start using Donald as a question. Great idea! But what if they answer cartoon or Disney character. That would create a very bad user experience if you tell them they're wrong ... LOL Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduled Tasks Running Twice
All of the sudden all of the scheduled CF tasks are running twice in a row, one minute apart. We can find no sign of duplicate tasks in the scheduler. Any ideas? Thanks, Robert ~| 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:358258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Scheduled Tasks Running Twice
OK. Some research indicates this is a common problem, but the answers found so far are not definitive. Any ideas would be appreciated. Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, April 01, 2014 9:13 AM To: cf-talk Subject: Scheduled Tasks Running Twice All of the sudden all of the scheduled CF tasks are running twice in a row, one minute apart. We can find no sign of duplicate tasks in the scheduler. Any ideas? Thanks, Robert ~| 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:358259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Quick Survey
I'd love to stick with CF as I've used to it successfully to solve almost every client request that's ever been asked... and some of them have been very complex and convoluted. However, with Adobe's lack of support and marketing CF has become too hard of a sell... we're moving to PHP now. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, March 25, 2014 10:51 PM To: cf-talk Subject: Re: Quick ~| 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:358099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Quick Survey
It wasn't - but the frustration wasn't towards you at all - just the general tiredness of it happening here so often. If others are like me they don't want to see CF die. For me, responding to these posts has always been in the hopes Adobe monitors this list and would hear the cries of their loyal fans... but alas, Adobe has been mute and has fallen short. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:358100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Quick Survey
@Robert Did you looked into Railo? If clients don't want to use Adobe Coldfusion due to the recent bad news, I've been recently able to sell Railo to them instead. It's not recent bad news that caused this. It's been a long slow decline that Adobe has failed to address with any marketing or rebranding initiatives. The perception of the technology, the limitations and costs of available hosts, the limited number of developers, and the facts that no IT departments (that I know of) teach ColdFusion as part of their curriculum is the issue. Adobe could has long since addressed all of these issues. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_wi ~| 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:358102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The long tail of ColdFusion fail
For us, what we've encountered include: 1. It's more expensive to host CF and there are few host (somewhat true) 2. CF is an old and outdated (not true) 3. CF has little future left and is a dying technology (possibly true... even if it's a self-fulfilling prophecy) 4. There are few CF Programmers available to maintain a site and there are a lot of PHP programmers around (true, setting quality aside, which few clients understand) 5. There is a lot of free code from open source you can grab to save money (somewhat true... sure more available PHP than CF code, but there is also that quality issue) 6. Internally we (the client) are not equipped to run and support CF; but we have some knowledge of PHP or .NET and can support it better (generally comes from the client's IT; it is probably an accurate statement) One additional issue I've been concerned with... few educational institutions teach CF or even mention it in their IT programs. These are the arguments we most frequently encounter. We can argue each item among ourselves, but arguing with a client is not all that profitable. I've been suggesting on this list for years that Adobe address this and refresh CF... maybe even rebrand and re-release it with a shiny new name and new back-up marketing materials, but alas... nothing. And one other issue I have with Adobe, they make PDF and Photoshop, so in my opinion CF should be the flat out best tool available to manipulate PDFs and images, but again, there is an Adobe disconnect. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_wi ~| 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:358015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The long tail of ColdFusion fail
It's unfortunate, and I've tried to fight it for years, but CF is clearly experiencing a slow, painful death. At this point almost all of our CF sites have been hacked repeatedly (and before you point me to the lockout guide - we don't host CF, we just build (built) the sites). We're not releasing any more CF sites and are converting those site we can to PHP. I hate that this is happening, but the writing is on the wall. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The long tail of ColdFusion fail
Oh yeah. Change from a closed source to an open source. What can possibly go wrong. :) The decision to abandon CF is not mine. It was made above my head. It's become more and more difficult to sell CF solutions to potential new clients and they and their IT departments are flat out refusing CF technology. And as far as the hacks... this is why I was asking for hosting recommendations a couple of month ago. We're in the process of moving our CF sites to Edge right now. I for one love ColdFusion... but it's a show stopped for the sales team now. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: The long tail of ColdFusion fail
Well, I'm sorry to hear that. I always hate to hear it when people throw away perfectly good code. Me too. I have CF solutions for almost every issue that's reared its' head in the last 15 years and tons of great code built into highly configurable CFC's... nonetheless, CF technology has become a hard-sell these days and the sales team can't sell it any longer. Most new clients see CF as old and outdated technology with no future... and their IT departments don't want CF because of that belief. It's a self-fulfilling prophecy. Unfortunately, Adobe has little to nothing to help CFs' image problem. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Site hanging randomly.
Is it the same time of day? If so, check scheduled tasks and see if something is running that conflicts or is consuming resources. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: .jonah [mailto:jonah@creori.com] Sent: Thursday, March 13, 2014 7:50 PM To: cf-talk Subject: Site hanging randomly. So, here's a tricky one. I have a server that hangs seemingly randomly but around once a day. Windows Server 2008, IIS, ColdFusion 9. It will either return a 503 or the browser will just keep spinning and never return anything. When I go in to restart it (with a batch file) sometimes the ColdFusion 9 Application Server service takes a really long time to stop and sometimes the W3SVC service takes a long time. Where do I start diagnosing this? How can I find out what's hanging? Which windows info should I look at? ColdFusion? Thanks! ~| 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:357934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Global String Replace
Thanks everyone for the suggestions. I've tested the one at this link: http://www.mssqltips.com/sqlservertip/1555/sql-server-find-and-replace-values-in-all-tables-and-all-text-columns/ and it works perfectly. I mentioned previously that I was hoping to run it in CF, and that was partially because some of the hosts don't like to give direct access to the data bases on their servers. Regardless, after testing I can see it's a heavy load and have to agree with Ben Forta that it really should be run as a query in Studio. I'll deal with getting the access I need to run directly. Thanks, Robert Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:357865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Global String Replace
you could just used a stored procedure which will save it directly to the database, and then execute it from CF That never even crossed my mind. Good idea. Thanks. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Global String Replace
Does anyone have an update program that can update a text string in all tables/rows/columns of an MS SQL data base? Need to do a global text string replace on several sites. Any help appreciated. Thanks, Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_wi ~| 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:357831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Global String Replace
Yes, I do mean like that, but I was really hoping someone had it already written up in CF with a tested procedure they would be willing to share. I was able to find several downloads for PHP, but nothing for CF. Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Global String Replace
Actually, that's the kind of operation that you'd not want to perform in CF (or PHP or any other database client). Unless you truly need all that data within a CF page for some other reason, you shouldn't be sending it all back and forth between DBMS and CF. ... I'm going to do this locally, but it seems to be done in PHP as a matter of course. We use such a thing on our WordPress sites when to change the URLs we move from a staging URL to a live URL, and there are lots of PHP programs prewritten to do just that. What I'm doing here is the same thing... changing URLs embedded into the CMS pages. - Robert ~| 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:357837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Honest question about cfform
I have used cf since v4 and it has always had both client side and server side validation Ditto... but for client side validation I seldom use CFFORM unless it is a very simple form. CFFORM is good for required fields and for some validation of data types entered in fields. It falls short when there is any conditional validation (i.e., the validation for one field depends on the response made in a previous field) and it falls short on the aesthetics of reporting errors. Unless they've added something new I'm unaware of, it still uses an alert to show errors. Generally I'll use jQuery validation or write my own script. The user experience can be much improved from CFFORM validation. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFDOCUMENT Output without Page Break
I am trying to output a PDF through the cfdocument tag, without any any page breaks. I would like to get one long document, with pagination. The system is not designed to do this as PDF documents are paginated to the size of the paper page you specify. You use CFDOCUMENT to create the PDF and can specify your page size and width. Generally you use a standard page size, but you can use a custom size. I'm not sure what the limits are, but you may be able to define an extremely long page length to make the system think it can put all the data on one page. That could effectively kill page breaks. You'd have to play with this to see if it's possible, but it may work. Hope that helps some... Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:357753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Jrun Restarts Itself Every Few Minutes - CF 8
It turns out that CFX_OPENIMAGE had been chocking on a corrupted file--and every time it was asked to process that file the server would crashnice... It's possible the image isn't even corrupted. I've had it choke like that on .jpg files saved in CYMK format. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: setting up team games
I assume you're using a data base and some sort of random generator program to match up the teams. If this is the case, just keep a history table of who has played who, then when you run the random play generator, check the history and do not allow repeats. If you're going to get 10 teams to play each other, it's going to take more than 10 games to get them to play each other... I think that would take 90 games... unless not everyone is playing everyone. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, February 04, 2014 11:00 AM To: cf-talk Subject: setting up team games I am working on a website to keep track of baseball teams. once section will be to take like 10 teams and set them up to play each other over 10 games. I would like to figure out a way to programmatically to take the 10 teams and match them up with the other teams over the 10 games so they only play each other once over the course of the 10 games. Make sense? I am sure it is something simple, but I can't get my head wrapped around it. Thanks! Chad ~| 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:357580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: setting up team games
It has to be 90 games. Just draw a 10 by 10 grid and list the teams up and down. That's 100 squares. X out the ones where a team plays itself, and you have ten boxes removed... that's 90 games. Thinking this way, you could use an array if you wanted. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: setting up team games
Actually there are 9 + 8 + 7 + 6 + 5 + 4 + 3 + 2 + 1 = 45 possible combinations. Yes, you're correct. I was forgetting about repeats. In my scenario each team combination would play twice, once at home and one away. Guess I still have that stupid Superbowl pool stuck in my head. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Anyone know how to clear your google details from a browser?
Storing passwords is one thing, but if you use Google + or Google Drive, Google apparently keeps history on its own servers too. I recently bought a new cell phone and after I set up my Gmail account, my search history from work and other Google related data was suddenly showing up in my cell phone browser. Totally freaked me out... then I realized because I use Google Drive I'm logged in at work. Apparently Google keeps a lot of history on the server side also. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating Grayscale PDF with CFDocument in CF8?
Perhaps a print stylesheet? Yes, we also have a few sites with print to PDF, and similarly the client wanted them to print differently. A print style was the solution. http://demosthenes.info/blog/532/Convert-Images-To-Black-And-White-With-CSS Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I pass this jQuery variable as arguments to a cfc method?
If the value isn't changing after the page is rendered you may be able to use document.write java script to write the variable to a CF variable that you can pass to the CFC. I've done that before and it works fine, so long as the variable doesn't change after the page is rendered. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, January 15, 2014 3:57 PM To: cf-talk Subject: How do I pass this jQuery variable as arguments to a cfc method? Hi, all... I've approached this problem from every direction I can think of and with reference to many, many websites, but I still can put together an answer. I have this HTML in a form: cfoutput query = qGetSpecials div class=special_title_container span class=title_checkbox_span input id=special_id_#special_id# class=special_title_checkbox value=#special_title# type=checkbox name=special_title /span span class=special_title_span#special_title#/span /div /cfoutput Which is output into this: input id=special_id_26 class=special_title_checkbox value=First Special type=checkbox name=special_title input id=special_id_27 class=special_title_checkbox value=Second Special type=checkbox name=special_title input id=special_id_28 class=special_title_checkbox value=Third Special type=checkbox name=special_title This jQuery processing the inputs: $(document).ready(function() { $('#newsletter_preview_button').click(function() { var specialTitleID = $('.special_title_checkbox:checked'); $('.special_title_checkbox:checked').each(function(index,value) { var specialTitleID = $(this).attr('id').split('_').pop(); var specialTitleID = 'specialTitle_'+specialTitleID; alert(specialTitleID); --- [ this alerts the three input values, 26, 27, 28, individually when form is submitted ] }); values = { emailNewsletterGreeting: emailNewsletterGreeting, specialTitleID: specialTitleID} (Followed by AJAX code...) And this cfc method: cffunction name = mProcessEmailNewsletterForm displayName= mProcessEmailNewsletterForm hint = Processes Email Newsletter Form output = true access = remote returnType= struct cfargument name = emailNewsletterGreeting type = string required = no / cfargument name = specialTitleID type = string required = no / cfset emailNewsletterStruct = structNew() / cfset emailNewsletterStruct.email_newsletter_greeting = '#arguments.email_newsletter_greeting#' / cfset emailNewsletterStruct.specialTitleID = '#arguments.specialTitleID#' / cfreturn emailNewsletterStruct / /cffunction But, the cffunction above doesn't know what to do with the value, specialTitleID, when it's received. Or, rather, I don't know how to change it in the jQuery code or the cffunction code so that each specialTitleID can be separted into individual cfarguments. I've tried specifying cfargument name=specialTitleID as type=array, type=list, type=string, but I get a JS error in Firebug no matter what I try. I'm sure it's simple, I just haven't handled a multi-valued variable going via AJAX to a cfc method before. (or that I remember...). Suggestions, anyone? Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:357431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I pass this jQuery variable as arguments to a cfc method?
It is **impossible** to document.write... yes, your right. Sorry about that. It was the other way... writing CF to JS vars. My bad! Doing too much as once. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: generating and merging pdfs
I have one system that generates and merges PDFs all day long. It was troublesome, but once we got the JVM heap size correct it worked fine. Try increasing the heap size (a lot) in CFADMIN. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Ketan Jetty [mailto:kje...@yahoo.com] Sent: Sunday, January 12, 2014 9:52 AM To: cf-talk Subject: Re: generating and merging pdfs I think you are probably are maxing out the JVM. Try this option, merge 1000 pdf's in one (create 3 such pdf's) and them merge these 3 huge pdf's into one big pdf. ~| 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:357393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Hosting... Again
Hi All, I've got a lot of large CF sites I have to move because my host is not up to what we've grown to be. Love the guy and been with him for years, but now I have to go. I've asked this before (in October), but now that I'm no longer in denial I'm looking for CF hosting recommendations again. I have the previous recommendations which I'm listing below. If anyone has comments about any of the hosts below, or better recommendations, please provide your feedback. I'm about to move a boatload of serous sites. So far, I've gotten recommendations for: Hostek Viviotech CrystalTech http://www.kickassvps.com/ Please let me know if you have additional recommendations or feedback on these hosts. Thanks, Robert ~| 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:357394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting
Hi All, I've got a lot of large CF sites I have to move because my host is not up to what we've grown to be. Love the guy and been with him for years, but now I have to go. I've asked this before (in October), but now that I'm no longer in denial I'm looking for host recommendations again. I have all the previous recommendations which I'm listing below. If anyone has comments about any of the hosts below, or better recommendations, please sound off! I'm about to move a boatload of serous sites. Need Java, MS SQL 2008 R2 or above, CF10 or above, and lots of real computer power for have demand. So far, I've gotten recommendations for: Hostek Viviotech CrystalTech http://www.kickassvps.com/ Please let me know if you have recommendations. Thanks, Robert ~| 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:357401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hosting... Again
Thank you all. Appreciate the input. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:357415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFLDAP socket closed error against SSL
What if you wrote it as a function and put it in a CFC? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Dan LeGate [mailto:d...@legeek.com] Sent: Tuesday, December 10, 2013 3:50 PM To: cf-talk Subject: Re: CFLDAP socket closed error against SSL I take it back... exact same code EXCEPT my code in outside the Custom Tag folder had excluded the PORT attribute, so I assume it was going to the non-SSL port and working fine. Once I added port = 636 to that code, exact same response: socket closed Again, the LDAPS (636) port is open to the ColdFusion server. I'm thinking it's an SSL issue. What steps need to be taken to ensure LDAPS communication works? Thanks! Dan On 12/10/2013 12:36 PM, Dan LeGate wrote: Here's the weirdness I'm experiencing... I have a Custom Tag we've been using for years that is called from most of our applications and authenticates them to a Sun LDAP server. We are moving to an Active Directory service, and when I attempt to do a bind against the new system, I get: An error has occurred while trying to execute query :servername.com:636; socket closed. However, if I run that SAME cfldap command in a .cfm file out in a regular web folder (i.e. not as a Custom Tag under the ColdFusion directory), it works fine! I have restarted the server to make sure any old Custom Tag code isn't somehow cached. I have verified the SSL (636) port is open to the CF server. Any ideas on this one? Very confused by this. Thanks for any feedback! Dan ~| 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:357332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Secure attribute on CF Session Cookies
Is there any way to ensure the CFTOKEN and CFID cookies include the secure attribute when sending over https? I see no way to do this on CF9. Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:357312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Secure attribute on CF Session Cookies
Thanks. That's helpful. Appreciate it. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct  125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788 T 631.231.6600 X 119   F 631.434.7022  http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: Friday, December 06, 2013 4:09 PM To: cf-talk Subject: Re: Secure attribute on CF Session Cookies On Fri, Dec 6, 2013 at 2:52 PM, Wil Genovese jugg...@trunkful.com wrote: Iè´e seen people request this before due to a PCI security audit. Usually the best solution, depending on the code, is to switch to J2EE session variables. Instead of physical cookies the session cookies are true session cookies in browser memory. This would eliminate the secure cookies issue. I think? You can create a browser session cookie for CFID/CFTOKEN cookies as well, you just have to write the cookies manually. But what Robert was asking about was the secure flag on the cookie, which indicates that the user agent should only send the cookie over a secure connection (eg HTTPS), again you have to do this by writing the cookies manually in CF9 and lower, here's an example showing how to do this: http://www.petefreitag.com/item/764.cfm For CF10 it is easy you just specify in your Application.cfc this.sessioncookie.secure = true Also with CF10 (or Tomcat rather) it will automatically add the secure flag to your JSESSIONID cookie on HTTPS requests, this causes your HTTP and HTTPS requests to be on different sessions, which for security is a good thing, but can lead to issues if you have coded your apps to expect otherwise. More info on that here: http://www.petefreitag.com/item/817.cfm -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes ~| 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:357317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Application.cfc question
I would tend to agree that you cannot do it this way because the application.cfc fires on first request. If you can use IIS (or Apache) to do your redirect before the application.cfc fires you should be able to get the ones in the subfolders to fire first, then do an include at the top of each to include the original application.cfc file to add the missing data... but I'd probably not call the one in the root application.cfc then... probably something like global_var_include.cfm or something. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMAIL - SASL
I'm trying to set up CFMAIL to use a relay server for one of my clients. The relay service says: Make sure that SMTP authentication (SASL) is turned ON I don't see any such setting in CFMAIL. Anyone know what this means? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:357059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm