ColdFusion

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,

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.