Questions

Hi there,Is there a way of being able to output all the include files use in a web page?I am debugging someone else's code and they have used multiple includes and sub includes and it would be really handy to see all the includes that were used?Thanks,Andrew

Hello,tried to update our current CF installation (Windows 2008 R2, CF 11, update 7, java 1.8.0_77) to the latest update.First time in my CF update history I was not able to "download" or "download and install" in CF administrator so I manually downloaded and put hotfix_008.jar in directory cfusion\hf-updates. After that options in CF administrator changed to "Re-download" and "Install". Tried to click on both buttons but again nothing happens (like before when clicking on "download" and "download and install".Javascript is enabled in Browser.Manuela

After installing Update 14 in CF10 I can't reach my CF administrator page (or any .cfm content).  When trying to reach administrator at http://127.0.0.1/CFIDE/administrator/index.cfm the server reports a 404 error. When trying to display other .cfm content, I get a 400 error.I've used the web connector to remove and reinstall the connector to the IIS server, but that didn't help.Any ideas?

I'm trying to update my Coldfusion10 server but I keep getting a Signature verification error. I followed the instructions here and then downloaded the required update from here.Although my CF server is working I need to install all the security updates for it. If anyone can help me with this issue I would really appreciate it. Thanks.

RedHat 7.2httpd-2.4.6-40.el7_2.4.x86_64ColdFusion 11 (64-bit)After installing hotfix 8, apache is not starting:Aug 30 16:08:27 web5vm httpd[2843]: AH00526: Syntax error on line 6 of /etc/httpd/conf/mod_jk.conf:Aug 30 16:08:27 web5vm httpd[2843]: Invalid command 'JKIPRestrictionFile', perhaps misspelled or defined by a module not included in the server configurationAnyone experiencing this issue?

Hi All,We have released security updates for CF10 and CF11. Please find the blog post announcing the release and the KB articles detailing the installation instruction below:http://blogs.coldfusion.com/post.cfm/coldfusion-11-update-10-and-coldfusion-10-update-21-releasedhttps://helpx.adobe.com/coldfusion/kb/coldfusion-11-update-10.htmlhttps://helpx.adobe.com/coldfusion/kb/coldfusion-10-update-21.htmlNote: There is no impact on CF2016 with this security update.

how to resolveConnection verification failed for data source: teste java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.for access conection?

Hi,    We got an error in coldfusion administrator - settings summary -  when we login by the a user we created other than the administrator.   The error message is "The current user is not authorized to invoke this method. The error occurred in accessmanager.cfc: line 105." Is there a solution for it?Thanks,Tak

I am using Coldfusion to generate a large spreadsheet (18 tabs) with a lot of formatting and it works perfectly when I view the resulting file in Excel 2010 but a bunch of the formatting is missing in Excel 2013.If I generate each tab in a separate Workbook then the spreadsheets work great but when combined into a single Workbook, problems appear.Tab 1 - 3 columns x 19 rows  Formatted 42 cells.  formatting is correct on all cellsTab 2 - 6 columns x 21 rows. Formatted 92 Cells.  formatting only appears on 42 cellsTab 3 - 4 columns x 10 rows .Formatted 31 cells.   no formatting appearsTab 4 through 15.  no formatting appearsTab 16 - 8 columns x 306 rows. formatting on 37 of 2412 cellsTab 17 . no formatting appearsTab 18  4 of 28 cells has formatting.I was thinking there might be a limit on the number of formats that can be applied to a workbook, but then why would it work in Excel 2010 and not Excel 2013.I am only using 10 different styles but I am appl

We are planning to use the J2EE version with JBOSS. The documentation about setting up the Apache connector refe to WSCONFIG, supposedly to be found at:cf_root/runtime/bin/wsconfigBut this is not part of the J2EE installation. How does one get the required software for the Apache setup?

I'm trying to build a table of noise barrier area by material per year.  I have a query that gives me this:(I have years from 1963 - 2013, so the below is just a sample)2013    Berm    302013    Block    1722013    Cast-in-place Concrete    512013    Combination    162013    Concrete    02013    Glass    42013    Metal    632013    Not Specified    192013    Other    02013    Precast Concrete    2782013    Wood    49(the 3rd column is area X 10,000sqft)the problem is, while the years are fine as rows, I need the materials to be column headings, and not in a single column.  I swear I used to know how to do this, but now suddenly I'm drawing a blank.

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,