ColdFusion

I'm attempting to write a string to an XML file using CFFile. The XML file must have apostrophes expressed as "'" once complete.I'm using <cffile action="write" file="#VDJ8databasepath#databaseNew.xml" output="#XmlString#" addnewline="no" charset="utf-8"> to write the string to a file.I can change the string to represent apostrophes as " ' " or "'" but when I write it to file, apostrophes are written as either " ' " or "'". As you can see, when the string contains apostrophes represented as "'" CFFile encodes the "&" character as "&" but when the string contains apostrophes represented as " ' " it does not encode them at all and simply leaves them as " ' ".Any ideas how to get my apostrophes written by CFFile as  "'"?

I have the following code which generates a table of data and sends out to an email, but I need it to group by the Status "new_Data" field.Here is what it currently produces:Here is what it should produce:I'm not sure how to change the grouping in my table code to get the Status (in yellow) to break properly?Here is my current code:<!--- Only send the email Mon-Fri ---><cfset weekday = DayOfWeek(Now())><cfif (weekday eq 1) or (weekday eq 7)>  <cfabort></cfif><!--- Query for the Status Audit records that were Changed yesterday ---><cfquery name="rsAudit_Status" datasource="cwo">SELECT tblcom.omID, DATE_FORMAT(tblcom.omEstCompDate,'%a %m-%d-%Y') AS ecd, omOwner, tblcom.omContractDate, tblcom.omStatusID, tblStatus.stSort, tblcom.omType, IF(tblcom.omDelayed='N', 'Priority Builds', 'Delayed') AS delay_name, tblcom.omCustName, tblcom.omCustAddress, tblcom.omCity, omWorkUnits, omBuildClass, IFNULL(Datediff(NOW(),omDate),0) AS DOS, DATE_FORMAT(tbl

Hi,We have 4 ColdFusion Standard Edition servers.  I would like to set all of them to use database for Client Variable Storage - and use the same Datasource.We use UUID for generating CFTOKEN.  Since I am using the same datasource, will it be possible that one server will create same CFID/CFTOKEN as another server?  Remember, that these are Standard Edition servers.  My main concern is that Server 1 creates a set of CFID/CFTOKEN.   Some days later, Server 2 creates the same set of tokens and ends up sharing another users data that had previously logged on to Server 1.Thanks!

HiOur local host is on a computer, and I tried to add another site and… well now its broken.It has been set up to use a separate drive / or maybe partition of the hard for all the websites.I don't know what information to give or were to start so I will try giving some random information to start withOS Windows 8Coldfusion version 10using IIS (i think this is the web server)I can type in localhost into a browser and i get the IIS image page thingIf I try typing in 127.0.0.1/CFIDE/administrator/index.cfm  I get a HTTP Error 404.0 Not found.I have limited knowledge with regards to this so any help or idea would be very grateful.ThanksMark

This is what I have.<cfset inactivePagesReport = Server.CommonSpot.api.getObject('reports')><cfset inactivePages = inactivePagesReport.getInactivePages(0)><cfdump var="#inactivePages#">So, how do I loop through each row and only output certain columns like ID, Name, Link columns?Any help is much appreciated.

The link to download ColdFusion Builder is broken.

