ColdFusion

I am using GetHttpTimeString() function to get the current date and time in UTC/GMT. But when I format it using DateTimeFormat, its returning different results:In CF2016, when I do this:<cfdump var="#GetHttpTimeString()#"><cfdump var="#DateTimeFormat(GetHttpTimeString(), "yyyy-mm-dd HH:nn:ss")#">it will return:Tue, 18 Sep 2018 17:44:27 GMT --> UTC2018-09-18 17:44:27 --> still in UTCIn CF2018, when I do this:<cfdump var="#GetHttpTimeString()#"><cfdump var="#DateTimeFormat(GetHttpTimeString(), "yyyy-mm-dd HH:nn:ss")#">it will return:Tue, 18 Sep 2018 17:44:27 GMT --> UTC2018-09-18 12:44:27 --> current date/time in my timezoneUnless I pass a third argument for the timezone, it will use the server's timezone by default.Is this an intentional change, if it is, I can't find anything in the 2018 Release Notes.Thank you!Ollie de Guzman

Hi, Is there an updated version of the: ColdFusion11_CFMLRef.pdf with the new tads/functions on 2018?Thanks

Hi I have the variables set <cfif orderID = 5>      <cfset stype = "'ABC124','DEF567'"><cfese><cfset stype = "'VACD123','KHOL567'"></cfif><cfquery name="qQuery" datasource="#ds#">select .....from............where ......and serie in in ('#stype#')</cfquery>when out put the query, I got below (1) which is not right because nothing returned.  When i run the query and hard code like 2 I got records.  What did I have wrong here? Thanks1) serie in ('''ABC124'',''DEF567''')2) serie in ('ABC124','DEF567')

I receive the error: "Entity input stream has already been closed" when accessing my REST web service performing a GET operation.  Any insight to this problem would be much appreciated.

I upgraded to CF2018 from CF2016, running on a Windows 2016 Server with IIS. I am using subdomains.  Example: A user logs into app.mydomain.com using cflogin and they click a button to create a batch of work to do.  The button click launches an ajax remote call to job.mydomain.com to setup a job queue in the database sets a task in the CF Scheduler.The scheduler launches the job page on job.mydomain.com that queries the job info.  It knows what subdomain it was from and what user created it, so within a cfthread it executes a remote call to app.mydomain.com and does a cflogin allowconcurrent=true for the userid that was sent.  This way it can know the permissions and whether this user can process it.In CF 2016 it works great.  Upon upgrading to CF 2018 it logs the user out as soon as the scheduler runs and does the cflogin within the thread. Does anyone have any idea what might have changed from 2016 to 2018 that may have broken this?  Or any ideas how I c

All,I got my CF2018 up and running, nice and secured, with a copy of our production webfiles.  I am now attempting to apply hotfix-1 against the environment.I download the file from the updates area (our servers do not allow external internet connections) and attempt to run the jar but it seems to be failing in the pretasks stating I do not have sufficent privileges.  Basic info: Have full access to all drives impacted (read/write/modify)Have access to start/stop the service (windows 2016)I am using Oracle JDK 10.0.2 java.exe to run the command lineThe summary states: Summary-------Installation:  Cancelled during pre-install.32 Successes0 Warnings0 NonFatalErrors0 FatalErrorsSo it stats the user account should have rea/write privileges to the files in the CF root directory and to start/stop the service.  Yet the log starts I have all the access and each part is successful..  Is there a better log file than the one created during the .jar installation?

