ColdFusion

Howdy!Just wanted to share in case this could be of use to anyone else.After installing Update 18 onto a ColdFusion 11 server, any page that called cfhtmltopdf would error. This did not happen before update 18. Sandbox Security is enabled. No errors during install of update 18, at least according to the install log.In order to get cfhtmltopdf working again I had to add the following two items to the ColdFusion sandbox (to the Files/Dirs area for the website's sandbox).     {cf.root}/cfusion/lib/jetty.xml => read     {cf.root}/cfusion/lib/configure_9_0.dtd => readBefore I did this the first calling of cfhtmltopdf would give the following error message:access denied ("java.io.FilePermission" "{cf.root}\cfusion\lib\jetty.xml" "read")Any subsequent callings of cfhtmltopdf would give the following error message: Could not initialize class coldfusion.document.webkit.PDFgRequestUtilAfter adding {cf.root}/cfusion/lib/jetty.xml to the sandbox (and r

HiI'm trying to find out what versions of Oracle will work with ColdFusion 11.  We're looking to upgrade Oracle 10g to Oracle 12.1, 12.2 or 18c.I couldn't find anything in the specifications about whether later versions of Oracle will work.  Upgrading CF is not an option at the moment.ThanksKarl

Hello,i've juste updated my CF 2018 Enterprise server with the update build 2.BUT there's a problem now with the "cflayout" and "cflayoutarea" when you take the example on ColdFusion Help | cflayoutarea copy into a blanc page and test it, you will see the problem.the TAB's are not shown but only scroll bars vertical and horizontalCan anyone help me?

I have a simple query for a list using checkbox :<cfloop query="getlist">#thingstodo# : <input type="checkbox" name="thingstodo" value="<br/>#thingstodo#"> <p></cfloop>So it will apear like this :Some list of things to do 1 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 1"> <p>Some list of things to do 2 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 2"> <p>Some list of things to do 3 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 3"> <p>Some list of things to do 4 : <input type="checkbox" name="thingstodo" value="<br/>Some list of things to do 4"> <p>My problem is it adds a coma at the end and this is how it looks in the database :<br/>Some list of things to do 1,<br/>Some list of things to do 2,<br/>Some list of things to do 3,<br/>Some list of things to do 4,

I've been told that under Standard and Enterprise ColdFusion  is it prohibited to deploy a SaaS application:license point:2.6.4 Prohibited Use ...c) providing use of the software in a computer service business, third party outsourcing facility or service, service bureau agreement, time sharing basis, or as a part of a hosted serviceThe only way to use ColdFusion for a SaaS application (meaning charging a license fee for each customer using the same application), the only way is to negotiate a Coldfusion Hosting Agreement based likely on a percentage of your business profit.Is this true? does anyone have experience with this?This is a serious issue that could change a lot a startup financial situation and forecast.Thank you for your input on this

I get a Connection Failure when executing scheduled task on coldfusion localhost. Earlier I used to get the error on the Linux servers and resolved it by importing the app certificates into the java keystore. But this is something new and baffling. Any help is appreciated. Thanks.

I have a datagrid which shows data for the columns named username, role, gender, emailid, password. I want to add a delete button to every row in datagrid so that when it is clicked only that entry gets deleted from database.[Using COLD FUSION]

I use cache throughout my site. I am using CachePut, CacheGet,... Since I updated to update 17 I can see that cache gets flushed every couple of minutes even I have set it up for day or longer. Cache is getting created on first call and after refreshing the page content is written from cache. But after couple of minutes cache is flushed and everything starts from beginning. Not sure if there ia any settings that I missed. The code didn't change and it was working for years. I updated to update 18 restarted the server but the issue is still there. What can caused the cache to be flushed? Thanks. Slaven

After installing the latest update hotfix 15 (see ColdFusion 11 Update 15 ) on our coldfusion 11 server (Win 2008 R2 with latest patches and latest java jdk) the CF server restarts (access to CF admin is working) but the CF ODBC service does no more start. After un-installing the update it works again. Any idea how to fix this? Is this a known issue?

Hi All,I have the next command cfexecute in CF11<cfexecute name="#app_dir#resources\oracle_instantclient\sqlldr.exe" timeout="10"                        arguments='userid=sampleDB/\"mypass\"@//10.230.44.7:1521/sampleDB control=#app_dir#upload\importME.ctl log=#app_dir#upload\importME.log'                         errorVariable="errorReport">                    </cfexecute>The sql loader is working but I have an issue with security because i am including the DB password in my cfc page. Is there a way to use the CF admin data source Oracle connection here? OrIs there a way to encrypt the password in the cfexecute?ThanksJohnny

Hello, all,I am waiting for a customer to respond to a request, and thought I'd play around, for a bit, while waiting.  (Sometimes, these waits can go for days.)I was thinking about something I had learned in Javascript a long time ago, and wondered if I could do the same thing in CF:  a dispatch table.Here is an example of a JS dispatch table:<a href="javascript:void(0);" alt="This is title one." id="title1" class="test">One</a><a href="javascript:void(0);" alt="This is title two." id="title2" class="test">One</a><a href="javascript:void(0);" alt="This is title three." id="title3" class="test">One</a><div id="testText"> </div><script> // Pretend I'm loading jQuery    $(".test").click(function(){        var divAlign = {            title1:function(){$("#testText").css('textAlign','left');},     &

Hello, all,CFCs.  Some of us love them (I DO), others not so much, maybe.  But I'm curious about something.I recently posed a plea for help while just learning if something were possible in CF:  a dispatch table.Basically, a dispatch table is an object that can perform boolean comparisons, much like a switch/case, but there's no string comparison - you drill straight to the object property.Which, now, makes me wonder.  Is a CFC like a dispatch table (the various CFFUNCTIONs are properties of an object, ie the CFC), or more like a large switch/case (the various CFFUNCTIONs just the equivalent of <cfcase value="myFunctionName">...</cfcase>, in which string comparisons are performed in order to get the correct code)?Just curious.V/r,^ _ ^

Something has changed with how the cfexchangecalendar tag interacts with the Exchange server but I don't know what!Up until last week if I passed in a structure like this to the Exchange server everything looked good:This week however when I pass in a structure like this 6 hours is added to the start and end time of the event.  That and the message is displayed as text and is no longer rendered in HTML.  Any ideas as to where to look for what changed?My code to invoke the exchange connection looks like this:<CFEXCHANGECONNECTION ACTION="open" USERNAME="#MyName#" PASSWORD="#MyPwd#" SERVER="#MySrvr#" MAILBOXNAME="#MyMailbox#" PROTOCOL="HTTPS" PORT="443" SERVERVERSION="2010" CONNECTION="MyConn"><CFEXCHANGECALENDAR Action="create" Connection="MyConn" event="#MyStruct#" result="theUID"><CFEXCHANGECONNECTION action="close" connection="MyConn" />The structure being passed in is shown above...  but I'll bet you noticed that. As a band-aid, when I create my stru

I can't seem to connect to RDS running on the local machine using CFB2018.  It's CFserver 2018 and neither a password nor no authentication works.Any guidance would be appreciated.  See this screenshot for more info:  03.13.2019-13.44.52

Hi, I have a stack coldfusion2016 x32 + apache24  x64 on windows 2008 x64 server ... If I execute the installer coldfusion2016 x64, it will upgrade automatically the coldfusion2016 x32 version to coldfusion2016 x64 version, preserving x32 version settings ?mayb a silly question but ... thanksMauro

Hello everyone, I'm wondering if anyone can tell me pros/cons of either of these two functions? Which one is preferred and if there is any difference in performance/security, etc? I used arrayContains() thinking it's better/faster for validations some fields on the back end as well as reducing number of lines in situations like this:<cfif userAccess eq 1>       <!--- Do something ---></cfif><cfif userAccess eq 4>      <!--- Do something ---></cfif>Instead I used this:<cfif arrayContains([1,4],userAccess)>     <!--- Do something ---></cfif>​Would listFind() or listContains() ​be better fit in this case or not? Please if anyone have information about the differences let me know. Thank you.

I have function that should save some form fields. This function is able to process multiple insert rows. So far I was able to create logic to handle this but the only issue so far I have once user tries to save the record. The server response looks like this:The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. coldfusionAt first I was looking and trying to find which value is not defined/missing in my function but so far I couldn't detect the issue. The next thing I did was commenting out the cfquery. After that I was getting message Form successfully saved.. This tells me that my code is breaking inside of the cfquery tag. Here is example of my code:<cffunction name="saveRecords" access="remote" output="false" returnformat="JSON"> <cfargument name="formID" type="string" required="true" default=""> <cfargument name="status1" type="st

Hi,I recently installed a wildcard SSL certificate on our domain artgalore.ca.Soon after, I started to get support emails from customers to say they could no longer access the site because of a 403 error, as seen below.  When I turned off my anti-virus software, I was able to access the site.  I searched a couple of forums for specifics, nothing seems to be working.Any help is appreciated.Arny

Hello, all,While still hoping for a fix from u15, we have applied u18 to one of our servers in production and are now getting the following:"Diagnostics: The ValueList() function has an invalid parameter: getarchiveyears.articleYears. Parameter 1 of function ValueList which is now getarchiveyears.articleYears must be pointing to a valid query name.The error occurred on line 323."Earlier in this document, we have:<cfquery name="getarchiveyears" datasource="#application.newsdsn#" cachedwithin="#CreateTimeSpan(0,0,10,0)#">    SELECT        DISTINCT TO_CHAR(TitleDATE,'YYYY') articleYears    FROM        news_2016    WHERE        TO_CHAR(TitleDATE,'YYYY') > '2009'    ORDER BY        articleYears DESC</cfquery>So, there's a valid query, named (oddly enough) getarchiveyears.The line

Good Afternoon,I am a Systems Engineer and need some help. Whenever I disable TLS 1.1 on the ColdFusion 2016 server (running on Windows 2008 R2 Operating System), I can no longer communicate with the SQL Server and receive the enable TLS 1.0 and TLS 1.1 error message instead of the web page.For Security reasons, we want all communication to be on TLS 1.2. Once I disable TLS 1.1, I cannot even load a webpage on the local ColdFusion Server without receiving the TLS error.I have asked the Developer to update the SQL JDBC Native Drivers, the CF 2016 Server is using native SQL Server driver v2011.110.7001.00 dated 8/15/2017.The java version CF 2016 is using is jre 1.8.0_191.The SQL 2012 Server is using native SQL Server driver v2011.110.7462.06 downloaded on 1/6/2018. SQL Server 2012 Management Studio version is 11.0.7462.6.From what I have read it keeps pointing me back to the native SQL drivers. I have ensured the Windows side of the servers are 100% up to date with all applicable Windows

I installed the developer version on Windows 2008 R2 with IIS 7.5.I ran the web connector to connect IIS 7.5. I see the new mappings in IIS so I'm assuming the connector worked ok. My problem is when I try to access the CF administrator. I can still only access it using the built-in web server url of http://127.0.01:8500/CFIDE/administrator/index.cfm.Once I run the web connector to connect to IIS, should the administrator be running out of IIS instead of the built-in web server?

If have some code that sets multiple Locales --><cfset currentlocale = SetLocale("English (Canadian)")><cfset currentlocale = SetLocale("English (UK)")><cfset currentlocale = SetLocale("English (US)")>In-between these different settings I have #LSCurrencyFormat(GetTotal.TotalValue)#This displays the currency and the appropriate currency sign.The question I have is how would I do this for Europe as I now have a need to support Euro'sThanksMark

Hello,I need to take the value submitted in a form and add 99 to it. I first tried:<cfset channel.type = 'Form[P#c#Channel]' + 99>That failed since the form value is a string not a number.Then I tried:<cfset channel.type = LSParseNumber('Form[P#c#Channel]') + 99> and got Form[P1Channel] must be interpretable as a valid number in the current locale.How can I change the submitted value to a number that I can perform addition on?Thanks!Gary

Hi,We migrated from CF10 to CF2018 and our CFSCHEDULE tag will not now add a task. Our code is simple, just:  <cfschedule action="UPDATE"              task="test"              group="test"              operation="HTTPRequest"              startdate="#DateFormat(Now(), "mm/dd/yyyy")#"              startTime="#TimeFormat(DateAdd("n", 2, Now()), "HH:mm")#"              url="http://127.0.0.1/test/somescript.cfm"              interval="once">Whatever we try, the task is never added to the CF-Admin. No errors in the logs. The /test fo

In my application.cfc file I have the following code:this.mappings["/includes"] = "#expandPath('../../priv/inc/')#";and then on a page I have the following CF include set up:<cfinclude template="/includes/imageOptimise-thumbnail.cfm">For the majority of the time when the page is submitted the imageOptimise-thumbnail page runs without any issue but occasionally it will error saying that it can't find the imageOptimise-thumbnail.cfm. If I resubmit the page, chances are it will work but the question is, why is it sometimes not being able to find the page?I had a look in the CF Admin and I can't see anything in the logs saying that there was an error but it is clearly showing a Coldfusion 'template not found' error message when it fails.Anyone got any ideas?