Hi Guys and Gals,Having a weird issue with javaloader and a new JAR I had a developer write for me. My existing code uses itext 2.1.7 and its loaded via Mark Mandel's javaloader (https://github.com/markmandel/JavaLoader)  The existing code merges PDF's together (and does a better job than CFPDF and isn't crippled. Its not complicated code either. The part of the code in question:local.outStream = server.javaLoader.create("java.io.FileOutputStream").init( local.fulloutputpath );local.copy = server.javaLoader.create("com.lowagie.text.pdf.PdfCopyFields").init(local.outStream);local.PdfReader = server.javaLoader.create("com.lowagie.text.pdf.PdfReader");Then it does some work. and then closes the PDF:local.copy.close();That close() call throws an error java.lang.RuntimeException: The document is not open.  But it only throws that error if I have added this new JAR I had a guy write for me, to the java loader. I haven't even called the single method of this new class, and it is alr

Hello, all,I've got another head-scratcher.  The following code is producing an error:     thisField = trim(form.thatField);     thisField = new components.myCFC().stripScript(variables.thisField);     form.thatField = variables.thisField;Now, according to cfdocs.org, if you do not explicitly declare that a variable is to be saved in any scope, then the VARIABLES scope is the default scope that the variable will be saved in (ie, "thisVar = '';" is the same as "variables.thisVar = '';".)So.. when I typed thisField = trim(form.thatField); then it should have default saved to the VARIABLES scope.  But the second line is generating the error:Element THISFIELD is undefined in VARIABLES.???   Is this a bug?  Am I missing something?V/r,^ _ ^

Hello, all,I've got a weird glitch using SpreadsheetAddFreezePane() that I've never seen before.  I'm attaching two screencaps.I am attempting to freeze the top two rows, and columns A through M.The first issue is to the right of column M you can see the content of columns C and D.  If I scroll to the right, it disappears.The second issue is that if I scroll down then up, then the row numbers and the first two rows partially disappear.The code is for a second sheet that is added, after the Excel object has been created and the first sheet populated.SpreadsheetAddFreezePane(sObj,13,2);I'm really confuzzed on this one.  Any thoughts?(BTW.. small family emergency just popped up, and I will be leaving work in about an hour to go check on things, so I probably won't be able to answer any questions until tomorrow.)V/r,^ _ ^

Looking for any intel on known issues.- did not want to drag anyone into debugging for us but wanted to mention the item in case it strikes a chordThanks

Hello, all,I'm just playing around with something and wanted to see if I could insert an image into an Excel spreadsheet cell.  I found SpreadsheetAddImage(), and I'm not having any luck with it.  The image is a PNG file, 70 x 70 pixels in width and height.<cfscript>sObj = SpreadsheetNew("testing","true"); // This is for Excel 2013, not the older versions.SpreadsheetSetCellValue(sObj,'Testing Image Insert',1,1);SpreadsheetSetColumnWidth(sObj,1,75);SpreadsheetSetRowHeight(sObj,2,75);imgBytes = FileReadBinary("D:\site\images\emblem70x70.png");SpreadsheetAddImage(sObj, imgBytes, 'png', '2,1,2,1');<cfscript><cfheader name="Content-Disposition" value="attachment; filename=test.xlsx" /><cfheader name="Content-Type" value="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" /><cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#spreadsheetReadBinary(sObj)#" reset="true" />When I open the spreadshe

We're in  the process of migrating from CF9 to CF2016 and are running into really slow compile times. The app startup takes twice as long as before but our real problem is that  we have a lot of dynamically generated CFML that gets written to the VFS (Virtual File System) and then included. This code, executed in a loop x 100 takes:CF9        = 1420 ms. CF2016  = 8643 ms. I have tried with Java 1.8.0_112 and 1.8.0_131 and the result is the same.Is there anything that we can do to speed up the compile time and is this a known issue with CF2016? Why was it so much faster on CF9? Any help would be hugely appreciated as our upgrade is now stalled due to this issue.

We have ColdFusion2016 Enterprise, originally installed in trial mode but now licensed.Its running Microsoft SQL server data sources no problem.I tested a JDBC data source against Microsoft SQL Server database no problem.But when I installed Seefusion 5 and tried to use their JDBC wrapper I get an error where the data source will not connect.Here is the stack trace below;A non-SQL error occurred while requesting a connection from test.Timed out trying to establish connectionDec 01, 2017 11:40:16 AM com.seefusion.Driver connectWARNING: Unable to connectmacromedia.jdbc.MacromediaDriver$InvalidLicenseException: Use of Adobe JDBC Drivers is restricted. Drivers can only be used with Adobe server products. Please check that your license supports the requested driver.    at macromedia.jdbc.MacromediaDriver.unlock(Unknown Source)    at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)    at java.sql.DriverManager.getConnection(Unknown Source)

I've got the following function written in tag syntax:************<cffunction name="myQuery" returntype="query" output="false" access="remote" hint="run some query">   <cfargument name="someRequiredID" required="true" default="24">   <cfquery name="local.getThings">  SELECT ID, entry_title   FROM entries  WHERE blogID = <cfqueryparam value="#ARGUMENTS.blogid#"   cfsqltype="cf_sql_integer">    </cfquery>    <cfreturn local.getThings></cffunction>****************How can I rewrite this using script syntax?iecomponent  displayname="testQuery" {     // confusion starts here ??     // define method myQuery     public query function myQuery() {          //run some query          peopleQuery = new Query(sql="SELECT * FROM PEOPLE").

Hello,I'm learning ColdFusion (have a background in web development) and have created a simple test site in ColdFusion Builder 2016. I run my site using the built in server, the one built into ColdFusion Builder 2016, runs locally on port 8600. I am trying to add my own custom CSS file, and ColdFusion can't seem to find it, keeps giving me a 404. It's a very simple CSS file with a very simple link tag:<html>     <head>         <!-- Some code here... -->         <link rel="stylesheet" type="text/css" href="footer.css" />         <!-- Some more code here... -->     </head>     <!-- Rest of the code here... -->Very simple and straightforward, but for the life of me I can't get ColdFusion to find the CSS file. Does ColdFusion not serve static content? I noticed I get the

I am using windows server 2008 R2 and Coldfusion 9using.I am using oracle for the database.Sometimes the session of Coldfusion 9 and oracle will continue to remain,Is there a way to deal with it?

The license at http://wwwimages.adobe.com/content/dam/acom/en/legal/licenses-terms/pdf/ColdFusion-2016.pdf​ pointed me to Adobe - ColdFusion 10 for licensing questions, which simply says "Send a mail to adobecoldfusion@adobe.com for all the queries with respect to licensing".  However, when I sent a message to that address, I got a bounce saying that "adobecoldfusion wasn't found at adobe.com".  When I tried to open a ticket at Adobe ColdFusion Learn & Support, I got "If Adobe ColdFusion is owned by your company or organization, you won’t see it listed under your Adobe ID. Chat with Adobe Customer Care", but when I clicked "Chat with Adobe Customer Care", I got "Chat is currently unavailable. Please contact us during our business hours. If you receive this message during business hours, please try again" (it's currently 8:26 PST).  I guess community support is my only option .My question is about licensing for Docker.  My assumption is that we have Enterprise li

Curious where we would put suggestions on improving the portal experience?Yesterday, I noticed the ColdBox question in the discussion category so passed it along to Brad Wood via Twitter that he may know the answer.  He made a good suggestion that there could be a Twitter bot that sent out when these posts come in.  I know i subscribe to @CFOverflow which pushes Stack Overflow questions to Twitter.  I agree with Brad it would be good to have something similar in the portal.Reading through his thread, when he did answer the question, he noted that he wasn't being notified when there were new posts in the discussion.  I think that would also be a great feature to have put in because its easy to forget to come back to check for new posts.Thanks

So in the API manager I tried changing the API proxy port from 9100 to 443. Restarted the manger and it won't start. Log say 443 is already being used. My assumption would be IIS is using it. How do I get the public URL for the manager setup so you can call like so, notice there is no port in the URL.https://mydomain.com/myapiname/v1.0/resource IIS 10WIN SERV 2016

I am remediating some older ColdFusion code which uses an Oracle database. I have noticed many instances where a CFQueryParam has been implemented like this;<cfqueryparam cfsqltype="varchar2" value="#someStringVariable#" />Is this an undocumented CFSQL Type that I am unaware of?If not why doesn't this throw an error at run time?What validation of the data takes place if you enter an invalid CFSQLType?

Good morning CF friends,   Yesterday I finally debugged an ongoing issue that we had determined was an undocumented issue with the past hotfix for CF2016 - which we now know was not entirely true.   The issue was that every so often one of our 8 JVM instances in our CF Cluster would show an error for an application that was looking at the same code base for the same application.  The cfcatch error was for missing include template files that were working great after a reboot of the same instance and fine on the other instances.   What was discovered, is that during the last update (5) the ownership had been changed to root:root on the /opt/coldfusion2016/sec-apps-2/wwwroot/WEB-INF/cfclasses contents that were existing at the time on that single instance (default behavior when applying the update).  However, there were no indicators of what the problem actually was since during a reboot everything worked great again with no errors showing up in any

ColdFusion Builder 2016 on Windows 7 works with mapped drives. When setting up a ColdFusion Project and/or ColdFusion Server, the browse buttons can see the mapped drives and/or one can use UNC paths which are found. On Windows 10 Pro 64-bit this is not the case. No mapped drives can be viewed and UNC paths cannot be found.I have tried several versions of Java JRE with Eclipse Mars (4.6.2) and ColdFusion Builder 2016 plugin. And I have also tried the ColdFusion Builder 2016 stand-alone install.Is this a bug, or can someone tell me how to make this work?

Hi,We are looking for a solution to repeat the header on ALL pages of the PDF generated using <cfdocument> tag. Does CF 2016 have an option for doing that? We are currently using workarounds to get it working but would like to have a much cleaner solution.Thx

I am using ColdFusion 11 and have a page that creates a PDF using the cfdocument tag. Nested in the cfdocument tag is the following markup<cfdocumentitem type="header" evalAtPrint="false">    <cfif cfdocument.currentPageNumber GT 1>         <p>page header</p>    </cfif></cfdocumentitem>The problem I am experiencing is this header is showing up on page 1 when I only want the header to show up on pages greater than 1. Any insight you could provide would be appreciated....Thanks

Greetings!  After attending the ColdFusion Summit 2017, I was inspired to start using CFBuilder 2016.  Sadly, it appears that I cannot connect to any of our servers using mapped drives on my Windows 10 machine.  Any suggestions? Thanks...    Dan