Is anyone experiencing any non-display issues with coldfusion maps/Google map API? I am using coldfusion 2016 on a windows 10 laptop. My maps are not showing up in real time on my PC or on my smart phone Whenever I make it live. It is showing up fine on my PC in the development mode. What I am trying to accomplish is to dynamically produce map markers based on the address of our club members. Could I be missing something?  Or is there an easier alternative to Google maps that I can dynamically produce the same results using another map provider? My application.cfc page <cfset this.googlemapkey="AIzaSyDy_iL-h-2CxckkV4dh-agNjbMLHFHu0pQ">On my locations.cfm page<cfmap name="fruit" height="300" width="1200" centeraddress="714 W. Main st. Richmond, va 23219">  <cfmapitem name="my_address" markercolor="cccccc" address="511 W. Marshall St. Richmond, Va 23220"><cfif #session.user_id# EQ "#scois_verify.scois#"> Google Maps<cfmap name="Fruit Map" height="600"

Hi,I am trying to implement session rotation using the article at https://www.petefreitag.com/item/829.cfm I have added the relevant code to onSessionStart and added the jeeSessionRotate function to a component which i call when the user has been successfully cleared to login. I have called the function immediatley before where I call sessionRotate(). Problem is im getting a "setAttribute: Session [844E2EA3A042B40B5EA2545FC43C07FA.cfusion] has already been invalidated"  error. Anyone know what I'm doing wrong here?Thanks,Paul

We need some SOLR collections for searching. To this point, we create the collection via the admin page, and thenwe configure the /dataimport in solrconfig.xml in the collection folderwe configure schema.xml in the collection folderwe configure data-config.xml for the /dataimport in the collection folderIs there a way for all these steps to be done programatically?I assume that the <cfcollection> tag creates a collection but does only what the admin interface does.Is there a way to do all this configuration via cfms/cfcs?

My goal here is being able to identify if a file is correctly formatted or not for reading in cfspreadsheet. Technically speaking "Does this file have these X columns? (yes/no)". I don't care how this is done... but I have no other means to do it than subject it to cfspreadsheet action="read".One of the biggest challenges when dealing with imports is getting clients to use "clean" files. I've run into several situations where they will "hide, merge, etc" columns and entire tabs. Recently a client attempted to update 100 records where a tab had been "hidden". There wasn't a lot of data and due to privacy I can't share that file, however I can confirm that something about this excel sheet would trigger incredibly high cpu usage until such point that ColdFusion would crash. cfspreadsheet details:adding query="" was the trigger to cause coldfusion to use high cpu and then crash so something about trying to build it's struct was the cause.the information provided by name did now show all th

Hi all. I am using orms, so my application takes a while to start (about 3 minutes)I would love to be able to display something to the user - e.g., Starting xxx, please wait...When I add a <cfoutput> as the first line of onApplicationStart (output=true), nothing displays (index.cfm is executed).If I add <cfflush> after the <cfoutput>, message displays (index.cfm is not executed!)Any ideas?

Good morning,i am using CF2016 on a window PC.At my job i  have the role of adding new hires into our card reader box so that new employees can enter into our office. I often can get up to 10 new employee request per day. I devised a rather complicated way of converting each character of their last name into a number format so that i can quickly punch their name info into nine-digit keypad of the card reader box. The letter arrangement of the key pad is similar a touch-tone phone.I currently have two Cf pages to do what i need. The first page is a basic form with 6 text boxes that will only allow 1 character per box for the person last name. the second page is a series of conditional statements that will assign a numerical value to each character.What i want to accomplish is to have one text box that i can enter the entire last name of the new employee and then have Coldfusion separate each character from the input box of the previous page and assign then display the same numerica

Hi,I'm having trouble figuring the logic on how I can output this information.Basically, I'm querying a yearly report from my database where some donors post as "Anonymous" per year. Problem is, once they give "Anonymously" at any given year, their name stops showing up, and appears as "Anonymous" for the following years, including the previous years as well.The list should only list "Anonymous" for the current year that it is pulling the information from, if they have given anonymously for that year. Otherwise, it should just show their name.I am not sure if I need to set the years as a loop and then set an "<cfif>/<cfelse>" statement. Any help would be appreciated.This is my code where it outputs the information:<td><cfif SalAnnRep_Ovr IS NOT "">#SalAnnRep_Ovr#<cfelse>#SalAnnRep#</cfif></td>The data that I am pulling from my DB:<cfquery datasource="gnConstituents" name="GetCon">SELECT IDCon, Ca_First, Ca_Middle, Ca_Last, Ca_Suffix, isSc

