ColdFusion

Hi,Is there away in Cold Fusion2016 to encrypt the contents of a create Excel file, either completely or by cell?Then allow the user to de-encrypt the Excel file after it has been created?Using the following to create an excel file. <cfset TabChar = Chr(9)><cfset NewLine = Chr(13) & Chr(10)><cfheader name="Content-Disposition" value="attachment; filename=reports.xls"><CFCONTENT TYPE="application/vnd.ms-excel" RESET="Yes">Thanks in advance,Mike

I have these mappings setup in my cfadmin for a PROD version of a website. They work fineNow I am going to create another site on the same CF2018 server, an almost mirror copy of this PROD site, but it will be a TEST version, named, GenCORP-TESTI understand I am going to need to do mappings like I did for my PROD site.I understand I'll need to use this.mappings for both the PROD and TEST versions of the site.And I will need to remove these existing mappings.I understand that the code goes into the application.cfcHow would I code a few of these mapping rows from above in PROD and TEST?and then would it start like this in the application.cfc<cfcomponent>  <cfscript>    THIS.name = "myName";    {etc.}    THIS.mappings = StructNew();    Then what??  </cfscript>

CF 2016MS SQL 2008Windows 2008 ServerI am trying to move my MS SQL database to a separate VPS which will sit within a private network.The new VPS server has been given the internal IP of 192.168.1.1 and the CF server has the internal IP of 192.168.1.2, these are on secondary adapaters, they also have their public IP's.I mapped a drive from the CF server to this new VPS database server and I was able to remotely browse the hard drive, so I know the connection between the two is functioning.I then went to the CF admin to try and connect to a test database, but I'm getting nowhere, all I get are timeouts trying to connect to the MS SQLI had made sure that SQL Server Browser service is running on the new database VPSRemote connections is also checked within MS SQLI also tried creating a new user within SQL and then using those credentials to connect.I've made sure the ports 1433 and 1433 on TCP and UDP are both open on the firewall for both servers.When adding the SERVER value in the conne

Can someone help me write a simple program?I want to create a program that allows my users to enter the temperature in Fahrenheit and get it returned in Centigrade, be able to enter miles per hour and get kilometers per hour and enter inches and get centimeters or enter yards and get meters.

MacOS Sierra plug-in configuration a qualified success.  However, I have no CFB perspective.Install log says:Installation: Successful with errors.6454 Successes0 Warnings2 NonFatalErrors0 FatalErrorsNon fatal errors being two occurrences ofModify Text File - Single File:   /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Eclipse/Eclipse.app/Contents/Info.plist                          Status: ERROR                          Additional Notes: ERROR - Unable to locate ASCII text file to be manipulated. Deferring...Indeed there is no such file, whereas there is a file /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Info.plist.  At the install log errors referenced path /Users/barrygbrunning/eclip

