ColdFusion

I upgraded from CF 9 and kept my session settings the same: J2EE session, in memory, 20 minute timeout, etc...When I have a second server in my load balancer under the same domain, I constantly get the following error from a remote call from flex.[RPC Fault faultString="Duplicate HTTP-based FlexSession error: A request for FlexClient '4367D6EF-970F-FD8A-7A93-DE6404812784' arrived over a new FlexSession 'BFD1464D0CB75194AA9BB6C3782986D2.cfusion', but FlexClient is already associated with  FlexSession '69A6912963789EC611F9037205FD70C4.cfusion', therefore it cannot be associated with the new session." faultCode="Server.Processing.DuplicateSessionDetected" faultDetail="null"]I've tried a lot of experimenting to see if there's something on the flex side or some new CF thing but I can't really determine.With this problem, I can't have more than one server in the pool at the same time; and I really need to.

When we use CFZIP to compress directories, we cannot use the standard MAC tool to open them on Apple computers.  Works fine on PC and works with some of the third party MAC tools.  Any ideas?Thanks,Dave

I upgraded Java to 1.8.0_144, due to the requirements of Update 5 for CF 2016 (I did not apply Update 5 yet). As a result of this upgrade cfdocument does not work. According to TS there is a known problem, when you get the same error trying to save system settings on Admin page in PDF file, but they did not hear anything about cfdocument. Below is an error I’m getting: An exception occurred when performing document processing.The cause of this exception was that: coldfusion.document.spi.DocumentExportException:java.lang.ArrayIndexOutOfBoundsException: 0It can be reproduced by simple:<cfdocument format="PDF"> test </cfdocument>. My server is RHEL 7 64 bit. I will continue to work with TS guys, just wondering if cfdocument works or does not work in similar environment for other people.

Does extended support include security patches?Thanks,Rob

I have code that reads an excel from my server and then converts to a query object and the loops through and inserts into an MSSQL table.<cfspreadsheet action="read" query="myExcelData" src="#path#" headerrow="1" rows="2-50000" />It works great.But only after I get the excel file from the server, open and save it, and then FTP back to the server.It works great.The problem is my client FTP's the excel file to the server using WINSCP.When I try and run the script on those files the client FTPs I don't get any records. It's like it reads the file but returns 0 records.I don't get an error message.Then I get the excel file from the server, open and save it, and then FTP back to the server.It works great.Any ideas?Very odd situation

WTF, Adobe??Why are you insisting that I use the Akamai Download Manager (which I never trust download managers) in order to download anything???Based upon advice of others, I have attempted to bypass it by clicking on the "File 1 of 1" link.  But that doesn't give me the CF 11 installation file.  It still links to "Adobe ColdFusion 11 - AkamaiDLM.exe".WHY CAN'T I DOWNLOAD ANYTHING WITHOUT THE DLM????????????????????^_^

There is a discussion in the ColdFusion forum that has a CFBuilder thread: https://forums.adobe.com/thread/2342940I'll try cutting and pasting the relevant info here:raksh naresh, I decided to force myself to use CFBuilder more to be able to provide you with additional feedback. A few things I did not realize CFBuilder did I found I like, but I still have quite a few issues. In no particular order:Global searching within a project is a pain starting with the fact that you can only expand one module at a time. It finds all the occurrences but I have not found a way to scan through all the hits for a specific pattern I'm looking for - I have to expand one module at a time just to see the match.The parenthesis and bracket helpers are great for typing code from scratch, but in my work I do quite a bit of cut & paste and adding a parenthesis to existing blocks is more keystrokes than the one-character the helper is saving.Same for single and double quotes.Selecting a block to indent or

Hello,I've noticed that cfparam and IsValid accepts a list of integers as a valid value when type="integer" is specified. Is this a bug, or the expected behavior?Example:I have a code like this on my pages to check the values passed,<cftry>    <cfparam name="url.n" default="1" type="integer"><cfcatch>    <cflocation url="error.cfm" addtoken="no"></cfcatch></cftry>And also tried:<cfif NOT IsDefined("url.n") OR NOT IsValid("integer",url.n)><cflocation url="error.cfm" addtoken="no"></cfif>In both cases, if I pass an url value like n=4 or n=string, it works as expected. With n=4, n passes the check, and the rest of the page is executed. With n=string, a string is detected and a redirection to error.cfm is called.But, if I pass an url value like n=4,14 then n passes the checks and the rest of the page is executed...  ???Using CF 8.01 over CentOS.

Hello,due to security patches we need to upgrade from CF10/CF11 to latest CF version.Is there any CF2017 to be released in near future?

