ColdFusion

Hi there,I'm new to CF and trying to format a timestamp but no matter what I try I am unable to get the DateTimeFormat function to work successfully so I am hoping that some one with more experience might be able to quickly identify what I am doing incorrectly. Goal: trim the timestamp <cfscript>     unformattedTime = "{ts '2018-11-05 12:13:50'}";     formattedTime =  DateTimeFormat(unformattedTime, "yyyy-mm-dd HH:nn:ss");       writeOutput(formattedTime);</cfscript>Expected Output: 2018-11-05 12:13:50Actual output: nothing

We upgraded from ColdFusion 11 to ColdFusion 2016 and noticed in the ColdFusion 2016 admin, Mappings, /gateway Directory Path is pointing to the ColdFusion11 directory, while /CFIDE is pointing to ColdFusion2016.  Is this the correct setting?  If not, what should /gateway be set to and are there any other places that need to be changed?Thanks!

Hello, all,Where I work, we have to adhere to a very strict set of security protocols.  It makes my job difficult, most of the time.  More so than any other job I've ever worked.We have to follow STIG guidelines, typically 300-400 pages of instructions.  One of these guidelines states that we have to use httpOnly in our application.cfc/cfm files.  We also set that in the web.xml file, so it should apply to all projects running under CF.However, we have been informed by our security experts that there is a finding.  While they do see that we are using httpOnly, they claim that all of the session cookies have the httpOnly flag set, one of them is missing the secure flag.  No mention of which one.What am I missing, here?V/r,^ _ ^

I recently upgraded my web application from Coldfusion 9 to Coldfusion 2016. Right now the two version coexist on the server (RED HAT). I have already shut down cf9 and removed all the old connectors. CF2016 can successfully talking to Apache and our web application seems working perfectly with cf2016. However when I trying to access the Admin Page through https://my_web_application_url/CFIDE/administrator/index.cfm​, the login page still shows cf9; after logged in, the logo at the upper left comer shows cf10; in the setting summery actually shows version 2016. The screenshots were attached below. Any help would be appreciated!

Hello,  I am migrating an application using an old version of Cold fusion(version 9 or before) and Crystal reports 8 to Windows Server 2016 and Crystal Reports 2013.  In the old application upon opening crystal reports the reports are launched within the browser in a new window. The same behavior is not happening on Windows 2016, I installed Crystal Reports viewer but this is working only when I use the Server to open and access the application. When I connect from other client PCs its not opening as it is looking for a Crystal Reports viewer on the clients. How to make it work like the old application where it would launch within the browser it self ?Syntax I am using is<form name="form1" method="get" action="report_view.asp"><script><cfoutput>window.open('Crystal_reports/ORA_rep1.rpt?prompt0=#session.multi_rep_id#&user0=#Session.UserName#&password0=#Session.Password#', 'CrystalReport', 'resizable=1,HEIGHT=600,WIDTH=800');</cfoutput>document.l

We had an issue recently that i needed to do a quick analysis of what emails were in undelivered folder.  For all my other servers i used the CF Admin to go to the Mail page and click "View Undelivered" which gives me to/from/subject in a table and a view to the formatted html in the messages.  All my servers but one.  That server throws the same error twice when i try to perform this action and then displays nothing.ERROR: Bind Failed, Element not found: mailitems [Enable debugging by adding 'cfdebug' to your URL paremeters to see more information]adding ?cfdebug after the url took me back to the administrator home page, but navigating again to mail > view undelivered mail threw the same errors but added no debugging.I have tried the following things to fix it:1. icacls on undelivr folder giving users full control of undelivr folder and all contents2. look for 0 length file in Undelivr folder - none found3. Clear all files from browser cache and historyCan anybody su