Hoping someone can help with this issue! I've set up ORM settings as below and my model is set up as listed. However, when utilizing, I keep getting an error that ID already exists and it appears CF is using hibernate_sequence instead of the sequence I'm specifying.  Furthermore, even with savemapping=true, it is not creating any hibernate xml files (supposed to be in same directory as models).I'm using Postgresql as the DB. I've tried restarting / different settings (even different JDBC drivers), etc without success. This code was working fine with CF10 and trying to upgrade (unsuccessfully) to CF2018. this["ormsettings"] = {      datasource = "db_icp",      eventHandling = false,      logsql=false,      savemapping=true,      cfclocation = application.mappings["models"]}; component name="logins" entityName="logins" persistent="true" table="logins"{        prope

So... finally got the lockdown issue all sorted out... but...Now when I try to access the .cfm test page I get:HTTP Error 404.2 - Not FoundThe page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.Detailed Error Information:Module   IsapiModuleNotification   ExecuteRequestHandlerHandler   ExtensionlessUrlHandler-ISAPI-4.0_64bitError Code   0x800704ecRequested URL   http://127.0.0.1:80/Physical Path   D:\DATA\SITES\DefaultWebsiteLogon Method   AnonymousLogon User   AnonymousAny ideas?The page worked just fine before the lockdown tool was applied.

I am downloading CF2018 30-day free trial from hereDownload Adobe ColdFusion free trial | Adobe Coldfusion (2018 release) Is it still like its been in the past where after the 30-day trial it automatically goes to a single user version?

Hi,Sorry if this is a dumb question, I'm new to this.I have a form where i want the user to be able to upload an image from a form.  for the cffile i'm using<cfif len(trim(form.ImageData))>  <cffile action="upload"     fileField="ImageData"     destination="\uploads"     nameConflict = "MakeUnique"></cfif>it works locally when i input the specific directory on my hard drive but when i use the above online i get an access denied error and it looks like it's trying to save it locally on c:\uploadson my ftp i created an upload folder but I don't know what the 'destination' field typically looks like when you are trying to use cffile on a live site.  What information do i need from my web host to make this work? Like, does it involve an ip address?  I'm thinking some kind of username and password will be required.  does cffile have username password field too?  Basically, what shoudl

Server side, I am using developer edition on a Windows 10 64 bit VM.  I installed CF using the Developer Profile option, with defaults selected. Client side, web browser is Chrome on MacOS XYes, I am an admin on the box.Yes, I ran the installer as admin.Yes, I tried to run the CF service under a local admin account.No, there is no error in the console.Yes, /cf_scripts/scripts/chart/cfchart.js is loading as it should, though with a 304 response code.format="png" is working.Any ideas?Thanks!Alberto

HiI'm trying to implement CFCProxy as per the following tutorial ColdFusion Help | Enhanced Java integration in ColdFusion. It works if you call the JAVA from ColdFusion then call the CFC from JAVA but I would like to call the CFC straight from Java instead, is this possible?When I try and it I get the following error:runtime error. coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. at coldfusion.server.ServiceFactory.getRuntimeService(ServiceFactory.java:117) at coldfusion.cfc.CFCProxy.<init>(CFCProxy.java:119) at coldfusion.cfc.CFCProxy.<init>(CFCProxy.java:73)Thanks for your help!

HelloI see that you have approved my blog post " Is Lucee CFML now better than ColdFusion?" However, when I click on the link on the first page (home) it says that it's not available. What could be the issue here?Thanks

Hello, all,I'm in the middle of moving all my stuff from my old, dying development system to my new development system, and in the process I'm also switching from CF10 to CF11.I've finished the CF11 install, and can get to the CFAdmin page with no problem.  However, I have about 40 DSNs on my old dev system that I need to transfer to my new system, and I really don't want to manually enter everything.I've seen posts online about taking the old neo*.xml files and "place them where the new install can find them" then tweak another .xml file to re-run the migration wizard.  That didn't work, for me.  It just broke my CF Server.  I restored the original .xml files and rebooted - that at least got me back to where I was.Are there any other ways with which to xfer all my DSNs from my old system to my new system??V/r,^_^

Trying to install CF 2016 and putting in new serial number.  It then asks for previous serial number but won't accept what I put in even though I copied and pasted right from my products on the adobe site.  Please help!  Time sensitive and the phone lines seem to be closed till Monday morning.

Hello,I have a graphing routine that charts with a grade description as the item column and the count for each as the value column, I am using cfchart and cfchartseries. I am using a .json file for the styling. A graph is produced for each student, with an arrow (using Zingchart labels) pointing to the students grade. I use cffile to write the chart to a .jpg.We are currently at CF - 11,0,13,303668 (Update level 13) and Java Version: 1.8.0_25. This routine runs once a year and has been working fine for a few years now. Last year at this time, when it ran successfully, we were at CF 11, Update level 12.Upon running this graphing process this year, the graph is produced fine, but the arrow is stuck on the left side of the chart. It is almost as if the charting engine doesn't know what node to point to.Here is the CF chart code....  <cfchart showygridlines="yes"                    &

Hi,I'd edit my cffile discussion but it won't let me for some reason.I had been using cffile locally but I realized I probably need to use CFFTP.  My question is, when I create a file filed in a form, how do I connect that to a CFFTP putfile action?  Like, what do I put after localfile = and remotefile = if the file is coming from a form?  And can i use nameConflict = "MakeUnique" within the CFFTP putfile action?Thanks,MIkeedit: so now I'm learning that cfftp only uploads files from the coldfusion server to the directory.  What if I have a web host and don't control the coldfusion server?  Is there still a way for a user to upload an image onto my site?  What information would I need from my web host to do this?

New install on new server, migrated settings manually via the cf11settings folder and run migration task.In CFAdmin, on the Server Settings page, I get:An Error Has OccurredSomething isn't working properly. We apologize for any inconvenienceIn my error alert, I see:An error occurred: https://servername/CFIDE/administrator/settings/server_settings.cfm?Time: 7/30/18 12:02 PMError - structBrowser Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.75 Safari/537.36DateTime {ts '2018-07-30 12:02:40'}Diagnostics Variable ALLOWEXTRAATTRIBUTESINATTRCOLL is undefined. <br>The error occurred on line 1104.I have looked at neo-runtime.xml for anything amiss (looks fine at a glance) and I am unable to open \\ColdFusion2016\cfusion\wwwroot\CFIDE\administrator\settings\server_settings.cfm in a text editor, I presume it is encrypted. I am by no means a CF aficionado, just a sys admin upgrading for our developer.I had to recreate data sources, they imp

https://www.quackit.com/coldfusion/tutorial/https://www.learncfinaweek.comhttps://cflib.orgHTH,^ _ ^

I have a site where users can fill out reports.  The admins have the ability to control the questions.  So, I'm using GetSafeHTML() when I show the questions because there are some questions that have bulletted lists and EncodeForHTML when displaying the answers.  That all works fine when displaying the questions and answers to the screen.  However, the user also has the option to save the report as a pdf.  I'm using cfdocument to create the pdf.  My problem is that anything with GetSafeHTML is showing the html (ie <ul><li>, etc.) for the list instead of just displaying the bulleted list.Anyone else having similar problems?  Any thoughts on work arounds?  I am thinking of using IsSafeHTML and only displaying if it is safe and no longer using GetSafeHTML to display.  Anyone deal with this differently?

As I look for hosting for my website, I have been asked if I want ColdFusion 11 or ColdFusion 2016.  The ColdFusion project I have was done while I was in school in the fall of 2016 and I am not sure which version it was done in. Is there any way to tell? I no longer have access to the school server.Thank you!

I have a 500 page document that is styled with css. The cfdocument tag is working perfectly to produce the styled text. When I add cfdocumentsections to get bookmarks, the css no longer works.I am using CF 9,0,1,274733 Enterprise on IIS7. The content is contained in Mura.

Hello, all,We have recently started receiving a TON of error emails that include the following.  We've never seen this error message, before.  Is anyone else familiar?EXCEPTION - structADDRESS_NOT_DEFINED107 ARRAY_HEADER_ERROR310 ASSERTION_FAILED1 AUTHENTICATION_KERBEROS5_FAILURE325 AUTHENTICATION_KERBEROS5_MUTUAL_AUTH_FAILED327 AUTHENTICATION_KERBEROS5_NO_CONTEXT326 AUTHENTICATION_KERBEROS5_NO_TGT324 AUTHENTICATION_STATUS_FAILURE307 BAD_PKT_TYPE204 CONNECTED_ALREADY201 CONNECTION_STRING_NULL208 CONNECT_DATA_MISSING105 CONNECT_STRING_EMPTY120 CSTRING_PARSING101 CauseEXCEPTION - structMessageAddress already in use: connect StackTracejava.net.BindException: Address already in use: connect at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractP

I created a fun utility for employees of my company by which I use the RandRange function in Coldfusion to choose an area restaurant for people standing around wondering where to go for lunch.  Believe it or not, it has taken hold and people are using it to choose where to eat at company locations around the country.The code queries the database for all possible restaurant selections for a given company location. I use the randRange function with the dbQuery.RecordCount value to determine the chosen record number.Then I loop over the restaurant query comparing the dbQuery.currentRow value to the randomly generated number from earlier.  If the currentRow equals the randomly generated number, it is displayed as today's choice.  Everything seems to work great with the RandRange function in the scope of a single user / single PC.Now the issue a co-worker and I discovered recently (and fortunately I'm not using RandRange for any other real purpose):When we both reload the pag

I have an application that uploads files and it works great.But when the user selects a file to upload the user cant tell that they have selected a file to upload.See here. The user has selected a file but there is no indication of this.See how in this example I can see the selected file to upload...upload.pngHow do I show the selected file?

I have a scheduled task in CF 10. It has been running successfully however, now it runs but actually it does not. The scheduler log says it is triggering but actually does not. When the task's URL accessed directly from browser the CF page actually get executed.The scheduled task calls all other tasks using CFHTTP.Any advise would be of great help on what could be the issue with scheduled task. I have restarted the CF instance with no success. The log set in the task says "Connection Failure".