Hi,I use coldfusion but i'm no expert i'm trying to populate 3 select field from a previous selection its year/vendor/model of cars to find the appropriate tire size.I manage to find some code to make the first 2 to load but the 3rd one the model doesnt work here is my code what M I missing or doing wrong ?<!DOCTYPE html>    <head>    <title>losd list test</title><CFQUERY NAME="getyear" datasource="dataname">SELECT DISTINCT yearFROM carmodelsorder by year DESC</cfquery><cfset Start = 1><cfset Start2 = 1><cfset Start3 = 1><cfset End = getyear.recordcount><script language="javascript">/*Fonction addLoadEvent  */function addLoadEvent(func) {  var oldonload = window.onload;  if (typeof window.onload != 'function') {    window.onload = func;  } else {    window.onload = function() {      if (oldonload) {   &

Hi,we have ColdFusion 10 standard edtition and just want to create a standard scheduled task with a Monthly interval or Weekly interval, how can I do that, keep getting the error above! And I really don't hope I need Enterprise edition for this simple task, it worked like a charm in CF 7 that we are upgrading to. Any workaround or hotfix?//RegardsMartin

I've recently been tasked with making some changes to one of our CFSEARCH functions (specifically, making it identify accented characters). Based on some unrelated work I've been doing with a standalone Solr setup, I figured out how to add filters to the schema.xml file in the collection folder so that those filters would be applied when I restarted Jetty. However, restarting Jetty rewrote my schema.xml file every time.Eventually I discovered the /jetty/multicore/template/conf folder. When I changed the schema.xml file there and restarted Jetty, that wrote my changes into the schema.xml files in each of my collections. Great! Problem solved! However, my question now is whether or not there's a way to override the template folder so I can have a different schema.xml file for each collection. Currently, I don't need to do this. I only have two collections, and they both need the same filters. But in the event I ever need to customize a schema without affecting others, is there a way to d

Hi there,my app use cflayout border,  cflayout tabs,  and bootstrap.In CF9  / 10 everything works like a charm, when i resize window responsive works but on CF2016 no.Please look at the code.<!DOCTYPE html><html lang="en">  <head>    <meta charset="utf-8">    <meta http-equiv="X-UA-Compatible" content="IE=edge">    <meta name="viewport" content="width=device-width, initial-scale=1">    <!-- Bootstrap -->    <link href="css/bootstrap.min.css" rel="stylesheet">    <!--[if lt IE 9]>      <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>    <![endif]-->  </head>  <body>      <cflayo

Hi,​​We have ColdFusion 10 installed and notice that it crashes constantly with the following error:​======================================​​Service Temporary Unavailable!​The server is temporary unable to service your request due to maintenance downtime or capacity problems. Please try again later.​Jakarta/ASAPI/isapi_redirector/1.2.32()​Copyright 1999-2011 Apache Foundation All Rights Reserved.======================================​​It did appear that Adobe have an update (fix) for the issue. We applied all updates to the server, but the problem still persist.​​Can anyone help?​

Hi,Is there a way of dragging in a JavaScript file reference into a page in cf builder.When I drag a file onto a line of code it just shows the name, not the path..something I miss from dreamweaver.

Hi,I had to install update 5 for CF2016 however it has stopped all out flah graphs from displaying. There is no error message just a blank page. If i cahnge this graphs to png or jpg format the do display however out whole app uses flash graphs...any idea how i fix this? Update 5 has to be installed on our server due to teh requirements of an internal pen test!

I just this morning purchased, downloaded and installed ColdFusionBuilder_2016_WWEJ_win64.exe. on fully-updated Win10 machine with plenty of resources.  During installation, it accepted the SN and went on to completion.  In trying to start/launch; however, it briefly appears in the taskbar and then quits/disappears and is not shown as running in the task mgr.  Where do I even start trying to figure out/remedy this?  I don't have all the time in the world to mess with this stuff. 

I would like to know why these two values are different.What is the correct way to convert a string to binary.<cfhttp url="https://image.freepik.com/free-icon/apple-logo_318-40184.jpg" method="get" getasbinary="yes" result="result"><cfhttp url="https://image.freepik.com/free-icon/apple-logo_318-40184.jpg" method="get" getasbinary="no" result="result2"><cfdump var="#result.fileContent#"><cfdump var="#toBinary(toBase64(result2.fileContent.toString()))#"><cfabort><cfheader name="Content-Disposition" value="inline; filename=logo.jpg"><cfcontent type="image/jpeg; charset=iso-8859-1" variable="#result.fileContent#">In my real world example, I am actually doing this with FileRead and I use FileRead and not FileReadBinary (but the same problem exists) because I need to crop out a couple of blanks lines in a physical file before converting it to binary, and that file is created by a third party software which I cannot alter.Can anyone help?Thanks in adv

   Solved a problem today that I doubt Adobe will patch in cf10, so here you go.System Specs :Windows Server 2008 R2Coldfusion 10 10,0,23,302580Java 1.8.0_74 Symptom (from the exception.log): java.lang.NoSuchMethodError: org.openxmlformats.schemas.wordprocessingml.x2006.main.CTFFData.getCheckBoxList()Ljava/util/List;at org.apache.poi.xwpf.usermodel.XWPFRun.text(XWPFRun.java:1001)at org.apache.poi.xwpf.usermodel.XWPFRun.toString(XWPFRun.java:971)at org.apache.poi.xwpf.usermodel.XWPFParagraph.getText(XWPFParagraph.java:215)at org.apache.poi.xwpf.usermodel.XWPFTable.<init>(XWPFTable.java:117)at org.apache.poi.xwpf.usermodel.XWPFDocument.onDocumentRead(XWPFDocument.java:152)at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:166)at org.apache.poi.xwpf.usermodel.XWPFDocument.<init>(XWPFDocument.java:118)at org.apache.poi.xwpf.extractor.XWPFWordExtractor.<init>(XWPFWordExtractor.java:59)at coldfusion.tagext.search.MSDocument.readDocx(MSDocument.java:164)at c

We applied the APSB14-23_FIX, which contains the hf902-00007.jar, and appears to be the latest CF9.0.2 update from Adobe.The CF server runs with that update under Java 1.7.0_55, but when we try to repoint to using Java 1.7.0_151, we get the Client Storage error, and even though the server does start, any request fails due to lack of availability of client scope variables.Our Version: 9,0,2,282541 Server.log:"Information","main","08/28/17","08:41:52",,"Starting client..." "Error","main","08/28/17","08:41:53",,"Unable to initialize Client Storage service:java.lang.ExceptionInInitializerError"My suspicion is that CF9 is not compatible with the java 155 release, but since it is in the '1.7. series, that ought not to be the case.Has anyone else seen this error, and were they able to resolve it?Thanks,Ian[Moved from the non-technical Lounge Forum to the specific Program forum... Mod][Here is the list of all Adobe forums... https://forums.adobe.com/welcome]

I have a cfselect and when a user selects Vendor from the list, a div displays showing a company field to enter the company name. I am trying to get to the logic that checks if Vendor is selected, make the company field required`. Here is what i got so far. When I fill out the form and choose vendor the div with the company field displays but I cannot make it requiredThank you!<cfif form1.county EQ 'Vendor'>                                                          <cfinput type="text" name="company" id="company" width="190" message="Please enter your company name." required="yes" >                    

Hi, I have a simple function that searches for a user (see below). using cfscript. cf2016 QryGetUser = Queryexecute("SELECT tblUsers.ID,tblUsers.OrganisaztionID,tblUsers.Username,tblUsers.Password,tblUsers.AccessLevelFROM tblUserswhere tblUsers.Username=?", [username],{datasource="myds"});I want to have the “username” parameter in the WHERE optional.So traditionally I have:Wrapped the where clause in IF statements to check if a Parameter isdefined.e.g.Where 1=1ANDIf(isdefined(“parameter2”){AND field2=parameter2}So this works just fine but gets a little cumbersome and hard to read,however with optional parameters I figure I am going to have to build my SQLstatement dynamically in any case. I have several parts to this question:1 – Is there a cleaner solution apart from building the SQL string2 – Would it be bad practice to pass the whole built SQL string as aparameter to this function, the entire select statement being built outside ofthe function3- Depending on the above answers would

I'm trying to test the first sample from here ColdFusion Help | Using the cfprogressbar tagwhere cfprogressbar ... bind="cfc:pbar.getProgessData()" and the backyard code in pb.cfcThere are plenty more similar samples out there to run cfprogressbar with cfc callback bind since CF9 or so but I get all the same results.I'm running it on ColdFusion 2016 Update 4 and it only runs once from 0% to 10%. Only one step. Tested with both IE and Chrome with F12 debugger.In the browser debugger I see pbar.cfc?method=getProgessData& ... calls every one second as it should but the response is always the same like {"MESSAGE":"10%","STATUS":0.1}How can fix it, any ideas, please?UPDATE: It works only via http://localhost or https://localhostStuck via http://127.0.0.1 or https://127.0.0.1 or direct public available IP address or any domain name to that computer

Hello, all,I've got a query that is giving me fits.I'm trying to bring some code that my boss recently wrote into the 21st century.  One section that he wrote, he is using three queries to get base information, looping through one of the queries and running a query within that loop.  I hate this.  Every time I see code that runs a query within a loop, it makes my teeth itch.  So, I'm trying to run a single query using LEFT OUTER JOIN.I've got it working, but for one thing.  I am trying to get our Oracle db to aggregate some data into a string using LISTAGG(), and that is causing this query to take 14 seconds to get the data (the way my boss wrote the code, it's almost instant.)  Of the two tables involved, one has ~2000 records, the other ~4000, and the query is retrieving 23.  If I take out the LISTAGG() portion, the query is almost instant.I was hoping to get the db to do more of the heavy lifting.  Is there anything faster than LISTAGG() for a

Hello, all,I recently ran across CFOBJECTCACHE, which has a single attribute with a single option, action="clear".  This was introduced in CF5.I haven't used it, yet, but it looks like I might have a reason to, soon.  But I am wondering if Adobe (or even Lucee) is planning on modifying it so that one can clear a specific query (as opposed to all cached queries within an application)?  Seems to me that if one has a site/app that has many (say, 30 or more) cached queries that this could put a huge strain on the CF Server due to all queries being re-run after this tag is used.I know that this isn't a forum that is staffed by Adobe employees, but occasionally an Adobe employee does peruse, here.  What say you, Adobe?V/r,^ _ ^