ColdFusion

The organization I work with has locked down the server so you cannot use a browser on it at all and locked down the browsers on all machines so you cannot include a port number in your http request.  Until CF11/2016, this was not a problem as I just mapped a virtual directory to CFIDE and could access the administrator there.  Since CF11, I have not been able to map to cfide/administrator.  When I try I just get an error 500.  Does anyone know a work-around so I can still map the CFIDE to get to the administrator's console?

After update is applied, receive for cfchart.  What does this update do with the /CFIDE/scripts/ajax files?jquery/jquery.js is one of the files in this folder.SCRIPT438: Object doesn't support property or method 'addEventListener'File: jquery.js, Line: 3, Column: 147

I've been using Allaire's old CF Studio 3.1 ever since I started using CF in 1995. I love it. It's simple. It's perfect. All of the sudden, my mouse no longer can highlight/copy/paste inside of it. Nothing is wrong with the mouse, although I uninstalled and reinstalled it. I can highlight/copy/paste in all other applications, and have had no problem in the past. I'm using Windows 10, however have not recently installed any service packs or any other major changes. There is simply no discernible reason why the mouse can't highlight text. Even more confusing, the mouse *does* work on the toolbars.  And yes, I did uninstall and reinstall CF Studio. No luck.So.Rather than beat my head against a wall, I decided to give Adobe ColdFusion Builder 2016 a try. It has a million features I'll never need, and missing some crucial ones:No "Save All" iconfiles that have been changed simply have a little "x" next to them, rather than a red highlightevery file has an annoying Toolbar at the top ta

Hi Team,We are using cold fusion 2016 release. We are facing an issue when we using the output parameter in cfstoredproc. We are getting a error message like: We are using DB as sql server 2012 and the same sp is working fine in the sql server.Please provide some hotfix so we can fix this issue. Thanks and regards,

Hi Team,We are using cold fusion 2016 release. We are facing an issue when we using the output parameter in cfstoredproc. We are getting a error message like: We are using DB as sql server 2012 and the same sp is working fine in the sql server.Previously the same code is working on coldfusion 7 and now out platform is upgrated to coldfusion 2016 release.Please provide some hotfix so we can fix this issue. Thanks and regards,Anirban Saha

I would like to display a monthly loan payment chart/table that shows payment amounts for various interest rates and loan amounts. The output table will have 9 columns (the first column will be the user-defined loan amounts) and 32 rows (the top row being the user-defined interest rates). I have created a master database table that is 30 columns by 992 rows and includes all of the payment amounts:I want to allow the user to select a starting interest rate and the increments in which it increases. For example, starting rate of 4.000% and increase increments of .125% (so the top row/header will be 4.000% | 4.125% | 4.250% | 4.375% | 4.500% | 4.625% | 4.750% | 4.875%). Additionally, the user would define the starting loan amount and the increments in which it increases (so the left column might be $200,000, $210,000, $220,000 and so on). I'm trying to accomplish an output like this:I have been using CF for a number of years, but my knowledge is limited to more simple functions. I started

SELECT #tonsn#.OtherNumSysName, #tonsnn#.OtherNumSysNum, #tonsnn#.ID  FROM #tonsnn# LEFT JOIN #tonsn# ON #tonsnn#.OtherNumSysName = #tonsn#.ID  WHERE #tonsnn#.mainID=<cfqueryparam value="#URL.which#" cfsqltype="cf_sql_integer">  ORDER BY #tonsn#.OtherNumSysName;What's up with this?

I'm evaluating Builder as a replacement for DW. In Preferences => Coldfusion => Profiles => Editor => Typing Auto-Close I have "When typing '</" of end tag selected.If I put in the end tag immediately after the beginning tag it works okay. I often don't do that. I have a segment of code I was modifying that started with a <cfif>, has 2 lines of <cfif> statements, each supplying the closing tag correctly but Builder won't supply the closing </cfif> at the bottom of this. ??

Hi,     I am trying to read an Excel file using CFSPREADSHEET. This file has been created using the CFFILE ACTION="WRITE" tag. However every time I try to do this I get an Exception that says "An error occurred while reading the Excel: java.lang.IllegalArgumentException:  Your InputStream was neither an OLE2 stream, nor an OOXML stream."      I created a duplicate of the Excel file manually (copy-paste) and I was able to successfully read the duplicate Excel using the CFSPREADSHEET tag. When I checked the properties of both the original and duplicate excels, there was no difference except for their size. The one that was created using the CFFILE ACTION="WRITE" option was 12 KB and the duplicate was 24 KB.      Could some one please let me know why I am getting the exception when trying to read the Excel using CFSPREADSHEET and how I can overcome it.Thanks in advance

