Questions

How would I attach files to my cfpresentation?

Hi,I am using cfchart for generating chart, but xml content  for styling  is not working on coldfusion 16 but it is worked in CF10.Error . Is there any way to fix this.

Hi,First off, I have an issue where my CF 10 cfchart is requiring the style attribute to be a json file.  From what I can see, this wasn't supposed to happen until CF 11, and there seems to be no way to set it to take an xml instead.Secondly, I have not been able to successfully convert the xml to json myself, and nor do I find the cfchart_xmltojson.sh/bat utility, which I also gather is for the CF 11 release.  Thus, if anyone has either some conversion rules, or this script linked somewhere - would be a great help.I am also in the process of trying to run the full webcharts3d generated file.wcp, but that seems to be failing for another reason, i.e. “Class not found: com.gp.api.jsp.MxServerComponent”, (though the correct jar(s) seem to be in place), though that might be a better subject for a separate thread.Thanks!

Hello, all,I have inherited a project that (sadly) uses CFFORM and some of the related elements, including a CFTEXTAREA with richtext="yes" attribute.  This application will take the text from an online news article and insert it into a database to be displayed on a local restricted webpage (with a link to the actual online article), as well as generate an email with all of that days entries and send it to a list of people who are signed up to receive said email.The datatype for the article text is CLOB (Oracle 12g).  The pages are set to UTF-8 encoding.  I believe the email is also set for type="html" with UTF-8 encoding.Every so often, text is entered that contains characters that FireFox v52.x.x and IE11 don't like, and are replaced with a black diamond icon that has a question mark inside it.  I believe this is happening with just apostrophe, but I can't swear to it.What is happening, and how do I correct it?V/r,^ _ ^

HI all,First off, thanks for any help you can provide.I'm using cfspreadsheet to create an xls report. One of the sheets (xls tabs) has a summary report which will display some values from different sheets. I see that there is a function to get cell values - SpreadsheetGetCellValue(spreadsheetObj, row, column) - this seems to only get values from cells on the same sheet.Am I overlooking something?Thanks

I am running CF2016 with MSSQL 2016 Express Edition on a development server.I have the following script:<cfscript>     bLoggedIn = createObject("component", "cfide.adminapi.administrator").login('#cfadminpassword#');     myDatasourceObj = createObject("component", "cfide.adminapi.datasource");     if (bLoggedIn == FALSE)          writeoutput('not loggged in');     else          writeoutput('logged in');     //cfdump(var=myDatasourceObj.setMSSQL);     myDatasourceObj.setMSSQL(          driver="MSSQLServer",          name="my_dsn_name",          host="localhost",          port="1433",  &nb

