ColdFusion

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')

Hello, all,I noticed that starting in CF11 you can encrypt emails via CFMAIL.  But from the Adobe Help Page on CFMAIL, you have to have the recipient's PKI certificate on your server and provide the path to that cert.  Is there not a way for CFMAIL to reach out to a PKI and get the public key of the recipient?V/r,^ _ ^

Hello, all,I had a bookmark for CFML Repo (by Gavin Pickin), and it no longer works.Has CFML Repo been moved?  Or decommissioned?V/r,^ _ ^

Hi,I've installed coldfusion 2018 on windows server 2016 and added 2 websites in IIS one is loading coldfusion page fine and second one is throwing 404 error physical path of both IIS websites is same C:\inetpub\wwwroot\ Any idea what would be going wrong ? Hosting server is AWS EC2 windows instance.Thanks !Sikander

CF developer needed to help with small project for start-up dental technology company. Under guidance / direction of senior developeremail wnaso@biteline.net

Hi,I am using cfparam in the following fashion.<cfparam name="sort_col" default="FirstName" type="regex" pattern="((?i)FirstName|LastName|mEmail|mTelephone)">Basically I am trying to whitelist the sort_col variable to one of these in the pattern. Later in my code values come in from a form where I set this value. My assumption was that if i tried to set it to something other than one of the values in the pattern then it would crash out. This doesnt seem to be the case though. It gets set to whatever comes in via the form. Can anyone confirm this?Regards,Paul

Hello, all,Has anyone used CFPOP for retrieving email from a gateway?I've been tasked with researching this.  I've never used CFPOP for anything.  Does it retrieve only new emails?  Or does it get every email, read and un-read?V/r,^ _ ^

Received information that a vulnerability (CVE-2018-11776) has been identified for web-based applications with the Tomcat, Apache and Coyote frameworks. We are currently using ColdFusion 10,283111 and I am not sure how to verify if we are at risk or not.  Anyone know how I could get that information or find out if that vulnerability is applicable to CF10?More info on the CVE:CVE-2018-11776 is a remote code execution flaw that allows an attacker to gain control over Struts-based web applications.