How can I troubleshoot and isolate a gradual build up of JDBC request to our database server (SQL) in CF 11. In the Fusion Reactor, the graph for JDBC starts to climb more and more. Slow web request start to build up also, and then overall web request response times (graph attached). I am an experienced Sys Admin but with little CF experience. I can provide more info as I'm sure it is pretty general. I have so far looked at network utilization (no latency) and resources at the OS level (memory, CPU and disk, NIC) are busy, but acceptable on both CF Servers (load balanced) and the database server. (I realize I need to look at the load balancer as well to be sure that is not having issues).When I restart the CF services, everything is fine for several hours even with a lot of connections/activity immediately resuming.  Is there anything I can do at the Cold Fusion level? To me, since physical network and server resources appear normal, it seems like it may be in the code, however I'

Hello,I'm trying to force my <cfselect> results to push content down on a page instead of overlapping. I've tried wrapping the <cfselect> inside of a DIV that has been styled with a CSS (accordion).The accordion works, however, when I click on the drop down results instead of staying within the confinements of the DIV the results simply overlaps everything. Has anyone tried displaying their results in another manner using an accordion? Or,Has anyone been able to force the drop down to push the page's content down so it won't overlap?Thank you.

I know I can format the output of a date using DateFormat, but when the user clicks the download button, it directly downloads an excel file.I have a date field in MS SQL  It is not a datetime, but just date.  If I download the field directly I get {ts '2019-01-02 00:00:00'}.I tried CAST(MNCDate as Date) AS 'Collection Date' but got the same thing.Can I modify the way a date is displayed in the output from the query?  I want mm/dd/yyyy.Thank you{ts '2019-01-02   00:00:00'}

Hello fellow CFers,The Stack Overflow 2019 survey was just launched. Each year they ask developers to share information about their jobs and what languages they develop in.  it would be great if the ColdFusion/Lucee community would participate and let them know you're an active CFML developer.Here's the link to the survey:2019 Stack Overflow Annual Developer Survey

I am in need of a good “dynamic form builder” that integrates well with ColdFusion 2016/2018. Any suggestions?

I was looking for a source/reference to help me implement our own event gateway type. I could not find out an example on the internet for the same.Can someone please help me on this with step-by-step details. Also, I would like to know, in which scenario we should go for a custom event gateway type.Thanks,

i have some code which reads a datetime field from an sql database and then formats it using lsparsedatetime.this has worked for years under previous CF versions and produces{ts '2018-01-11 08:00:00'} when passed2018-01-11 08:00:00.0read from SQL database.when passing this in CF2018 it refuses to format it but produces no error just the original 2018-01-11 08:00:00.0i have set <cfset loc = setlocale("English (UK)")>  on both machinesaccording to my hosting company the date/time settings are the same on both servers though the old server is running older versions of windows/iis/sql serverbut as the db date is the same when retrieved from both databases i can only assume CF is the issue?any help greatly appreciated

Good afternoon everyone Here is coldfusion9 company and want to use the 2018 version. Our file is application.cfm yet. Code in coldfusion 9 is compatible with the 2018 version ?? Thanks

Is it possible to pass a value to a datefield cfinput?I have an edit form that is auto filled from a database - I can fill text fields by passing value to them.  I tried value and default in the type="datefield" and it doesn't seem to work.<cfset ThisDate= "2016/01/20"><cfform id="Add" name="Add" method="post" action="UpdateDonation.cfm" >     <cfinput name="test" type="text" value="#ThisDate#"> <--- Works but no date picker     <cfinput name="test" type="text" mask="yyyy/mm/dd" default="#ThisDate#"> <--- date picker, but no date prefilled     <cfinput name="test" type="datefield" mask="yyyy/mm/dd" default="#ThisDate#"> <---- Gives error</cfform>    What am I doing wrong?Thanks!

Good afternoon. One more doubt. I have a server with 4 cores and I want to buy ColdFusion 2018 Standard.Will I have to buy 02 licenses?