Surely we can't be the only ones who are disappointed with the newest charting engine in CF11?  Yes, ZingCharts can be cool and the plethora of style options gives us total freedom to build the perfect chart.  However, that is also the root of the problem!  Since CF8, CFCHART has been adequate for our needs.  It produced good looking chart images and was just flexible enough for us to produce what we needed while staying simple enough for us to put together quickly and move on in development.  This has been true up through CF10....We just installed CF11 on our test server and it has DESTROYED every chart we produce using the same code we've had in place for years. Custom chart colors: gone.  Readability: hit or miss.  3D angles and depths: changed.  Proper fitting of images in pages: gone.  Legends specifically told to hide: now showing, and showing incorrectly.  Labels: FUBAR.What the hell?!  Who was in charge of the backward comp

0down votefavoriteI have started my new single page application. So far I was able to create login/authentication process and build the templates for the Home.cfm page. While looking around the web I see that JQuery can provide navigation template for single page app. My current code is old fashion and here is what I have. So in root folder I have index.html and here is content of that page:<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="Refresh" content="0; URL=Login.cfm" /> </head> <body></body> </html>You can see the url in meta tag redirects to Login.cfm. First thing I would like for my website to show only web site name instead of what I have now:https://example.com/Login.cfmAfter user entered Username and Password in Login.cfm I will process authentication with Auth.cfc where I check user credentials. If they successfully pass that step I lead them to Home.cfm. This page is main page of my SPA. Then my u

I have some code that works perfectly well with one customer, but with another it's a total fail. They are telling me that the content type is not being sent.The goal is to send a XML data to them over SSL/Port 8443Am I missing something here that some servers react badly to?<cfparam name="form_timeout" default="5"><cfparam name="form_port" default="8443"><cfset objXml = createObject("component","xml2Struct")><!--- Request XML---><cfxml variable="xmlRequest"><?xml version="1.0" encoding="UTF-8"?><request><header><signature>BHNUMS</signature><details><productCategoryCode>01</productCategoryCode><specVersion>43</specVersion></details></header><transaction><primaryAccountNumber>9877890000000000001</primaryAccountNumber><processingCode>615400</processingCode><transactionAmount>000000000000</transactionAmount><transmissionDateTime>140223183057

Hello,Will CF2016 be adding SQL 2017 to support matrix?https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdfRegards, Carl.

Hi,We just installed Coldfusion 2016 on our Dev server, which was previously running Coldfusion 10.The includes work, database connectivity works, but it will no longer read .css files or image files, and I would guess any sort of static includes.For example running this code on the Dev (CF 2016) vs.our live server (CF 10):<html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title><link rel="stylesheet" href="test.css"  type="text/css" /></head><body><cfinclude template="includes/test/text.cfm"><img src="includes/test/banner_index.jpg"><img src="banner_index.jpg"></body></html>Works as expected on the live server but on Dev the cfinclude works but the css is not applied (and I assume read) and the images show up as broken links.In fact, the direct link to the image in a URL returns an "internal server error" messag

In my application an event gateway is used to generate PDF files (more than one lakh , 100000) for Arabic texts and English text. During this process we noticed that it is taking very long time to generate Arabic PDF files compared to English one. Say , when English PDF took few seconds Arabic PDF took few minutes.Have any one came across the same issue ever ? I feel that when text direction is changed (from LTR to RTL) it might be taking some more time time to generate. Any thoughts or suggestions or help is greatly appreciated.Also , we noticed that generating PDF for RTL texts is comparatively faster in CF16 than CF9. But ,at the moment , our client dont want to upgrade to CF16 from the existing CF9.

