ColdFusion

I am using ColdFusion 11 and trying to use FDIST function in a spreadsheet to get F-distribution value. The error I'm getting is that, it does not like the semicolon in the formula. In the exception.log file I see this error, org.apache.poi.ss.formula.FormulaParseException: Parse error near char 7 ';' in specified formula 'FDIST(1;4;5)'. Expected ',' or ')'The simplified code is as follows:<cfset sObj = SpreadsheetNew()><cfset sFormula = "FDIST(1;4;5)"><cfset spreadsheetSetCellFormula(sObj, sFormula, 1, 1)><cfset iValue = spreadsheetGetCellValue(sObj, 1, 1)><cfoutput><p>Value = #iValue#</p></cfoutput>Please let me know how this can be fixed. Any ideas?Info about FDIST function Documentation/How Tos/Calc: FDIST function - Apache OpenOffice WikiThanks.Milind

So I am trying to migrate a site from CF 9 to CF 2016 after getting past a few issues I have run into one I can't seem to figure out. Basically I call the web service like so<cfinvokewebservice="#APPLICATION.SiteURL#/cfapi/webservices/Orders.cfc?wsdl"method="QueryOrder"returnvariable="REQUEST.XML"> <cfinvokeargument name="WebOrderNumber" value="#URL.WebOrderNumber#" /></cfinvoke>And it calls a page that returns an order via xml. On CF 9 it works fine. CF 2016 returns the XML but it also returns an error. The error says This page contains the following errors:error on line 66 at column 1: Extra content at the end of the document Below is a rendering of the page up to the first error.Then it lists my XML but just as straight string data. Even though if you view the source it shows the exact same XML content as the CF 9 server returns. The only other error info I see is this. "Cannot perform web service invocation QueryOrder"I'm stuck! Any ideas?

I'm using a simple cffile to upload pdfs.  I just moved from a CF9 to a CF10 server.  There weren't any limits on the old server, but this one seems to have a limit of 30 or so MB for a pdf file.Maximum size of post data was set to 20MB as a default, I changed it to 50, but still can't upload a 32mb file.What am I doing wrong?Thanks

Hi All,if i update my database mysql, the character not correct update in the database:update mitarbeiterset vorname = 'Gdańsk'where id = '1604'In the database stand: Gda?skThe character encoding on the site seems ok.in HTML it shows:Gdańskdoes anybody knows the problem ?thanks thorsten

Hello, all,I know this can be done; I just can't remember how I did it, oh so many years ago.  Presume tables exist for groups and people.  People can belong to more than one group.SELECT g.groupName, p.lastName || ', ' || p.firstName as fullNameFROM groups g LEFT OUTER JOIN groupPersonAssociation gpa ON gpa.groupID = g.groupID              LEFT OUTER JOIN person p ON p.personID = gpa.personIDORDER BY g.groupName, fullNameThis gives us:Group One          Alpha, DanielGroup One          Bravo, CharlesGroup One          Charlie, ChuckGroup Two          Beta, AlphaGroup Two          Delta, BonnieGroup Three        Echo, BunnyGroup Three    

I have a datasource to save on ColdFusion server to let user access the database.I need hardcode user ID and Password to the datasource and the ID and password need to give the highest read writes.I would like to know is it possible that I do not need hardcode password and ID on the datasource on ColdFusion Server and it can pass user login ID and password to access database users ID and password.Your help and information is great appreciated,Regards,Sourises,

Hi,Please can you confirm if a single Coldfusion 2016 Enterprise license can be used for a testing (QA) environment as well as a production one? Would the same product key/serial number be used in both installations? If possible please could official Adobe staff contact me via email so we can send confirmation to my company licensing team.Thanks in advance!

Hello,I'm new to CF, please help to know how can I create a web.config file for CF2016 for IIS 8 in Windows Server 2012. Please help to share a sample web.config file for CF2016.Thanks a lot in advance.

HiI have a strange scenario where one install working and the other is not! And both installs use exactly the same setting.ON one server the pdf service just hangs, htmltopdf does not work as it won’t allow me to enable the pdf service (just hangs). On this server the coldfusion archive builde also does not work, just hangs as well, maybe coincidence!Both servers running CF11 enterprise update 9 and win 2008r2 264Any ideas?many thanksOli