Hi,I need to upload an image from my computer and convert(cast) it to varbinary and store it in my SQL table's IMG(varbinary) column.I tried somethings but i always get new errors.First i tried to choose img on html page and then UPDATE NULL column on my already created data's.html page<cfform action="#request.page#?event=do.test.abz_upload" name="upload" method="post"><input type="file" name="fpic" accept="image/*"><cfinput type = "submit" name = "Submit6" value = "Yükle"></cfform>action page<cfquery name="upload" datasource="test">DECLARE @10607085 varbinary;SET @10607085 = CAST(#fpic# AS varbinary); <!--- also tried CONVERT --->UPDATE dbo.FILMS SET IMG = @10607085 WHERE FILM_ID = 3 ;</cfquery><cflocation url="#request.page#?event=vi.test.abz_test" addtoken="no"><cfquery name="upload" datasource="test">UPDATE dbo.FILMS SET IMG = CAST(#fpic# AS varbinary) WHERE FILM_ID = 3 ;</cfquery><cflocation url="#request.page#?event=v

Yesterday a new CF11 server that we are prepping for production started spitting out these exceptions while performing a site security scan:java.lang.IllegalStateException: Cannot create a session after the response has been committed In googling I found some references to some Tomcat issues but nothing regarding ColdFusion. I know CF11 uses Tomcat but I have no idea what the error is or how to fix it. Anyone have any experience with this error and if so, details please...Stack trace is as follows, if it helps:java.lang.IllegalStateException: Cannot create a session after the response has been committed at org.apache.catalina.connector.Request.doGetSession(Request.java:2925) at org.apache.catalina.connector.Request.getSession(Request.java:2301) at org.apache.catalina.connector.RequestFacade$GetSessionPrivilegedAction.run(RequestFacade.java:216) at org.apache.catalina.connector.RequestFacade$GetSessionPrivilegedAction.run(RequestFacade.java:205) at java.security.AccessController.doPrivi

I am trying to format an excel sheet using vbscript.  This script works fine when i execute it in the server.  But when i call this script from my CF component file. This script call does not show any error or success.  Environment:  ColdFusion 11, Windows 7 , 64 bit Machine.After checking some threads on office automation I found this .We have to add the Desktop folder in the systemprofile and system32 folder to open file by Excel if you have Windows Service or IIS on Windows 7 x64 (dev machine) and Server 2008 x64.So I added Desktop folder under these 2 directories - C:\Windows\System32\config\systemprofileC:\Windows\SysWOW64\config\systemprofileI tried this as well.  Still no success.  Any suggestions??VBScript Call from ColdFusion:---------------------------------------<cfexecute name = "C:\Windows\System32\cscript.exe" arguments  = "//Nologo #GV_SCRIPTPATH#" timeout="50000"  variable = "savedOutput"></cfexecute> <cflog text="#

On the following page, none of the links work:ColdFusion Help | Method summary No matter what method's link you click on, it gives you an "access denied" error, telling you that you do not have permission to view that page.If you look at the URL it tries to send you to, it starts with "helpx.stage.adobe.com" -- if you remove the word "stage" from that URL, then you can go to that page.  So clearly the links on the main page are broken -- they're sending you to the wrong URL.Hopefully someone from Adobe will see this and be able to fix it.Thanks,L.

Hello every body. There is 7h that I search, I try examples from your forum or from other blogs or google without finding a solution to my problem.I explainI have a form which contains the result of a search. On this result, you have a "trash" icon per item where the user can delete the selected record.When he click on the icon, the system use a call ajax for deleting the record.code:jQuery('a[id^=Del_]').click(function(){     var id = jQuery(formfield).val();     var response = confirm("Are you sure to delete the current record ?");     if (response){          jQuery.ajax({               url: 'urlevent=MyfunctionDelete',               type: 'POST',               cache: false,

Hello, all,I'm working with SpreadsheetNew and SpreadsheetCreateSheet, populating from a query object.I've experienced something that I've never seen, before.  If you have a Spreadsheet object and try to add a sheet to it using a name that already exists, CF will abort.  I finally got it to email the reason to me.  "The workbook already contains a sheet of this name."I am sorting the data on the column (FQDN) that I am using to name the sheets with.  I'm removing "http://" and "https://" from the FQDN and using "www.example.com" as the sheet names.However, I did not expect for there to be "http://www.example.com" AND "https://www.example.com", so when CF creates "www.example.com", populates the sheet, then tries to create "www.example.com", again, it just stops.I am not seeing any CF Spreadsheet(blahblahblah) commands that will check to see if a sheet already exists.I will try to modify the query so that both standard and encrypted FQDNs fall into the same group, bu

Hi,I encountered a very strange occurance where- IsBoolean("123D")  returned falsewhile- IsBoolean("123D   ") return true The difference in the first and example is additional spaces in the 2nd example. One would expect both results to return false. Can please explain why the 2nd example returns true? It is perplexing to me. Coldfusion 9.0.1.

Hello, all,We've been getting a ton of bots hitting our components folder, and each hit generates an email letting us know that someone/thing was trying to access a component directly.The boss wants me to look into what we have to do to get our components folder out of webroot, so the bots can't reach the CFCs.My primary concern, however, is that if we do that, then any- and everything that submits a form to a CFC via AJaX will stop working.Is there a way to move the CFCs outside of webroot, but still use AJaX to access?  I have a feeling the answer is 'no'.  V/r,^ _ ^

Can't figure out why in two cfwindows created from main page, calendar in cfinput type="datefield" behaves differently depending on ORDER in which they created. Calendar icon became inactive in the second window if the first one was called and then closed. (The input field is still active for manual data entry). But if main page refreshed it's active again. In the first window the calendar active at any time without refreshing main page and when called in any order. These 2 windows are identical. Bahavior is the same with any settings of cfwindow attriburtes like refreshOnShow (true or false) and others. And if to switch the order of windows creation in main page, the calendar in the other pop-up window became frozen and first one previously inactive works fine. Is it a bug in CF8? This is code in main page: <cfajaximport tags="cfwindow, cfform, cfinput-datefield" > <cfwindow title="WindowName1" name="MyName1" height="380" modal="false" refreshOnShow="true" initShow="

Currently, we are doing migration work with ColdFusion2016. After opening wwwRoot and opening the page in the browser, the following error occurred. Which file? I am not worried about specifying the cause because notation on what line is wrong is not done. How to display the part of the error? Please teach other solutions.  Value "onError" can not be converted to value

Hi all,Has anyone managed to figure out a way for users to log into CF Administrator using Windows accounts, rather than using local users created on each server with the User Manager? I guess my question is, is it possible to create custom authentication mechanisms for CF Administrator? We have quite a few servers in the same Windows domain, and I'm wondering if it's possible to grant access to the CF Administrators by using Windows group membership.We already authenticate to our intranet applications using AD and <cfldap>, so I'm looking to see if we can link the CF Admin login to AD in a similar way.A blue sky idea for a future version, maybe, but I'd be very interested to hear from anyone who has managed to build something to date.Many thanks,Mike.

We upgraded to CF2016, Red Hat 7 and are suddenly getting this in our apache logs:xx.167.xxx.6 - - [18/Jul/2017:09:28:49 -0600] "-" 408 - "-" "-" "-" 80xx.167.xxx.6 - - [18/Jul/2017:09:28:49 -0600] "-" 408 - "-" "-" "-" 80Lots of 408 errors with no URLs associated to them.   Coming from a large number of IP addresses, including my own.Does anyone have any idea what might be going on here?   No one is reporting pages displaying 408... but these messages must be in our logs for a reason.Thanks

In order to run the latest and greatest ( and somewhat tweaked) CKeditor version, I had the folder in CFIDE (...CFIDE\scripts\ajax\ckeditor) and used javascript in the  source file to call it rather than the bundled FCKeditor.I have been applying all the CF updates as they come and never run across this issue before, so posting in case it helps anyone else out.After running the updater for 12 from the command line -as we have the server locked down- on my Dev box, the folder was no longer there. Interestingly though, the last backup, named  12017ckeditor, was still in the directory.I figured this was good motivation to get 4.7 up and tested in dev, did so, fixed my other issue (multi-line titles in CFchart), and deployed the update on my production server.I again saw the ckeditor folder deleted from CFIDE\scripts\ajax. Copied over my new version from Dev and all is well.My only convern would be if this is a trend in updates to remove unexpected items it will make keeping the

Assuming that you are using AEM for ColdFusion docs, in String Functions, the link for REFind is pointing to staging rather than production.  This is causing and 'Access Denied error."E.g.: https://helpx.stage.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/refind.html Should be:https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/refind.html Fix and promote the node in CRXDE and the error should disappear.

I can't get cfpdf encrypt AES_256R5 to work it returns the followingAn error occurred during PROTECT operation in <CFPDF>.Error: The password provided is either wrong or does not have sufficient permission to perform this action.even if I use an AES generated key as newuserpassword it still shows this error.encrypt="AES_128" works, but I can't use the new  AES_256R5 or AES_256R6Any idea on what I'm doing wrong? I've tried newownerpassword and setting permissions, same result.<cfpdf action="read" name="mypdf" source="C:\APPS\\cfpdf\ThePDF.pdf" /> <cfpdf action="protect" source="mypdf" encrypt="AES_256R6" overwrite="yes"newuserpassword="re5XBKe+rBriu4UAQgvm7A=="destination="C:\APPS\\cfpdf\newPDF.pdf" />

I have a fully patched, fresh install of Windows Server 2012 R2IIS 8 CF 11 Standard I installed CF 11 as per the CF 11 Lockdown guide and the CF Administrator came up fine.I went though the CF 11 Lockdown guide, applied hotfix 12 via the the CF Administrator and when done I went to start the CF Administrator site on the builtin web server and I got a 500 error. See below http://127.0.0.1:8500/CFIDE/administrator/index.cfmI went through all the settings and permissions in the lockdown guide and all looked to be in order.After googling a bit I uninstalled the hotfix 11 and the CF Administrator site came up and all worked fine. I went and reinstalled the hotfix manually and got the same error. See below.I tried this several time to no avail. I also tried to install hotfix 11 and even hotfix 10 and still got the same error.I have been all over google trying to find a work around and even tried reinstalling the web connectors as per Charlie Arehart's article ( am willing to try anything at

After installing ColdFusion Builder, I noticed that you can simply use the defaultLocal server or alternatively you can add another server.In my specific case I'm experimenting with a development workstation, however being that I only have a license for ColdFusion Builder 3, I don't have an option to configure the server for ColdFusion 2016. After speaking with an Adobe technician, I was told that I could install ColdFusion 2016 separately (on the same workstation) and simply set the ColdFusion 2016 server as my external server in ColdFusion Builder 3.This brings me to my next point, are there any benefits of including an external server even though it's installed on the same development machine, or should I simply shell out the extra capital for a ColdFusion Builder 2016 license?The pros vs. cons is what I'm looking for here.

Good morningI have been unable to get a definitive answer on this issue, and have spent hours on hold.I am in the process of Rehosting some virtual machines from one data centre to anotherthe Virtual machine will be replicated from one datacenter to the other with DoubleTake, and will have a new IP and MAC addressThere is some concern around the Cold Fusion licencing.Is it tied to IP or MAC address at all?CheersSteve

Hi Cfer's,Below I insert a request to the WSDL, to verify if in that city, date are holiday.<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://service.holiday.url.com.br/">   <soapenv:Header/>   <soapenv:Body>      <ser:methodName>         <!--Optional:-->         <startDate>20/04/2017</startDate>         <!--Optional:-->         <finishDate>22/04/2017</finishDate>         <!--Optional:-->         <cityCode>34120</cityCode>      </ser:verificaPeriodo>   </soapenv:Body></soapenv:Envelope>When I send to SoapUi the response is perfect, bu