Hi everyone,I'm having an issue with a certain variable, that is within the scope of my CFOUTPUT.My variable, TEMPWHO, is not being run under the CFQUERY.If I put it outside of the output query, it will run, but nothing will show (since its a variable)However, when I put it inside of the CFOUTPUT query (as shown below), it gives me the error: 'VARIABLE TEMPWHO is not defined', and thus, won't be able to query the data in CFQUERY.Is there anyway to get around it? (The code that is bolded, is giving me the issue)  <cfset tempy = getems.RecordCount \ 2>  <cfset tempx = RandRange(1,tempy)> <cfif tempx eq 0><cfset tempx = 1></cfif>    <cfoutput query="getems" startrow="#TempX#" maxrows="1">  <cfset tempwho = EmailContact>   </cfoutput><cfquery dbtype="query" name="GetAll">  SELECT *   FROM GetNoms, GetStuds   WHERE GetNoms.EmailContact = '#tempwho#'   AND GetNoms.IDSt

Can someone help us to check if we can enroll our Coldfusion 9 and 10 for MA Support?

I know there are restrictions on the number of cookies that you can add to a browser, I can't remember the numbers from my tests a while ago, but I think it started to run into trouble at around 150.I have an issue where I am trying to delete 57 cookies but the browser goes into a loop, and then resets the connection, this is over HTTP. If I switch it to HTTPS, using HTTP/2 it works with no problems, but I don't want to have to rely on the HTTP/2.If I lower it a little bit I can get around 50 to work, but if I add other cookies or increase the loop to 57 I have the problemIs this a restriction in the browser or is there anything I can do in the CF admin to increase capabilities?This is how I'm doing it. Maybe there is a better way to just tell it to destroy ALL cookies. Although I also worry now about other parts of the site where I create cookies.** After posting this I went back to my local Win 10 development setup and tested it again, I found that I could delete well over a 100. I a

Hi all,I inherited an application and am stumped on sanitizing a dynamic query that is being flagged on a vulnerability scan.It starts with a CFINVOKE that passes parameters including tablename, column_names, conditionals.The function invoked then executes the query something to this effect...<cfquery name="updateMe" datasource="#myDBsource#">  UPDATE #arguments.tablename#  SET ...  WHERE #arguments.conditionals#</cfquery>Usually I would use the <cfqueryparam value="#arguments.tablename#" cfsqltype="CF_SQL_VARCHAR" maxlength="17"> in the conditional, but not sure how to handle when the dynamic part is the actual table name, column name, or conditionals.Thanks in advance for any help.

We had a troublesome intermittent ( 3x weekly ) fault over a six week period which usually occurred under peak load and was only temporarily "reset" by a CF restart.First the AWS Linux box CPU spiked to 100%Then CF struggled to make database connections and the database connections piled upRequests delayed upto 20 seconds +CF Server unresponsive and needed restartCF Restart slow ( 5m + )With help from a CF expert the problem was tracked to the inability of the JVM to get sufficient entropyThe fix is For clarification we simply change the highlighted arg from securerandom.source=file:/dev/randomTo -Djava.security.egd=file:/dev/./urandomand restart Coldfusion!

Hi, Custom CSS is not working in cfddocument and cfhtmltopdf, For Example: SentinelBook , I installed fonts in windows server and ColdFusion administrator font management as well.Paths everything is correct. It's working in browser but not  working in cfddocument.Please help on this solution.<cfdocument format="pdf" backgroundvisible="yes" pagetype="a4"  fontembed="no" localURL="yes"  > <!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title><!---<link  href="../fonts/styles.css" rel="stylesheet" type="text/css" />---><style>@1552174 url("..fonts/styles.css");@11220649-face {    font-family: 'SentinelBook';    src: url('sentinel-book-webfont.eot');    src: url('sentinel-book-webfont.woff') format('woff'), url('sentinel-book-webfont.ttf') format('truetype')