Questions

Hi,I am trying to obtain information inside the XML file Testff.xml.Below is the contents of the XML file:<?xml version="1.0" encoding="UTF-8"?><NotesImport xsi:noNamespaceSchemaLocation="G:/USERS/user uploading id/BUSFIL~1/logNotesImportv2.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Facility><FacilityID>8</FacilityID><FacilityName>THE x</FacilityName><DateDataExtracted>2015-05-05</DateDataExtracted><TimeDataExtracted>23:55:00</TimeDataExtracted><LogNote><SSN>000-00-0000</SSN><LogNoteID>20150505065022</LogNoteID><DateContacted>2015-05-05</DateContacted><DateEntered>2015-05-05</DateEntered><WhoContacted>21</WhoContacted><ContactType>114</ContactType><Confidential>F</Confidential><InputWorker>jhjh67</InputWorker><Description>The Service Plan was revised</Description><LogNoteUnit>2</LogN

Hello,I have a template containing some static pages saved on the server and I would like to add the dynamic pages to create another Excel file.My problem is to open the template.I Receive the following error: "The workbook already contains a sheet of this name"How to do that?The template name : "Template.xlsm"My current code:<cfset srcUploadedFile = application.settings.loadExcelDirectory & sepa & "Template.xlsm"><!--- I would like to create an object "s" which is my Excel document ---><cfspreadsheet action="read" src="#srcUploadedFile#" sheetname="History-version" name="s"><!--- Create a new sheet and fill the new dynamic page ---><cfset SpreadsheetCreateSheet (s, "Dynamic 1")><cfset SpreadsheetSetActiveSheet(s, "Dynamic 1")><cfset headerText = "" ><cfset headerText = ListAppend(headerText, "Title 1") ><cfset headerText = ListAppend(headerText, "Title 2") ><cfset SpreadsheetAddRow(s, headerText)><!--- Create the n

The security team here at the University seems to think ColdFusion is dead. Is it? I'm getting tired of trying to defend it. Do you have any resources to help? List of Companies perhaps?Just so we're all on the same page, Adobe chat support's official response to this question was;"... we don't have option for that, however if you are facing any technical issue you can contact our expert in technical team."And calling tech support I was presented with the response;"We can't help you. Go to the forums."When I asked tech support to route me to a supervisor he said, "Adobe doesn't care if you discontinue use of their product" Yep. He actually said that to me

I have configured a dedicated site, separate from my website, for my ColdFusion administrator (CFIDE).  So I have my website here: http://www.public-site.com/ and my ColdFusion admin here: http://www.cfadmin-site.com/ .  They both live on the same server but under different directories.  So now I am configuring my ColdFusion settings and wondering if there is some way to configure the missing template handler and site-wide error handler to use files that live under the public site directory so that I can give my users a consistent look?I am guessing that this is not possible but thought I would ask.  I may be left with creating the modules under my ColdFusion admin directory and then using <cflocation> to redirect the user back to the public website environment.  Or embedding some javascript to redirect them.  Any other thoughts?

Hello, all,I've got a table in an Oracle 12g db that is BLOB for storing files.  I'm trying to find a way to get the size of a single file contained within the BLOB column.I am not saving the file to the server before inserting it into the db; it is going straight to the db to cut down on disk i/o, so I can't get the file size before inserting.Any thoughts?V/r,^ _ ^

The following code to generate a spreadsheet and then download to the client will not free up memory at completion.Running multiple times will (depending on the size of the heap and the number of rows in the database) exhaust the heap.With 100,000 rows and a 2GB heap Java will hang on the 4th attempt to run the code.<cfset spreadsheet = spreadSheetNew("Report",True)><cfset spreadsheetAddRow(spreadsheet,"Id,Name,Date,State,Zip")><cfquery name="MyQuery" datasource="test1">SELECT    id, Name, Date, State, Zip      FROM      myTable</cfquery><cfset spreadSheetAddrows(spreadsheet,myQuery)><cfset spreadsheetFormatRow(spreadsheet,{            bold=true,             fontsize=12     },      1)><cfset filename = "Report.xlsx"><cfh

I see that enterprise edition of CF 11 has the native drivers to connect to informix. I can't find anywhere if standard edition has the native drivers. Anyone know?

Hello,I have a few questions.  First a little about our current setup.Currently we're running CF 10 enterprise on a dedicated server as a production server and a second not quite as powerful server as a test server / fail-over.We are moving to a cloud solution with 2 identical VMs with 4 cores each, 1 will be production and once more the second would be a test / development / fail-over server.  At first we're going to move with CF10 just to get things configured and running again but we'd like to move to the latest version of cf soon after so we can then be on the newest and most up to date software.My questions:1)  If I read things correctly we would need to have either 2 standard licenses or 1 enterprise license to cover our installation as our test / fail-over server is covered in the purchase.2)  I am not entirely sure why we are using Enterprise currently as I do not believe we are even using any of it's features.  What features would be lost / gained if w

When running the installer to generate a .war file there was no option to disable the .NET connector.We need to disable the .NET connector which is automatically enabled. I didn't find a config file to turn this off either.In neo-dotnet.xml there is an option to set the port, but no option to disable completely.

[Moderator moved from The Lounge to ColdFusion.]  Server instances:- bookabach- trips_ha- trips_vrboOn each one multiple sites will be running. I already have bookabach working fine but since the HTTPD config is different related to JRUN I don't know how to do it for CF2016 release version. With read is the config that I don't know how to consider now. And also if I really need to add that section.NOTE. The difference between bookabach and trips_* are that the last one works with Netscaler.Hope that someone can help me /etc/httpd/conf.d/trips-au-test.conftrips-ca-test.conftrips-fd-test.confwww.ustest.bookabach.co.nz.conftrips-au-test.conf - CF9<VirtualHost IP:80>  Include /etc/httpd/conf.d/httpd-modrewrite.confDocumentRoot /usr/local/homeaway/trips/trips_ha/www_versions/-wvr-en-australia-/  <Directory /usr/local/homeaway/trips/trips_ha/www_versions/-wvr-en-australia->   Options Indexes FollowSymLinks  </Directory>  Alias ... 

CFBuilder admin storageApplication.cfmLogin,cfmpart of page when i want to use login including.Hello everyone, please help me understand these sessions' behavior.The whole problem consists in attempting to pass variables from one page to another.So after login i don't see the session.user in session struct.How can i pass this?Have already tried different browsers.

Hello to everybodyI work with ColdFusion 10.I must create a excel document containing some sheets. I use cfspreadsheet instructions and SpreadsheetFormatRows for modifying the style of my page.The current problem that I have, if for the sheet one I use one colour for the background of some cells, the system keep the colour.The next time I fill the cell, the background is equal of previous sheet.I would like to remove it. I would like a transparent background.How to do this?I already search on this forum, on google but ... nothing. May be some one have a solution?Thank you for your helpBest regardsAndre

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