Has anyone installed Coldfusion 2016 Standard on Mac Server App 5.2 using operating system 10.12.2 Sierra ??I was running Coldfusion 9 on Mac OS X Snow Leopard Server.  This was on an Xserve.  It took quite a lot of time and trouble getting the right fixes but it finally worked.  Only, after much troubleshooting and effort.In fact, I never really got the secure site(https://site) working.  It was too much trouble with Apache and Coldfusion bumping heads all the time.The newer versions should have some of the trouble reduced.I'm all ready to go just don't seem to have a clear instruction on how to go about it.

Hi,We are obtaining the ColdFusion 11 download from the adobe licensing site. And there is one version ColdFusion Ent 11.0 ALP ESD ALL.How do we know, if  this has all the latest updates and hotfixes bundled in this version?Thanks,Aruna.

I'm getting this error when trying to add a new subscriber to Mailchimp list. What am I doing wrong?{"type":"http://developer.mailchimp.com/documentation/mailchimp/guides/error-glossary/","title":"Invalid Resource","status":400,"detail":"The resource submitted could not be validated. For field-specific details, see the 'errors' array.","instance":"","errors":[{"field":"","message":"Schema describes object, NULL found instead"}]}<cfhttp url="https://us9.api.mailchimp.com/3.0/lists/{list_id}/members" method="POST" username="xxxxxx" password="xxxxxxxxxxxxxxx-us9">            <cfhttpparam name="output" value="json" type="url">            <cfhttpparam name="method" value="listSubscribe" type="URL">            <cfhttpparam name="email_address" value="test@mail.com" type="url">     

There are two large issues I have experienced with ZingCharts. To begin, I will list the two errors I am experiencing, how to cause them, and how to fix one of them.So, the two errors:Plot point tooltips unbind. This error occurs when you have more than one chart on a page and you use AJAX to reload one of the charts. When the page first loads, the tooltips will work on both charts. After you have used AJAX to update one of the charts, that chart's tooltips will work, the tooltips for the other chart(s) on the page will no longer function.After an AJAX update on a chart, the chart fails to load and only a white block is rendered. This error will only occur after the first error has been fixed and at least one chart on the page has a visible crosshair-x attribute. After you use AJAX to update one of the charts, that chart will fail to render and will just be an empty block.The causes:When ColdFusion uses the <cf/> tags, in this case <cfchart/>, it automatically injects the n

I have 2 questionsI am upgrading a server from ColdFusionMX to ColdFusion2016, Installed ColdFusion2016 in C:, to mimic the settings in old environment1. I need set move wwwroot folder with CFIDE in to E:InetPub folder2. Set the E:\InetPub\WWWROOT as  application root instead of default C:

Hello, all,Just curious:  In ColdFusion, why does an array have a length, but a struct has a count?  You can take an array and getarrayLen(array), but you can'tstructLen(struct), it has to bestructCount(struct).No biggie.. just curious.V/r,^_^

Hope we have some true regexp guru here...Here's a question. I have the following list.list = "id,option9,option10,option11,option12,option13,option14,option15,orderno,option10txt,option11txt,option16"and I have a term called "optoin16", which does not match any exact item or element in the list, however, in this case,the last item, namely, option16, is the closest match, that is what I want. How do we construct a regular expression to find "option16" from this list based on "optoin16"?Thanks.

How would you handle one or more hyphens in words? For instance, "T-cell" is a word,<cfset w = "T-cell">,REreplace("a long text string T-cell and more...", "#w#", "<a href=''>#w#</a>")The above REreplace function failed to identify "T-cell" as one word since hyphen is used as an indicator for a range such as [a-z], according to Adobe documentation, thus, one needs to add the hyphen to the end to reference it as a literal, I attempted to do the following:REreplace("a long text string T-cell and more...", "#w#-", "<a href=''>#w#</a>")  orREreplace("a long text string T-cell and more...", "[#w#-]", "<a href=''>#w#</a>") However, it misfired and caused serious problems. What's the correct regExp for this situation? Many thanks

Hi Team,We are using ColdFusion Enterprise in windows server with IIS. We have setuped 3 instances in ColdFusion added to one cluster and all the websites in IIS will load from that Cluster there are almost 180 to 230 websites. Issue:All of the sudden our CF instances getting restarted when we check event logs we are seeing Below error. Again it start working normal after instance restarted its happening almost couple of times a day we having same problem with three of our servers can you help us with it .The description for Event ID 80 from source ColdFusion 11 Application Server CF1 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: ColdFusion 11 Application Server CF1 the message reso

There was discussion that ColdFusion was going to deprecate dbvarname with cf2016I have code like this that works in CF2005 but I am migrating to CF2016 and am having issues with the Stored Procedure -dbvarnameThis no longer works<cfstoredproc datasource="#live#" procedure="ABX1265">    <cfprocresult name = "resultXML" resultset = "1" >    <cfprocparam cfsqltype="cf_sql_char" dbvarname="@COMPANY"   type="in" value="#companyCode#" >    <cfprocparam cfsqltype="cf_sql_char" dbvarname="@ENVIRONMENT" type="in" value="#arguments.environment#"></cfstoredproc>  <cfquery name="out2" datasource="LIVE#companyCode#" >#resultXML#</cfquery>

I just downloaded a 30 day trial for ColdFusion Standard 2016. I, however, am a university student. I read in the FAQ's for this product that students of eligible universities can receive a license for educational use (I'm not going to use this product for production development). Does anybody have a link for where I can validate my standing as a student in order to get a license?

