Questions

We have CF9 and want to move to CF 2016, but on a new server.  I have been trying to digest the CF2016-Migration-Guide.  I am not real familiar with CF, but I am pretty familiar with Windows Server, IIS, etc...The migration guide is catered for someone doing an in-place upgrade and there appears to be some sizable gaps on steps if you are moving to a new server.I have successfully:- Installed CF 2016 on the new server- Copied the neo*.xml files from the old server and allow them to migrate- Copied the \Inetpub\wwwroot files and folders from the old server to the new- Copied the database folder that the datasources point to from the old to the newWhat I am missing:- Do you I need to recreate the ColdFusion Collections or is there a way to migrate them?  (note: recreating wouldn't be horrible, but I am not sure what folder was specified on the old server when you tell the collection to index)- I am not sure if I a missing anything else.  If I hit my website on the new

Hello, all,I cannot access helpx.adobe.com, just wanted to see if anyone else is having this issue.  If so, then I think Adobe is having an SSL cert issue.  If not, then how can I fix this?  I need access.V/r,^ _ ^

is it possible to set up Outbound url rewrite rules using Coldfusion and IIS? If if anyone has this working, please point me to an example,i have no no problem with IIS and .net or html pages but when I try .cfm either the server hangs or the outbound rules only work with the target page.no issues with inbound rewriteregardsRichard

I'm wondering if Adobe is going to move http://blogs.coldfusion.com/ over to this community so that we have less Blogs to have to sort through when looking for ColdFusion info.  Anyone know?

I seem to be completely confused over how to achieve a Single Sign On for Coldfusion apps that previously used the classic username password form to get started. This is a company Intranet Application. Let me explain. The assumption is that some user has logged in to his company network on any random Windows computer and then opens the Intranet App in a browser of his choice. The Coldfusion App checks to see wether the users USERNAME exists in the Active Directory Structure ... and then using the USERNAME will open the App with the proper security restrictions that the App database has associated with that USERNAME. This is my problem... at the moment: How does the client side let the App know what the UserName is? cgi.Remote_User is always empty... as is cgi.Auth_User. Clearly I'm missing something in my assumption about Single Sign On. Anything you all might be able to offer is readily consumed and greatly appreciated. I've googled my fingers raw for days reading everything I can fin

Hello,This situation affects a ColdFusion Project that is located on a network drive. It doesn't matter if I create a Default Linked Folder or not during the setup process. This problem does not seem to occur with other types of setups, including local file locations, or even other projects located on the network.*In this scenario, on two separate installs using 64 bit Windows 10 with CF Builder 2016 Build 302777, CFB hangs for a minimum of 15 seconds as it tries to populate the "suggestion drop down" after entering essentially any code that ColdFusion Builder thinks it can help me with. It happens after typingvariables.application.session.<cfset (in many cases)<cfset variables.<cfset application.<cfset session.This "ColdFusion Project" has about 100 files in it. (It's a Mura plugin.) I can get around this issue if I copy the entire project folder to my local drive, but that workaround doesn't seem realistic or ideal. Is this how CF Projects are to be set up in CF

I am trying to get the 'request method' (POST, PUT, GET), but somehow it doesn't work.On localhost I do get the request method used back correctly, only on our server it always returns 'GET'.When I put the code on the server in a different folder I do get the method back.What should I be looking for that might overrule or change the 'request method'?Tested with: GetHttpRequestData().method and cgi.REQUEST_METHODUsing: PostmanOn ColdFusion: 11Background: working with CF11 but without CF11 devs. trying to maintain code from my PHP experience.Any help would be greatly appreciated, thanks!

This is the API page Reports.getInactivePages (Method)  and this is how to invoke the API Invoking the API Using ColdFusion . However, I want to use the QueryRowLimit=0 to return all the records. This is what I have.<cfset inactivePagesReport = Server.CommonSpot.api.getObject('reports')><cfset inactivePages = inactivePagesReport.getInactivePages(0)><cfset records = inactivePages.QueryRowLimit = 0 ><cfdump var="#records#" >This is not working. It got this error: Attempt to add a field to a locked structure of type 'Reports_GetInactivePages_Result'

I am trying to get a sandbox PayPal IPN working with the Coldfusion example shown here:https://github.com/paypal/ipn-code-samples/tree/master/coldfusionI've added the location of my IPN file to PayPal and the page is being called by it but all I get is a 'Connection Failure' message in the text file. The IPN file is being called from an https location so not sure what is wrong. Any ideas?

My application requires client certificates at the root level.  Some functions within my site use cfhttp to contact another server that also requires client certificates.  Is there any way to pass the user's certificate on to the other server via cfhttp?  The only solution I can find is to use a specific cert file that exists on my server's file system to send via cfhttp.What I'm looking for is a way to do something like:<cfhttp url="http://www.otherserver.com" clientcert="#cgi.cert_subject#">...but clientcert is looking for a static file in pkcs format.

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