ColdFusion

Hi,I need to insert an xml file data into a SQL Server database table using Cold Fusion 11.I have an SSIS package on the SQL Server that inserts the data.Is there a way to execute the SSIS package in Cold Fusion?Is there a SQL statement to insert the data with out using the SSIS package in Cold Fusion?Thanks in advance,Mike

Hello!We have a system running on Cold Fusion. The server was running on CF7 and we upgraded it to CF11 and now the isDefined are not working anymore.To be honest I do very few Cold Fusion coding, it's an old system that was not maintained that I just got and I have to manage. I am learning everything.I've read that isDefined is not the best and would be better to use structKeyExists instead. The problem is there is more than 1900 files and 3000 isDefined to change.Example :This line marks an error :<cfif not isdefined("caller.#attributes.prefix_mandatory##fldname#") or  (isdefined("caller.#attributes.prefix_mandatory##fldname#") and trim(evaluate("caller.#attributes.prefix_mandatory##fldname#")) is "")>Which I corrected and works fine :<cfif not structKeyExists(caller, '#attributes.prefix_mandatory##fldname#') or (structKeyExists(caller,'#attributes.prefix_mandatory##fldname#"') and trim(evaluate("caller.#attributes.prefix_mandatory##fldname#")) is "")>Error message :

Hi thereI have a accdb designed with Access 2010 64bit.I am running CF9 under Win2008 R2 64bit.I have also installed http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255I have now googled and tried some dozen tricks to get this combination work:until now - no way!Does anybody succeed to to so and is there somewhere a description?Thanx for help - Didi

Hi everyone,I'm moving our coldfusion8 server to a new one.So I'm looking for the installer of coldfusion 8 for unix environment.Is there anyone can help to provide me a link to download it? I have been searching for long days.Thank you very much and best regards,

hello alli might not be the dumbest of system admins here, but i feel utterly left alone on the CF 2016 update 5 page:ColdFusion (2016 release) Update 5 in there, it says JRE needs to be updated.  so far, so ok.  it say 'for 32 bit coldfusion, use 32 bit jre'.  i can also understand that.on this page: How to change/upgrade JDK version of ColdFusion server | Adobe ColdFusion Blog , i found on how to do that.  there is a download page linking there for downloading JRE: Java SE - Downloads | Oracle Technology Network | Oracle .  if i choose SE 8 Server JRE, i get here: Server JRE (Java SE Runtime Environment) 8 Downloads problem: i run coldfusion in 32 bit mode due to some older cfx tags which we still need.  on the page above, there is no 32 bit version of JRE...what am i supposed to do?thanks for any help and insights.lukas

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.