Hi -Our site formerly ran CF9 and a Standalone Tomcat as application servers for different parts of our application, using IIS as the web server front end. There is a proxy server in front of all of that, too. All of this worked OK.CF10 has now broken this, as requests to our Tomcat Server result in a 404 Not Found error. The difference, I think, is that CF9 did not use an ISAPI redirect filter, while CF10 does. Adding a Tomcat ISAPI redirect filter results in everything (both CF10 and Standalone Tomcat) receiving a 404.I have tried adding details to the CF10 uriworkermap.properties and workers.properties files specifying the file suffix to pass to Standalone Tomcat, and which port to listen to for Standalone Tomcat requests. This receives aBad GatewayThe proxy server received an invalid response from an upstream server.error, which I guess is an improvement, but not a fix.Has anyone else encountered a problem like this? Googling is very difficult, due to the confounding of CF Tomcat a

Does anybody have a coldfusion code to share on how to create the "fingerprint" for posting form parameters to Authorize.Net SIM API?

So I am using application.cfc and I have had the same loginform/application.cfc setup for many sites. A new site was created for me recently and for some reason I cannot get the cflogin to work correctly. It bounces me to the loginform.cfm if I am not logged in, when I log in and submit the form I see the index.cfm but it does not look like the cflogin worked. I see an empty string for getauthuser(). From the index page if I click on any link I get redirected to loginform.cfm again and still the getauthuser() is an empty string. I have tried to dump cflogin.user and it is never defined.Has this ever happened to anyone before? Any thoughts on what could be wrong? Could this be an issue with how the site is set up? I also moved another working site into this directory and the login does the same thing where it works fine in it's original directory.Any ideas or info is appreciated.

I am using cfimage to write a binary image out to the browser that I pull from a DB. It is sort of working, but it only displays the top half of the image. At a certain point no matter what the image is it stops and the rest is grey. Does anyone know why this is? I have verified the images are fine and are not corrupted.

I have code that gets the Oauth token so that I can log into an application.  However, the final part - going to the application - has me stumped.I have tried a form:<cfform name="trythis"" id="trythis" method="post" action="http://xxxx/api/v1/users/login.json?token=#gettokennumber#"><input type="hidden" name="email" value="user@example.com"><input type="hidden" name="password" value="pass123"><input type="hidden" name="username" value="user1"></cfform>I am thinking that somewhere I have to use that it uses json...but I'm not sure whereThen I tried cfhttp     But it just sat there, doing nothing...<cfhttp url="xxxx/api/v1/users/login.json?token=#gettokennumber#" method="post" >    <cfhttpparam type="header" name="Content-Type" value="application/json" />    <cfhttpparam name="password" type="formfield" value="pass123">     <cfhttpparam name="email" type="formfield" v