I inherited some order entry websites that have worked seemingly flawlessly for the past 3 years. Today I learned that 3 files didn't get sent to a customer last week, and I can confirm these files they should have gotten were never created on the server. However, I can find no entry in any of the log files (C:\ColdFusion11\cfusion\logs) that would indicate what the issue was. I would have expected some kind of exception to occur if a file could not be created or is that not that case? This part of the code does not contain any cftry / cfcatch blocks. I'll include the relevant parts here:<cfset OrderPath = #GetTempDirectory()#>  <cfset DateTime = DateFormat(now(),"yyyymmdd") & "_" & TimeFormat(now(),"hhmmssllll")><cfset OrderFileName = ("WB" & "_" & #DateTime# & ".ORD")><!--- Check if order file exists - if so, delete it ---><cfif FileExists(#GetTempDirectory()#&#OrderFileName#)>     <cffile action="delete" fi

Here is the link for a really important survey for us here at Adobe. Your responses will help determine some of the potential future directions of the product.This survey is one among the series of future direction surveys posted by us. Irrespective of your participation in the previous ones, we need you to participate in this survey. Although not mandatory, it will be very useful if you can leave your contact information in the survey response for us to follow up with you.Here is the survey link again.Thank you for your time.

We have some positive news to share. Here is a blog post that addresses the concerns some of you may have regarding the Oracle Java policy change.Oracle Java support for Adobe ColdFusion - ColdFusion

Hello,  I am using Adobe ColdFusion (2018 Release). When I run a page containing a Crystal Report, the page appears blank, Crystal Reports (SAP Crystal Reports runtime engine for 32 bit and 64 bit are both installed).Can someone please help me in resolving this issue ?ThanksIQAdobe ColdFusion (2018 Release)Developer

We are getting the below error intermittently in Coldfusion 2016 error handler where REST service is used.I would like to know if this issue is due to network connectivity or SQL Server connectivity of max connection exceeded issue with ColdFusion REST Service.Error Occured At : UserValidation REST Service [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.I am not a ColdFusion expert. I would like your help to identify the root cause of this issue. Please Help.

I have a query that returns results like thisRow 1 -C,HU,NU,PO, CY, CABRow 2 - A,AB,AB,ABC,TY,GYU  So I need to combine these results into one string and then see if the string 'CAB' is in the new combined string.If it is, then output YesHow do I do this easily?

I recently installed Coldfusion 2018 Dev locally (to replace 2016) and everything seems to be working fine, except the Connectors section of the Performance Monitor doesn't show any data.I am not sure why and I cannot find the documentation to describe how anything needs to be configured for that data to show up.

HiWe're running ColdFusion 2018 Standard with Update 1 installed on a Windows 2016 server.When sending emails using <cfmail> we have two issues...1) We fire email frequently, but not heavily. Maybe 100-150 email per hour during the working hours. These emails are backing up in the /cfusion/mail/spool folder and clearing very slowly. Each one takes approx 6-10 seconds to fire, but it does fire successfully.2) In the Administrator > Server Settings > Mail > Maintain connection to mail server is not checked. When checking the box and submitting the form, the Administrator does not update this checkbox to stay on. When looking at the cfusion/lib/neo-mail.xml file this value selected as true.<var name="maintainconnections"><boolean value="true"/></var>Does this imply there's a glitch with the administrator?Has anyone any suggestions to help?Kind regards, Stuart

I am having a problem uploading multiple files at the same time. The site we are building is a catalog of sorts, and each item may have anywhere from 1-20 images.For this discussion, let's say we're uploading three imagesThe input on the form creates three cffile tags in the form, named img1, img2, img3. Those are working.After inputting the form, I see three distinct temp files. However, when the <cffile> tag runs, it only uploads the first file. Three times.I created output that would show all of the variables, and the output shows the three distinct images, but then <cffile> runs and all of the server variables are correct for the first image, but shown three times.Now, these file names also have to be written to a database, so I have to write the actual file name to the table, with time and date appended on it so that the file names are truly unique. Everything is working for the first file, it's the second and third that are the issue.The code that generates the input