When using JDBC URLinstead of database and server name, how do I include the Enable High ASCII characters and Unicode for data sources configured for non-Latin characters options? Because when using the JDBC URL, that option is no longer available in the ColdFusion Admin datasources page. Any help is much appreciated.

I've installed many CF servers, but today was my first multiserver installation.  How do I get to the administrator page?  The installation seemed to go smoothly.  The installation log looks good.  However, there is not CFIDE mapping in either IIS websites, so http://{host}/cfide/adminstrator/index.cfm doesn't exist.The last page of the installation says that "You may now deploy Adobe ColdFusion 11 to your application server." but I'm not finding any references on how to do that.I appreciate any help.  Thanks.Jeff

Attempting to resolve an issue and I have reduced issue down to simplest form.<cfhtmltopdf unit="in" marginBottom="1" marginLeft="1" marginRight="1" marginTop="1" orientation="portrait" pageType="letter">this is a test <cfoutput>#now()#</cfoutput></cfhtmltopdf>The Top Margin in 1 3/16 inch and Left margin in 1 1/16 inch.  In my code the margins are 1 5/16 for top and 1 3/16 for left, but we have HTML tags and style that I am thinking I will have to tweak, but the above example should give one inch and one inch on top and left margin and it is not.Is there anything that I can do to correct this issue?  It seems like a PDF service issue to me.CF ENT 11, update 9 on Windows Server 2012 R2 64 bit.

Hello, all,This is my first time trying anything with SSI.I have Apache 2.2.27 running on Windows (C:\apache), and I have been following a few blogs/posts on how to configure Apache to use server-side includes.  I believe that I have everything as it should be.In C:\apache\conf\httpd.conf:I uncommented "LoadModule include_module modules/mod_include.so"...ServerName 127.0.0.1:80DocumentRoot "C:\ColdFusion10\cfusion\wwwroot"In my DIRECTORY, I changed the following:Options FollowSymLinks to:Options FollowSymLinks OptionsIn my DIRECTORY "C:\ColdFusion10\cfusion\wwwroot", I changed the following:Options Indexes FollowSymLinksto:Options Indexes FollowSymLinks IncludesI added the following to an IfModule tag:AddType text/html .shtmlAddOutputFilter INCLUDES .shtmlThen, I create a .shtml file called "menu.shtml", place a few lines just for testing, and include it in another file "csstest.html":<!--#include file="menu.shtml" -->.. and it does not work.  At all.What am I missing?V

I installed CF 2016 last night and will randomly start getting "java.lang.NullPointerException" on every page.  Also, I'm getting CF errors on pages when I don't include the "www." in the URL.  For instance, if you go tohttp://wrestlinginc.com/temp/test2.cfmYou will get an error, details are below. It's the exact same file as if you add the "www.", which comes up fine:http://www.wrestlinginc.com/temp/test2.cfmHere is the error from the error log:"Error","ajp-nio-8016-exec-4","03/18/16","14:45:49","www_wrestlinginc_prod","'' The specific sequence of files included or processed is: XXXXXXXXXXXXXXXXXX\test2.cfm'' "java.lang.NullPointerExceptionAny help would be greatly appreciated. I'm getting close to going back to CF10

We're running CF 9, and IE11 on Win 7. On one PC, and one only, I get the Debugging Window popup. I can close it and work normally, but it is annoying. (It seems to be complaining about how long a page takes to open.) How do I stop this action?The PC in question had sat idle in a closet for six months, and worked OK before this.The issue doesn't happen in Chrome. It does happen in Firefox.I have done the following:Cleared the cacheOpened Tools>Internet Options>Advanced, made sure that 'Disable Script Debugging' was checked in both IE and Other.I uninstalled IE and reinstalled it, same issue.Ideas? Suggestions?Thank you for your help.Scott

I know its possible to install multiple versions of CF on the same server.However, is it possible to have multiple versions using IIS instead of the built-in CF web server?  If so, how do I set this up?Thanks in advance!

Hey everyone,I built a site for a company, all modern stuff. The website has a section that is hooked to a ColdFusion site(?) Unfortunately the portal is so old that it need to be set into compatibility mode in order to function. However, when you set the site to compatibility mode the site doesn't render (I am assuming because it uses more modern html5 code and it doesnt know what to do with it)So the question is, is it possible update old .cfm files in order to function on the modern web (easily, this is the first time i ever heard of coldfusion)? Also, it is running on ColdFusion MX 7...and I really dont think they are willing to upgrade.If anyone is interested this is the old portal.And thank you so much in advance

OS:   Win7 ProVersion:    HomeSite 5.5+.I wanted to maintain the keyboard shortcuts of Version 4 in 5.5.In 5.5 when I set the Keyboard Shortcut for <font="-1"></font> to "CONTROL+SHIFT+-" (minus) this works only for the actual session. When I restart HM, this shortcut no longer functions; nothing happens.[ Just for info: The Keyboard Shortcut I made for <font="+1"></font> is "CONTROL+SHIFT++" (plus), which keeps on working. ]Any suggestions?

I have some simple code to display a video mp4 file using the html5 video tag.  The code works on the production server, but not on the development servers.  on those, it just shows a blank video area.  The only difference that I can see is that the development (CF10) server uses Apache as a web server while the productions server uses IIS.  It there something special for Apache to show the video using the video tag?

We are migrating our site from CF9 to CF10.  I have an old upload page and it kept giving errors, but it was uploading the document.  If I use upload.CFM I get a 404 error, if I use upload.cfm it works fine.Is CF10 case sensitive?

Hello,My name is Harshal Jain working for Edwards UK. Earlier we were using CF9 (Coldfusion server version 9) and now we have migrated to CF11 (Coldfusion version 11) . The problem is excel download code which was working fine on CF9 is working partially on CF11 and it blocks the contents of the excel file downloaded - due to security concerns - it treats the source from which the excel is downloaded as - not trusted.For eg below is the sample code<cfprocessingdirective pageEncoding="utf-8" /><cfsetting enablecfoutputonly="Yes"><cfcontent type="application/msexcel;charset=utf-16"><cfheader name="Content-Disposition" value="attachment; filename=TEST_Excel.xls"><cfoutput><table border="1">  <tr>  <th nowrap>Name</th>  </tr>   <tr>  <td nowrap>Mark Waugh</td>  </tr></table></cfoutput>When the above code is executed on CF9 then - and when this code is executed

Hi. I am trying to set up a vacation schedule in ColdFusion. I'm just wondering how to do this. Where do I start? I will need it to accrue so many hours each day and then subtract the hours the employee uses. When the employee logs in each day, they'll be able to see how many hours they have accrued. Can someone show me how to get this started? Thanks.Andy

Hi. I'm losing session cookies in Safari and can't figure out why. ColdFusion 10. It's not happening on every browser. I am capturing the cookies and user agent when this happens. The strange thing is, one of the user agents matches my iPad 3 exactly, but it works fine on my iPad. All cookies are written and maintain their values correctly, except CFID and CFTOKEN, which change on every click. I've tried changing my Safari settings to Do Not Track, and Allow Cookies only on sites I visit. It still works fine.Any clues? Can I try setting the cookies manually in Application.cfc? What is the best way to code this?Thanks in advance,Bud

On August 16, 2016, my company, a large aerospace firm, send an email to all of its ColdFusion developers containing the following statement "Support for ColdFusion from the vendor and within the enterprise will end in 2021." Is Adobe finally going to abandon ColdFusion?

HiI have a cfm file that pulls live data from a mssql database.   Recently on a windows 10 computer it stopped pulling data.  It creates the spread sheet, but no data is in it.  The only thing I can see that is changed is that CF was updated from version 10 to 11.  The above .cfm file still works on a computer with CF 10 on it.   No changes have been made to the file.I'm still learning CF (I had this created for me by an experienced programmer) and so I'm not sure where to look to fix it.Thanks for any help.Will