RE: Enable Request Debugging Output not working
Andrew, IIS will capture CF errors and display friendly error messages if it is set to. The debugging output, however, should display regardless of this setting as, as you stated, it is not an error. I would look at the source to see if the output is being generated and simply being hidden by a code or CSS change. I know that I've had that happen to me. Also check to see that the setting in the CF admin has not changes to display the output in dockable state. If you have your browser set to open everything in new tabs, the output would be on a different tab. I would also, as Russ stated, look for CFSETTING tags that might be disabling the output. But if it suddenly stopped working, then I would suspect an unclosed tag or CSS change. Dave -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Monday, April 06, 2015 2:17 AM To: cf-talk Subject: Re: Enable Request Debugging Output not working Not to mention the display friendly error messages in IIS, is for ASP!! Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Mon, Apr 6, 2015 at 12:24 PM, Russ Michaels r...@michaels.me.uk wrote: yes that is true, however debug output is not an error, it is the debugging information that added to the bottom of a page. ~| 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:360385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: 500 error/Permission issue with IIS 7
I have run into this very issue. If I remember, it ended up being a corruption in the web.config default documents. Try rebuilding that section. Dave -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Friday, March 27, 2015 1:52 PM To: cf-talk Subject: 500 error/Permission issue with IIS 7 I have been down the rabbit hole with this all day and have not been able to figure this out. I have been all over The Google with no love. We followed the CF 11 lockdown guide and got everything working fine for 2 domains/applications. We went to set up a third domain that uses subdirectories as the root directory for seperate applications and we get a 500 error (details below) when we hit a subdirectory like so: http://www.mydomain.com/somedir/ But if I add index.cfm to the URL like below everything works fine. http://www.mydomain.com/somedir/index.cfm And, yes, the default document is set to index.cfm and the permissions for all the sub directories are identical to the domains what work (as per the lockdown guide). IIS error details Module IsapiModule Notification ExecuteRequestHandler Handler cfmHandler Error Code 0x80004005 Anyone have an idea how to remedy this situation? As always, many TIA, G! *Gerald Anthony Guido* Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba -- Horace learn.geraldguido.com Twitter https://twitter.com/CozmoTrouble Facebook https://www.facebook.com/gerald.guido.9 ~| 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:360315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can you use a CFTHREAD inside an Ajax routine?
Steven, What is it that is telling you that the thread is not running? What is it supposed to do that it is not, manipulate the file system, execute a stored procedure? Is it supposed to return a value that you are not seeing? Remember that a function that initiates a thread will continue to run without waiting for the thread to finish unless a join action is performed. Dave -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Thursday, March 12, 2015 10:49 AM To: cf-talk Subject: Re: Can you use a CFTHREAD inside an Ajax routine? When you say it doesn¹t generate any errors, do you mean that you¹ve looked through the exception logs? Unless you are trapping it with try/catch or a custom error handler, that¹s the only place you would discover that an error happened in a cfthread that you are spawning and forgetting. On 3/5/15, 3:47 PM, John Pullam jpul...@mcleansystems.com wrote: It seems to me that the CFTHREAD I attempt to start from inside an Ajax routine (triggered by a CFWINDOW) never runs and doesn't generate any error message. Can anyone advise if this is a legitimate thing to do? ~| 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:360256 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?
Seems to be OK for me. -Original Message- From: george.e...@ssa.gov george.e...@ssa.gov [mailto:george.e...@ssa.gov] Sent: Friday, January 09, 2015 8:50 AM To: cf-talk Subject: Adobe ColdFusion Blog futzed? Is it just me or is the Adobe ColdFusion Blog (http://blogs.coldfusion.com/) messed up? I go to the home page and there are only two entries, one for Jan 1, 2015, and another for December 18, 2014. Nothing else, not even links to go anywhere else. If I go to one of those two pages I then get the right sidebar with links to other pages and sections, but even if I go to the archives for each month they are incomplete. George ~| 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:359931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Trouble with ArrayAppend
Dean, This got pushed into my junk mail. What is making the call to the web service? If it is JavaScript, which it sounds like, then the result needs to be in a format that can be parsed by js. JavaScript does not understand CF objects hence the need to serialize the result or transform it to XML and parse the XML on the client side. Another option for doing that is to set the return format of the function to json, which can be done on the fly by passing the parameter into the function when a json result is required (returnformat=json). Dave -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Monday, December 22, 2014 3:28 PM To: cf-talk Subject: Re: Trouble with ArrayAppend Hi David, Yes, the tmpAddress variable is var scoped at the top of the method. I tried your suggestion of re-initializing the struct with each iteration, but it did not change the results. I've been doing some more testing and have found that, if I serialize the entire result to JSON prior to returning the data to the calling client, that the structures inside the array are populated properly. So the issue is when passing the results back as a CF struct. Again though, this is only if the CFC is called as a webservice, it works fine when called directly from a CF template. Quite odd. On Mon, Dec 22, 2014 at 9:15 AM, David Phelan dphe...@emerginghealthit.com wrote: Dean, First, is tmpAddress var scoped at the top of your function? I would try initializing tmpAddress on each iteration. for (var Address in Deal.getAddresses()){ tmpAddress = StructNew(); } Dave -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Saturday, December 20, 2014 12:19 PM To: cf-talk Subject: Re: Trouble with ArrayAppend Ok, I just tried calling the same method directly from a CF template and the structures populated properly. It is only when I am calling it as a webservice that the structs are empty. On Sat, Dec 20, 2014 at 12:10 PM, Dean Lawrence dean...@gmail.com wrote: Thanks Rodney. I was hoping that what you suggested would work, but unfortunately, it did not. I tried it in both ACF 10 and ACF 11. I'm still left with empty structs inside the array. On Sat, Dec 20, 2014 at 11:22 AM, Rodney Enke renk...@gmail.com wrote: I believe you are just passing a reference of the tmpAddress to the array, so it is being overridden with each loop. Try the following to insert a copy of the structure into the array instead: ArrayAppend(results.Deal.addresses,duplicate(tmpAddress)); - Rodney On Fri, Dec 19, 2014 at 4:39 PM, Dean Lawrence dean...@gmail.com wrote: I have a remote method which is retrieving a deal object, populating a structure and returning it to the client requesting it. This is all well and good. However, the deal object has multiple address objects associated to it. When looping over these addresses, I am having trouble adding them to an array. Here is my code: for (Address in Deal.getAddresses()){ tmpAddress.street = Address.getStreet(); tmpAddress.street2 = Address.getStreet2(); tmpAddress.city = Address.getCity(); tmpAddress.state = Address.getState(); tmpAddress.postalcode = Address.getPostalcode(); tmpAddress.phone = Address.getPhone(); ArrayAppend(results.Deal.addresses,tmpAddress); } The problem that I am having is that the results.Deal.addresses key ends up with an array of empty structures, the total number matching the total addresses associated to this deal. So in my test case, the deal that I am working on has a single address, so the results.Deal.addresses key is an array with on empty structure in it (no keys). However, if I don't try to append to the array by doing this: for (Address in Deal.getAddresses()){ tmpAddress.street = Address.getStreet(); tmpAddress.street2 = Address.getStreet2(); tmpAddress.city = Address.getCity(); tmpAddress.state = Address.getState(); tmpAddress.postalcode = Address.getPostalcode(); tmpAddress.phone = Address.getPhone(); results.Deal.addresses = tmpAddress; } The results.Deal.addresses key is now a struct and all the address keys assigned properly, so I know the tmpAddress struct is being populated properly. Does anyone have any thoughts as to what might be going on? I am running ACF 10 and yes, I have var scoped the results, Deal and tmpAddress variables at the top of the method. I also tried adding local to the Address variable in the for loop, but it did not help. Thansk, -- [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
RE: onRequestStart onRequest variable assignments
Don, You state that certain variables are being reset so then I assume that others are maintaining their values? Is there any difference in scope between those that are maintaining their values and those that are not? Is there a conditional redirect happening in OnRequestStart? Dave -Original Message- From: Don [mailto:danfar...@hotmail.com] Sent: Monday, December 29, 2014 2:19 PM To: cf-talk Subject: onRequestStart onRequest variable assignments This application I inherited, certain variables are not persisting their values between onRequestStart and onRequest. I've been writing to a log file to document the changes. Seems to be happening just after onRequestStart ends and onRequest begins. Values are being reset. So the variables themselves still exist, just their value is being altered and I cannot see where it is happening. am I missing something obvious? ~| 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:359892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Trouble with ArrayAppend
Dean, First, is tmpAddress var scoped at the top of your function? I would try initializing tmpAddress on each iteration. for (var Address in Deal.getAddresses()){ tmpAddress = StructNew(); } Dave -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Saturday, December 20, 2014 12:19 PM To: cf-talk Subject: Re: Trouble with ArrayAppend Ok, I just tried calling the same method directly from a CF template and the structures populated properly. It is only when I am calling it as a webservice that the structs are empty. On Sat, Dec 20, 2014 at 12:10 PM, Dean Lawrence dean...@gmail.com wrote: Thanks Rodney. I was hoping that what you suggested would work, but unfortunately, it did not. I tried it in both ACF 10 and ACF 11. I'm still left with empty structs inside the array. On Sat, Dec 20, 2014 at 11:22 AM, Rodney Enke renk...@gmail.com wrote: I believe you are just passing a reference of the tmpAddress to the array, so it is being overridden with each loop. Try the following to insert a copy of the structure into the array instead: ArrayAppend(results.Deal.addresses,duplicate(tmpAddress)); - Rodney On Fri, Dec 19, 2014 at 4:39 PM, Dean Lawrence dean...@gmail.com wrote: I have a remote method which is retrieving a deal object, populating a structure and returning it to the client requesting it. This is all well and good. However, the deal object has multiple address objects associated to it. When looping over these addresses, I am having trouble adding them to an array. Here is my code: for (Address in Deal.getAddresses()){ tmpAddress.street = Address.getStreet(); tmpAddress.street2 = Address.getStreet2(); tmpAddress.city = Address.getCity(); tmpAddress.state = Address.getState(); tmpAddress.postalcode = Address.getPostalcode(); tmpAddress.phone = Address.getPhone(); ArrayAppend(results.Deal.addresses,tmpAddress); } The problem that I am having is that the results.Deal.addresses key ends up with an array of empty structures, the total number matching the total addresses associated to this deal. So in my test case, the deal that I am working on has a single address, so the results.Deal.addresses key is an array with on empty structure in it (no keys). However, if I don't try to append to the array by doing this: for (Address in Deal.getAddresses()){ tmpAddress.street = Address.getStreet(); tmpAddress.street2 = Address.getStreet2(); tmpAddress.city = Address.getCity(); tmpAddress.state = Address.getState(); tmpAddress.postalcode = Address.getPostalcode(); tmpAddress.phone = Address.getPhone(); results.Deal.addresses = tmpAddress; } The results.Deal.addresses key is now a struct and all the address keys assigned properly, so I know the tmpAddress struct is being populated properly. Does anyone have any thoughts as to what might be going on? I am running ACF 10 and yes, I have var scoped the results, Deal and tmpAddress variables at the top of the method. I also tried adding local to the Address variable in the for loop, but it did not help. Thansk, -- [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:359870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Non-profit donation providers
Our hospital uses BlackBaud, used to be called Convio. http://www.convio.com/ Dave -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, October 28, 2014 2:29 PM To: cf-talk Subject: Re: Non-profit donation providers ...? https://merchant.paypal.com/us/cgi-bin/?cmd=_render-contentcontent_ID=merchant%2Fdonations On Tue, Oct 28, 2014 at 2:26 PM, Rob Voyle robvo...@voyle.com wrote: Hi Folks Any recommendations for church/non-profit online donations, especially recurring donations? Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.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:359525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail and special characters
Have you tried using HTMLEditFormat? David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: Uwe Degenhardt cf-t...@sdsolutions.de Sent: Wednesday, September 10, 2014 3:51 AM To: cf-talk Subject: Re: cfmail and special characters Hi Philipp, thanks. Unfortunately, that doesn't work either. Has anybody any other ideas ? @Philipp, can you send me one cfmail-code snippet with special characters that runs on your CF8/Linux-box as an example ? Uwe am Mittwoch, 10. September 2014 um 09:24 schrieben Sie: Uwe, try cfmail charset=utf-8... Gruß, Philipp Am 10.09.2014 um 09:17 schrieb Uwe Degenhardt cf-t...@sdsolutions.de: Hi Everybody, to be honest: I am pulling my hair out ! I have a problem with cfmail and special characters. The german umlaute seem to be displayed wrong. This is the code: cfcontent type=text/html; charset=utf-8 cfset SetLocale(German (DE))/ cfmail to=x...@xxx.com from=x...@xxx.com subject=Eine neue Datei ist verfuegbar CFMAILPARAM NAME=charset VALUE=utf-8 Sehr geehrter ..., Mit freundlichen Grüßen /cfmail I have also tried: cfcontent type=text/html; charset=iso-8859-1 cfset SetLocale(German (DE))/ cfmail to=x...@xxx.com from=x...@xxx.com subject=Eine neue Datei ist verfuegbar CFMAILPARAM NAME=charset VALUE=iso-8859-1 Sehr geehrter ..., Mit freundlichen Grüßen /cfmail Concerning the last line I always got: Mit freundlichen Gr??en instead of Mit freundlichen Grüßen I tried this on my ColdFusion 8 box with Windows. Absolutely no problem at all. When I switch to Linux (Debian or CentOS) it doesn't work. I also tried to change the charset on my linux boxes. No positive result. I tried to change the Mail Charset Settings in CF already. With also no positive results. Has anybody any other ideas ? Uwe ~| 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:359292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How can I force clients to refresh JavaScript files?
The easiest way is to simply expire the page using cfheader. Take a look at http://www.bennadel.com/blog/1619-caching-coldfusion-pages-with-expires-header-value.htm. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: =?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?= Sent: Friday, September 12, 2014 11:05 AM To: cf-talk Subject: How can I force clients to refresh JavaScript files? I wonder why browsers caching Javascript and CSS files at least do not check if the date of the file on the server is still the same as the one in their cache. Since I implemented a Javascript errors log, I catch many errors showing that the old file in the cache was used days after the error was corrected, even with Google Bot! (yeah, Google Bot reads and executes scripts). This page : http://stackoverflow.com/questions/32414/how-can-i-force-clients-to-refresh-javascript-files expose the problem and gives many solutions. I wonder if one could develop an even better solution using ColdFusion? Any ideas? ~| 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:359295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfchart in cfdocument
Sorry, I'm using cfchart. I remember looking into different charting options for another project some time ago and did find a gauge chart available so I know it's available, but do not remember where I found it. -Original Message- From: Anthony Doherty [mailto:anthony...@gmail.com] Sent: Friday, September 05, 2014 3:47 PM To: cf-talk Subject: Re: cfchart in cfdocument Are you using cfchart or an other charting option. The reason I'm asking is I'm trying to create a dashboard with 10 charts but think CF is a little limited with the chart options. Ie I'm trying to create a gauge chart Thanks Sent from my iPhone On 5 Sep 2014, at 20:30, David Phelan dphe...@emerginghealthit.com wrote: Never mind, I figured it out. I stored the images in an array and used cfimage to render them to the browser. -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Friday, September 05, 2014 3:15 PM To: cf-talk Subject: cfchart in cfdocument I am trying to creating a PDF document that contains a number of charts within (over 360). I had run the document with a simple query to produce the charts and then applied the real query. With the dummy query, the page took some time to run, but everything appeared fine in the document. Now that I have applied the proper query which produces a different chart in each location, I am getting a number of Image Expired, Please refresh the page to view the image. The bottom of the document is properly displaying the charts, but the first 40 pages display this message in place of the graph. Is it possible that I am simply trying to create too many graphs at a time and the memory can't hold them all? Do I need to write all these images out to the file system and reference them as URLs? 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:359244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfchart in cfdocument
I am trying to creating a PDF document that contains a number of charts within (over 360). I had run the document with a simple query to produce the charts and then applied the real query. With the dummy query, the page took some time to run, but everything appeared fine in the document. Now that I have applied the proper query which produces a different chart in each location, I am getting a number of Image Expired, Please refresh the page to view the image. The bottom of the document is properly displaying the charts, but the first 40 pages display this message in place of the graph. Is it possible that I am simply trying to create too many graphs at a time and the memory can't hold them all? Do I need to write all these images out to the file system and reference them as URLs? 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:359241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfchart in cfdocument
Never mind, I figured it out. I stored the images in an array and used cfimage to render them to the browser. -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Friday, September 05, 2014 3:15 PM To: cf-talk Subject: cfchart in cfdocument I am trying to creating a PDF document that contains a number of charts within (over 360). I had run the document with a simple query to produce the charts and then applied the real query. With the dummy query, the page took some time to run, but everything appeared fine in the document. Now that I have applied the proper query which produces a different chart in each location, I am getting a number of Image Expired, Please refresh the page to view the image. The bottom of the document is properly displaying the charts, but the first 40 pages display this message in place of the graph. Is it possible that I am simply trying to create too many graphs at a time and the memory can't hold them all? Do I need to write all these images out to the file system and reference them as URLs? 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:359242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Excel Problem...
Have you tried Ben Nadel's CreateXlsFromQuery? It creates a true Excel file which should be able to be opened in 2013. We are still on 2010 so I have not been able to test it but it's worth a try. The original code can be found at: http://www.bennadel.com/blog/469-creating-microsoft-excel-files-using-coldfusion-and-poi.htm. Another using XML is located at: http://www.bennadel.com/blog/917-creating-excel-files-with-coldfusion-xml-and-poi.htm. Dave -Original Message- From: Larry Lyons [mailto:larrycly...@gmail.com] Sent: Wednesday, August 27, 2014 3:12 PM To: cf-talk Subject: Re: Excel Problem... You might also try saving the output as CSV and opening it in excel that way. Its an annoying workaround but may work. AS for CF8, ask about Railo then - its FOSS, and is faster than ACF. So what is the specific error? Is it in CF or Excel. If Excel are you getting this message? Excel actually opens. So, it's an Excel error. However, it just says There's an error with no further information. I *wish* it was the error below, because then I'd have something to go on. The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? (Yes | No | Help) At this moment in time, upgrading the site in question to a new server isn't an option. I'll review the other options suggested though. Thanks! If so there's a new security feature in Excel According to this MSDN blog: http://blogs.msdn. c om/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning. aspx http://devblog.grinn.net/2008/06/file-you-are-trying-to-open-is-in. html http://stackoverflow. com/questi ons/940045/how-to-suppress-the-file-corrupt-warning-at-excel-download ~| 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:359215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: AJAX request returning 304
Donnie, I don't see a reason why a cfheader tag wouldn't work, and if it fails it's easy enough to add in the missing tags. Personally, I would convert it to a function in a cfc. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: Donnie Carvajal donnie.carva...@transformyx.com Sent: Wednesday, August 27, 2014 1:00 PM To: cf-talk Subject: AJAX request returning 304 I have an ajax request calling a ColdFusion template. Each time the ajax function is called, the ColdFusion template should return the next 20 rows of a query. I am running into an issue where the browser thinks the ColdFusion template hasn't changed since a 304 http status code is returned. I don't have an html or head tag in the CF template, so I don't believe a cfheader tag will work. Does anyone know how to prevent a CF template from returning a 304 http status code? Thanks, Donnie Carvajal ~| 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:359202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Querying a comma separated list
What I have seen done in these situations is to search where = the value or one of several like statements. where field = 'value' or field like 'value,%' or field like '%,value,%' or field like '%,value' David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: UXB denn...@uxbinternet.com Sent: Wednesday, August 27, 2014 1:46 PM To: cf-talk Subject: RE: Querying a comma separated list I assume from the example you are storing the a comma delimited list in the Field gtype and need to query all records that match one or more items from the stored list. Here are some ways to accomplish what you want to do plus some other tricks. http://www.sommarskog.se/arrays-in-sql-2005.html Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com -Original Message- From: te...@it-werks.com te...@it-werks.com [mailto:te...@it-werks.com] Sent: Tuesday, August 26, 2014 8:13 PM To: cf-talk Subject: Querying a comma separated list I haven't done this is ages and could use some help, please. Here I define a list of checkboxes of picture types: input type=checkbox name=tt value=1 cfif gtype contains '1'checked/cfifSolidbr input type=checkbox name=tt value=2 cfif gtype contains '2'checked/cfifOpenbr input type=checkbox name=tt value=3 cfif gtype contains '3'checked/cfifInsulatedbr input type=checkbox name=tt value=4 cfif gtype contains '4'checked/cfifCombinationbr At form submit I update the record: cfquery name=upcontent datasource=#dsn# maxrows=1 update pgallery set gtype = '#tt#' where id = #picid# /cfquery Now here's where I screw up: cfquery name=getslides datasource=#dsn# select * from pgallery where listContains(gtype, 1) /cfquery Here;s the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'listContains' in expression. Terry ~| 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:359204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need someone to help with site
Looks like there is a missing closing tag. If you're still having the issue I'd be glad to take a look. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: Phillip Vector vec...@mostdeadlygame.com Sent: Sunday, July 6, 2014 9:45 PM To: cf-talk Subject: Re: Need someone to help with site Brian, refer to http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358715 ~| 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:358834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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:358641 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 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:358644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't figure out a simple undefined request varible
Matt, Where is this being defined? If it is not in OnRequestStart, that's why you are seeing the error. But is there a specific reason that you are casting this in the request scope? It looks to me to be something that should be stored in the application scope. Dave -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Sunday, May 04, 2014 11:34 AM To: cf-talk Subject: Can't figure out a simple undefined request varible Getting this error: Element CFCPATH is undefined in REQUEST. at cffbx_settings2ecfm420036493.runPage(\\AWESOME-PC\wwwroot\redhotkitties_com\site_theartoflovingcatsanddogs_com\fbx_settings.cfm:8) But I have this in Application.cfc: cfset request.cfcpath = site_theartoflovingcatsanddogs_com.cfcs. Any help? Thanks! Site was working fine until I deleted my local copy and downloaded the live site to my local dev server. a href=http://www.theartoflovingcatsanddogs.com;www.theartoflovingcatsanddogs.com/a ~| 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:358565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) barcodes and mobile sites
The barcode is an image that evaluates to a string when read so you could: 1) store the string in the database and generate the barcode image on the fly 2) generate the barcode image, store it on the file system and store the path in the database 3) generate the barcode image and store it in a BLOB Dave -Original Message- From: Matthew Allen [mailto:a.matthe...@yahoo.com] Sent: Tuesday, April 22, 2014 7:07 AM To: cf-talk Subject: Re: (ot) barcodes and mobile sites Hi Dave and all, Tried posting this earlier, not sure it has gone through, here I go again: Excuse the dumb question, I fully understand how the QR code and reader works, I've built a number of QR solutions, where I use it to direct users to PDFs and videos resources, activities per file are stored in the database, as you can capture url values. I've never used barcode before, how does it work as far as storing info into a database? Especially when using those physical barcode readers or even apps Many thanks, Matt ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Printing barcode labels from CF
A number of years ago I accomplished a similar need through the utilization of a client side print ocx which allowed the user to select a printer to be used for label printing. Once they selected the printer, I was able to manipulate the required settings and query paper size information that I would pass back to my label designer and return the HTML that I would then send to the printer. It worked beautifully and the clients loved it. I do not remember the name of the control, but it was a commercial ocx. Our clients did a lot of label printing so installing the ocx was not an issue for them. I do not know how if you are intending for the client to print barcodes or not, but if this will be an administrative function it might be something to consider. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org From: Pete Ruckelshaus pruckelsh...@gmail.com Sent: Tuesday, March 25, 2014 10:23 AM To: cf-talk Subject: Printing barcode labels from CF I'm building a membership system where I will need to print barcode labels (Code128) from a CF app. I've got the barcode creation down (using a JQuery plugin), but haven't started the label creation piece. I was thinking of using CSS + cfdocument, but am concerned that PDF's crappy support of CSS will cause me trouble. Has anyone else done something like this? What do I need to look out for? Thanks Pete ~| 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:358078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: database design conundrum
That would have been my suggested approach as well. I would suggest adding a sharewithall flag to tbl_shared_things so that the user has the option. I can be tedious to individually share information that you would gladly provide to anyone who asked for it, like office email, phone and fax. It also allows that the information could be easily displayed on an open profile if desired. Dave -Original Message- From: Michael van Leest [mailto:mvanle...@gmail.com] Sent: Thursday, March 20, 2014 10:30 PM To: cf-talk Subject: Re: database design conundrum That's basically it. Depending how your would query the data is entirely up on the specific use, so that is something fun to play with. This way you have all the flexibility you need, good luck! Michael 2014-03-21 2:38 GMT+01:00 PT cft...@gmail.com: so ... tbl_users (containing things that don't need to be shared) - userid displayName archived lastLoginDate lastLoginLocation joinDate ... tbl_things_that_can_be_shared - thingid thing (emailAddress, phoneNumber, birthday) tbl_shared_things (standard join table) - (pk) userid (fk to users.userid) (pk) thingid (fk to things.thingid) (pk) toShareWithUserID (fk to users.userid) (if they are in this table, then they are shared, so no boolean is needed) tbl_user_things - (pk) userid (fk to users.userid) (pk) thingid (fk to things.thingid) thingContents (the actual contents of the things for the user in question, like 'b...@example.com', '8885551212', '01/01/1980') Then make a view of the tbl_users-tbl_things_that_can_be_shared-tbl_user_things relationships to approximate a more traditional users table for easier querying. ? On 3/20/2014 8:56 PM, Michael van Leest wrote: I would build it like this: - tbl_users (userID etc) - tbl_user_things (thing id so you can add extra things without changing the DB) - tbl_user_join_thing (userID, thingID, setting (boolean 1/0) and a optional toShareWithUserID) Hope this helps ~| 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:358061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFHTTP SSL call returns Peer Not Authenticated
I have written a page that makes an SSL web service call using CFHTTP but I cannot seem to get the service to respond with anything other than Peer Not Authenticated. I have imported the certificates for the servers into the CF keystore and restarted the CF services. I found a post relating to a similar issue, but it is an issue in CF9 Enterprise only. I tried the workaround anyway to no avail. The call is being initiated by our servers in our DMZ to servers in our internal network for which we added a permanent route to our server. I can ping the server and get the replies. I can get the WSDL from the host server through the browser on the client server, but the call through CF fail. Any help would be appreciated. We are using CF8 on a win2k8 R2 server. 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:357743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfquery multiple column search
You need to verify that the search terms you are providing for that column are numeric. The cfqueryparam does that but returns an error when it finds a problem. It's up to you to make sure that you are providing the proper type for the columns you are querying. In this case if the search terms are not numeric then you want to skip the column all together. You need to check that it is both numeric and an integer. cfquery name=getinfo dbtype=query SELECT col1, col2, col3, col4, col5 FROM getinfo WHERE (lower(col2) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col3) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col4) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) cfif IsNumeric(arguments.search) and (Int(arguments.search) is arguments.search) OR lower(col5) like lower(cfqueryparam cfsqltype=cf_sql_integer value=%#val(Arguments.search)#%) /cfif ) /cfquery David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Monday, February 10, 2014 10:04 AM To: cf-talk Subject: cfquery multiple column search All - I am working on a search functionality for multiple columns of data. I using 'OR' condition for searching on a single search input. For example on front end i have a search input box, and I can enter either numeric or alphabets or alphanumeric characters. How can I handle this using cfqueryparam? if the database column is a numeric, and I enter alphabets, I get errors like Invalid data %0% for CFSQLTYPE CF_SQL_INTEGER. I am first retreiving the full result set and performing query of queries to filter on the search criteria. my query of query looks like below. The above error happens on col5 search when I search string characters like 'abc'. Are there any functions in coldfusion that help with this kind of scenarios? cfquery name=getinfo dbtype=query SELECT col1, col2, col3, col4, col5 FROM getinfo WHERE (lower(col2) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col3) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col4) like lower(cfqueryparam cfsqltype=cf_sql_varchar value=%#Arguments.search#%) OR lower(col5) like lower(cfqueryparam cfsqltype=cf_sql_integer value=%#val(Arguments.search)#%) ) /cfquery ~| 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:357652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: per application settings
Eric, I think that you are being too insistent about what you think CF should be doing and not thinking about the actual logic of rendering a web page. As has been stated too many times in this thread, CF does not process anything but CF tags, CFScript and anything that is within cfoutput tags that also contains something surrounded by #. Simply putting the image tag inside of cfoutput tags will not force CF to evaluate what it considers to be plain text content. The precursor to Cameron's explanation is: 1) Web server receives request for cfm/cfc 2) Web server passes request to CF for processing 3) CF parses the file and returns the HTML to the web server 4) Web server returns HTML to the browser 5) Browser parses the HTML 6) Browser makes further requests to the web server for the required resources (js, css, images etc) 7) Continue with Cameron's response You need to accept the fact that CF WILL NOT interpret anything that is not a CF tag, script or variable and accept that there is something else that is causing what you are seeing. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Tuesday, November 26, 2013 8:35 PM To: cf-talk Subject: RE: per application settings I think we are focusing on the actual image too much here...I am talking about the path to the image. So this is before anything gets served... Eric -Original Message- From: Phillip Duba [mailto:phild...@gmail.com] Sent: Tuesday, November 26, 2013 6:37 PM To: cf-talk Subject: RE: per application settings No it wouldn't. Its being served and called through the browser, that's why you can view it directly. The scenario Cameron describes is very close to what happened to me 2 weeks ago with a mapping, Phil On Nov 26, 2013 6:15 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Thank you Cam...now this .png is getting called from a cfm page (header.cfm ) So wouldn't the application.cfc be applied? -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Tuesday, November 26, 2013 4:48 PM To: cf-talk Subject: Re: per application settings On Tue, Nov 26, 2013 at 3:23 PM, Eric wrote: img src=/cup/images/image.png / Here's what MAY be happening here. In the case of a CFAdmin mapping: 1) Apache gets request for /cup/images/image.png 2) Apache says no such file! what say you JRun (CF9 right?) 3) JRun says: Hey! This aint no CFM file! Let's not run Application.cfc on it! 4) Then JRun says: Hey! I have a serverwide mapping for that! Awesome! 5) File gets served. In this case, the Application.cfc never executes. JRun knows about the mapping and it serves the file. Now, move that same mapping inside Application.cfc then: 1) Apache gets request for /cup/images/image.png 2) Apache says no such file! what say you JRun (CF9 right?) 3) JRun says: Hey! This aint no CFM file! Let's not run Application.cfc on it! 4) Then JRun says: I don't know nuthin about this stinking file! 5) Four Oh Four. You got served. Dance off over. Drops mic. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem with data formatting in CFINSERT
It's been a long time since I've used Access, but if I remember correctly the currency data type only accepts 2 decimal places. You need to make sure that the data that you are supplying only has 2 decimal places. It is impossible to determine where the extra decimal places are coming from in your example as there is no indication of how that value is being derived. My expectation is that there is some kind of calculation being performed and then assigned back to the form field being applied to the cfinsert. IMHO, I would not employ the use of a cfinsert tag. Although it makes inserts simpler, it removes the programmers ability to define the field data type expected and perform data type validation using the cfqueryparam as well as allowing me to apply any formatting I desire to the value that is ultimately submitted to the query for insertion. David Phelan -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Sunday, November 03, 2013 9:40 PM To: cf-talk Subject: Problem with data formating in CFINSERT Hi, Weird problem this morning. I have a CFINSERT which fails in an Access database with an error [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. First, there is no criteria since it's only an insert. Second, I get the error with a value of 57.49 in a certain field, but entering the valu 57.50 works perfectly! In the error message I can see for this field: param 18) = [type='IN', class='java.math.BigDecimal', value='57.49198951966012828052043914794921875', sqltype='2'] Could it be that 47 decimal is too much for a java.math.BigDecimal or an Access Currency column? And if yes, who is adding all these decimals? ~| 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:357023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Saving updated sort order in mysql jquery list to update database
If you want to build the array in jQuery then you can do something like the following: arIDs = new Array(); $(input[name='ID']).each(function(){ arIDs.push($(this).val()); }) David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: te...@it-werks.com te...@it-werks.com [mailto:te...@it-werks.com] Sent: Wednesday, September 25, 2013 7:43 PM To: cf-talk Subject: Saving updated sort order in mysql jquery list to update database I have a cfm page that displays a drag and drop ul list and I do not know how to create an array of that sorted list to the mysql database. Any help would be greatly appreciated. I am new to the jquery, jquery-ui plugins, but loving it all so far. Thanks in advance, Terry ~| 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:356850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Element undefined in SESSION scope
What is your session timeout? Are you setting it in your cfapplication tag or relying on the server settings? Is it possible that the timeout is too small and destroying the session before the form can be submitted? David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Priya K [mailto:priya23...@gmail.com] Sent: Tuesday, August 06, 2013 8:35 PM To: cf-talk Subject: Re: Element undefined in SESSION scope May be its something to do with cookie path. If you are using cookie, this might mess up your session and just drops it. On Tuesday, August 6, 2013, Mark A Kruger wrote: Trying a resend. Make sure that cgi.http_referer exists before you try to set it. This is a var created by the web server NOT cf ... so it may or may not reliably exist. Also make sure this code is AFTER your cfapplication tag. On your own system try hitting the page after a cf restart. You may be trying to access the session before you have established a session. The reason it works on local is because during coding you established a session at some previous point. That's all I got :) -Mark ~| 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:356416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfthread execution slowdown
What I see is that the server load remains pretty consistent, it's the number of requests completed that is dropping. This could be an indication that the pages become more complex as the process continues, or it may indicate that the faster running threads are all completed leaving the longer running threads at the end. My suggestion would be to do some time monitoring on the loops. I think you'll find that the average completion time for each thread increases as the number of completed requests decreases. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Money Pit [mailto:websitema...@gmail.com] Sent: Friday, July 26, 2013 12:41 PM To: cf-talk Subject: cfthread execution slowdown I need another set of eyeballs on this. I can't see what I'm doing wrong. I'm building many thousands of static pages. I turned to cfthread to speed things up. Each thread can output one page or more than one depending on info retrieved. I use an array to manage the number of threads in use at any one time. It works great, but I am seeing CF slow down - in fixed stages - throughout the life of the process. Take a look at this image taken from FusionReactor to see what I mean: http://205.210.189.205/images/screenshot081.jpg Its not a curve but rather three distinct stages of output. Stage 1 is about 2900 pages per minute, Stage 2 is around 2400 and Stage 3 - where the routine stabilizes - is about 1200. On a second server building differently-composed pages, I see exactly the same thing. CF isn't bogging down from load... its flat out not working as hard. Its as if it decided it didn't want to work as hard, so it eases off. Never seen anything like it. Here's the code in a nutshell. Can anyone see something I am doing that is causing this work slowdown? cfset variables.threadArray=arrayNew(1) cfset variables.threadCount=4 cfquery name=getData datasource=#variables.dsn# [sql goes here] /cfquery cfset variables.loopCounter=0 cfloop condition=variables.loopCounter LT getData.recordCount cfset variables.threadsLive=arrayLen(variables.threadArray) cfif variables.threadsLive lt variables.threadCount cfset variables.loopCounter=variables.loopCounter+1 cfset variables.thisThreadID=createUUID() cfset temp=arrayAppend(variables.threadArray,variables.thisThreadID) cfthread name=#variables.thisThreadID# action=run !--- cfhttp pulls local CF pages and stores as html, queries determine if child pages need building etc. --- cfset temp=arrayDeleteAt(variables.threadArray,arrayFindNoCase(variables.threadArray,variables.thisThreadID)) /cfthread !--- may or may not do a cfthread join if I want to retrieve variables from inside of the thread --- /cfif /cfloop -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.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:356333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Client wants CMS that functions similar to Joomla, for example
Rick, As a developer who has recently become involved with CMS environments, let me assure you that the introduction of a CMS by no means indicates that a developer is no longer required. I actually work full time supporting a number of web sites that all run from a CF based CMS and recently started supporting one that runs in WordPress. Even with our licensed CF CMS specifically developed for the healthcare industry, the functionality OOTB does not always meet the requirements of the end users and I find myself quite busy reworking, rewriting or introducing functionality so as to meet the requirements of the users and content managers. The point of a CMS is to get the tedious job of content updates out of the hands of developers and into the hands of those who know what they want to change. I am quite happy developing or enhancing functionality for the site rather than making the endless, often minor, content changes that the client wants. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, July 23, 2013 4:26 PM To: cf-talk Subject: SOT: Client wants CMS that functions similar to Joomla, for example Hi, guys... Just need some recommendations from some of you who have been down this road before. I have a client that is asking for what amounts to absolute control over their site through a CMS. Among a few others they metioned, Joomla was brought up. I'm checking them out myself, but wanted to cut to the chase based on experience from those who have used CMS's that provide control such as Joomla. What have you tried? What turned out to work well? What bombed? I've always rolled my own, and never used a ready-made CMS, so I have zero experience with them. (Joomla seems like it replaces me as a designer/developer, at first glance. If a client has a CMS that allows them to do everything that I do for them now, including selecting themes for pages they add to the site themselves (designer), manage data through Joomla functionality (developer), I wonder if I would end up as a Joomla Installer Maintenance person for the client. ???) Thoughts? Suggestions? Thanks for any feedback! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Client wants CMS that functions similar to Joomla, for example
Rick, Most full-blown CMS solutions allow the clients to add pages to a site whenever desired, they simply select the underlying template (that you develop and provide) for that particular page and go to town creating the content and adding web parts into the areas that you have defined in the template. A WYSIWYG editor is a key ingredient and there are several open source ones out there. I use TinyMCE which is rather simple to configure and provides a good number of options and plugins to choose from and the new version allows for inline editing of the content, though it doesn't sync with the applied CSS to allow users to see the formats they are applying. The ability to upload graphics and documents is also important. Another important thing is allowing the client to preview the updated content within the context of the site before they publish it. This way they can verify that the changes they have made fit the sites theme and layout and correct anything that falls outside the acceptable limits. Inline editors are good for this but there are other approaches as well. You want to give them the freedom to alter the content to the greatest possible extent so that you can focus on developing new functionality/web parts for them to incorporate into their content, especially now that there is an ever increasing number of sites that will allow companies to create their own sites for relatively low cost. You certainly don't want to constrain your client to the point that they move on to another option. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, July 24, 2013 1:42 PM To: cf-talk Subject: RE: Client wants CMS that functions similar to Joomla, for example Thanks, Jon and everyone for your feedback. I've look at the various pre-rolled CMS offerings and have found them to be serious overkill for all my clients. I've always created my own CMS for each website I created to insure that clients were comfortable with them. Mostly, I just provide a regular form (never even used CKEditor) and take care of the styling in advance to keep them from destroying the look of their site. They just update verbiage and images. The reason I asked about full-blown CMS options, is that I've got one more sophisticated client who wants, basically, to be able to change everything. Well, she might as well become a website designer to be able to manage everything on the site, including header graphics, etc. I've been tinkering with CKEditor and think that will be a good option for the global site manager or custom CMS I'm building for my clients currently. I can control the options on the toolbar to keep clients from getting too creative, but make it easy for them to add links, etc., with knowing how to code them. I can keep the CKEditor instances distinct for every form field to accommodate database interaction so I can re-purpose content for email newsletters, etc., and avoid having all content titles, bylines, details, and images all contained within a single database field. I'll have to discuss just exactly what this new client means by control everything on the site. Turning over complete layout and design control to a novice to change the design of a corporate site with my name associated with it is not an option I want to pursue. If she wants that much control, then I'll just consult with them and she can buy a copy of Dreamweaver and use it as a WYSIWYG editor. She wants to be able to add pages to the site, as well, so I may have to develop that functionality, along with on-the-fly menu adaptation for the new pages. Maybe I can just convince her to let me create a new page when she needs one and then turn her loose on the content. It starts to be annoying and a lot of trouble (for which the client doesn't want to pay, typically) when they want to start wanting to get into the kitchen of the website design development restaurant, rather than just placing their order and allowing the chef to do his work. Any other thoughts and/or feedback is still appreciated! Rick -Original Message- From: Jon Clausen [mailto:jon_clau...@silowebworks.com] Sent: Wednesday, July 24, 2013 11:25 AM To: cf-talk Subject: Re: Client wants CMS that functions similar to Joomla, for example I've spent about 70% of my time over the last 5 years developing in PHP, including developing a customized installation of Joomla for a radio station client that included live streaming and audio archives. I've also rolled a customized CMS through the PHP framework Kohana. I, for one am happy to let go of the content updates and the radio station
RE: Question about session management
However, there is no reason to have an application.cfm file in your login directory as CF will move up the directory tree until it finds an application.cfm file and use it. David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: DeMarco, Alex [mailto:alex.dema...@suny.edu] Sent: Thursday, July 18, 2013 8:31 PM To: cf-talk Subject: Re: Question about session management Ahh okay thank you! - Alex Original message From: Dave Watts dwa...@figleaf.com Date: 07/18/2013 8:29 PM (GMT-05:00) To: cf-talk cf-talk@houseoffusion.com Subject: Re: Question about session management If I have a path: /inetpub/myapp In /myapp I have an application .cfm in it has a application name of MYAPPNAME with a sessiontimeout of 30 minutes But in /inetpub/myapp/login I have another application.cfm with an application name of MYAPPNAME with a sessiontimeout of 30 minutes Will CFMX create 2 sessions per visitor? No, because both directories' Application.cfm files contain the same application name. Dave Watts, CTO, Fig Leaf Software 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:356241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
index.cfm being copied from site root to cf web root
I have an odd issue occurring on my server. Occasionally, the index.cfm file from the root of my web site is being copied over to the web root in the CF directory. Once that happens, CF will then attempt to execute that index.cfm file which, of course, throws an error because all of the references are broken. Has anyone ever seen this? Any idea how to correct it? CF MX 7 IIS 6 Windows 2003 R2 SP2 David Phelan Web Developer IT Security Web Technologies Emerging Health Montefiore Information Technology 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/ [cid:image001.png@01CD05E4.967206B0] ~| 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:356234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfmail to Exchange using TLS
I am developing a solution for my company to be able to send email from our CF 8 application using TLS for security reasons and have a couple things that I would like to get clarified. I looked at the headers of the emails sent by my solution and I noticed that the transfer encoding was only 7 bit. The certificate that we are using on the development box is self signed so I am hoping that is the reason for the low encoding level, but I'm not sure. What I would like to clarify is the following: 1. Is the self signed certificate the reason for the encoding level? 2. Will a genuine certificate from a reputable source improve the encoding level? 3. Do I need to install a certificate somewhere in ColdFusion? 4. Is this a limitation of the CF 8 cfmail tag? 5. Is this something that needs to be addressed on the Exchange server? 6. Am I off the mark on this completely? I have no experience sending secured email from CF so any help or advice would be appreciated. TIA -- David Phelan ColdFusion/Flex Application Developer phelan.dav...@gmail.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:351315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm