ColdFusion

Hello, all,I'm using SpreadsheetNew() to create an .xlsx file that will contain groups and all the users associated with said groups.  I'm trying to figure out a way to insert a line break within a cell for groups that have more than one person.  So, ideally, the format would be like:_______________________________________________Group One       |             Adam Smith                |             Jaime Doe                |             Cindy Morgan________________|______________________________Group Two       |             James Cobu

I installed the J2EE EAR version of the Coldfusion 2016 on Windows and got it to deploy on JBOSS EAP7.Then I tried to do the same on Linux, but there are all sorts of errors when deploying the ColdFusion exploded EAR.One error is that it is missing the file: cfusion.ear/cfusion.war/WEB-INF/cfform-gateway-config.xmlThat makes me wonder whether the installation is incomplete. Is anyone else experiencing similar problems?

Hello, all,I am nearing the end of my side-project, and could use some advice on creating a secure login for it.First off, I would really like to avoid using CFLOGIN/CFLOGINUSER, if at all possible.  I know a lot of people use it, and all, but after some things that I've read online, I'm not comfortable using it.  I would like to create one from scratch.  I've Googled for it, but I'm not finding anything that DOESN'T use CFLOGIN.That said, another thing that I'm concerned about is keeping an admin logged in beyond what any session scope can do.  No matter how long I programmatically set the session for, I believe that it cannot surpass what is set in CFAdmin.  So if I manually set the session to expire in an hour, but the CFAdmin says 20 minutes, the session won't last beyond 20 minutes.  😕😕One more thing.    (I kind of feel like Columbo, now)  Concurrent logins.  I want to disallow them, and set it so that if an admin i

Hi,  Would like to know how to set up a page expiry in coldfusion 11.        Scenario is once a customer placed an order on a shopping cart and order  completion page is shown and if the user tries to refresh the completion screen,  he should be shown a message saying page expired/order details sent to the mail.  It would be helpful if you can give your suggestion regarding how to handle the page expiry.

I'm using cf 9 on a Windows platformI can run an SQL statement wherein my students who have been absent for 30 days will appear on this output list. Where I am having an issue is that next to each instructor I would like to show the student's last date of attendance. This somehow I was not showing up when I run my query. The query that I am using is as follows:SELECT Stuid, trim(concat(name.fname,' ',name.lname)) AS OVER_30_Days, ltfname as instructor, Max(meedate) FROM name LEFT JOIN meeting ON meeStuid = Stuid and meedate BETWEEN NOW() - INTERVAL 31 DAY AND NOW() LEFT JOIN squadlt on squadlt = ltid WHERE meeStuid is null AND  type = 'pupil' AND city = 'jackson' AND status = 'a' AND Stuid <> '432' and Stuid <> '5' and Stuid <> '183'  ORDER BY ltfname, OVER_30_DaysThe resulting list below displays as such with null values in the maxdate column . Is there something that I am doing wrong?

what do mean "window.parent.document.forms"is there a way to know what do mean without have rest of the code? alert('Aviso!');window.parent.document.forms[0].edAlgo.select();window.parent.document.forms[0].edAlgo.focus();

Previous version of CF, there was a 2-cpu limit (I believe).  In looking at 2016 standard, the features and matrix comparisons, I don't see such restrictions listed anymore.  Can someone confirm if this is still a thing with Std and if so, please provide a link to a doc that says so -- I've been up and down the Adobe and the Google on this to no avail.

Can anyone please help to reset my adobe coldfusion 2016 release administrator user name and password? Appreciate your help in advance.[Moved from the non-support general Adobe forum lounge to a product-specific support forum - moderator][Also, please remember that this is a public, user-to-user forum. Please do not give out sensitive data.]

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