ColdFusion

We were running CF8 and the following code worked. <cfset attributes.email = "manual2016@2016.com"><cfset attributes.bday = "05-04"><cfset attributes.name = "test"><!--- <cfparam name="attributes.email" default="#form.email#"><cfparam name="attributes.bday" default="#form.month#-#form.year#-1900"><cfparam name="attributes.name" default="#form.name#"> ---><cfset attributes.sdk.addContactStruct = structNew()/><cfset attributes.sdk.addContactStruct["Email"] = JavaCast("string", "#attributes.email#") /><cfset attributes.sdk.addContactStruct["Birthday"] = JavaCast("string", "#attributes.bday#") /><cfset attributes.sdk.addContactStruct["FirstName"] = JavaCast("string", "#attributes.name#") /><cfset variables.optinreason = JavaCast("string", "Store newsletter form") /><cfset contactId = application.sdk.addWithDupCheck(attributes.sdk.addContactStruct, "Email", variables.optinreason) /><cfset TagcontactId = applica

We have a set of Applications in Coldfusion MX7 with Oracle 11g Database.Connected Datasources in Coldfusion using JDBC thin Driver. The coldfusion server has ojdbc14.jar in c:\coldfusionmx7\libThe Oracle version has now been upgrade to 12c. The Application throws "ORA-28040: No matching authentication protocol"We googled and found that the jdbc driver used is not compatible and they suggested 1. change the ojbc14.jar to ojdbc6.jar in c:\coldfusionmx7\lib, restart Coldfusion server and start mapping the Datasources.2. Set SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 in the oracle/network/admin/sqlnet.ora file.Please give us a clear suggestion1. Whether downloading ojdbc6.jar from Oracle website and placing it in c:\coldfusionmx7\lib instead of ojdbc14.jar will work properly- Is it compatible with MX7?2. Adding the server version "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" in sqlnet.ora file will do or do we have to specify SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 also. If so, do we have to restart t

I've been having a particularly annoying error with ColdFusion 11, and unable to track down the source of this problem.Basically There are a few variables defined in the session scope we check with isdefined a few lines above to make sure they are defined. Subsequent lines may or may not throw a #variablename# is undefined on random lines.What can I do to fix this issue? Is this a known bug?

I have a folder 'realtime' that has about 15 txt files(test1.txt,other.txt etc), theres is other jobs nothing related to coldfusion that if something goes down then the file wont exist anymore.So I want to create a job that if a txt file doesnt exist then it will sent me a email.what would be the best way to do something like this?would i have to check for each individual txt file , something like ??<cfset Pathtest = "\\folder1\dept\Alerts\other.txt"><cfif !fileExists(Pathtest)>  <cfmail ...>  sent me a email  </cfmail>    </cfif>

I thought CFB 3 was going to be good for me, but the more I use it the more I am finding strange behaviors.  Lately I have one particular file that is quite large that keeps crashing whenever I try to edit it.  I have to open that particular file in another program and make my changes.  The rest of my site is working well so far, but that page (Coldfusion Component page) makes CFB 3 hang forever.  I have to force a shutdown.If anyone knows, where can I pull up any log files that will help me know what might be the cause to help submit a bug?  I would love to get this fixed, but not sure how to reproduce or find what caused it.

Hi,Some users of the application are using IE 10 or IE 11 and is working file.Some users of the application using IE 10 or IE 11 the application is not working.Running Cold Fusion 11 with Update 3 and IIS 7. The servers are Windows 2008, 32 bit.Does anyone have any ideas?Thanks,Mike

Hello, all,I'm working on some legacy code that I inherited from a long-gone developer (he left about two years ago.)For some reason, the developer is setting application variables in the onRequestStart() section of application.cfc.I was under the impression that application variables were set when the server is first started, or comes back from a reboot, or similar situation.  Yet until recently, this application was running without a hitch.Am I crazy?  Obviously the variables are working, but I didn't think it would.V/r,^_^

Hi All,For the past few weeks, the ColdFusion Server will randomly just hang... where a page request will just keep spinning... restarting the server has cleared it up... but we're having to do that more frequently.Can you give me some insights into this problem or how to debug it on CF11 Server?Version: ColdFusion 11 Update 7IIS: Windows Server 2012R2 8.5.9600.16384Database: SQL SERVER 2008 R2I suspect the problem may be related to the number of workers/processes running at a given time? How do I increase this from the default installation?Thanks,John

Hello, all,My boss is trying to get some debugging information on a project that he's working on.  Our SA says that the option to display debugging information is no longer present in CFAdmin.  We are running CF10 hotfix 18.  Has anyone else had this option disappear on them?V/r,^_^

I have a query that needs to sort a column in a specific order. Currently for the act_code Charges have a '+' value, Payments have a '-' value and Awards have a '=' value. I need the order to be Charges, Payments, Awards but I get Payments, Charges, Awards. I get "Invalid Column Name act_code" when I run my query. Here is my query:SELECT tmptract.soc_sec, name.last_name, name.first_name, name.mi, address.st_addr, address.add_addr, address.add_add2, address.city, address.state, address.zip, tcodes.act_code,  '' as employee_soc_sec, 2 as bill_typeFROM tmptract, name, address,  tcodesWHERE tmptract.soc_sec = name.soc_sec    AND address.soc_sec = name.soc_sec    AND tcodes.tcodes = transact.tcodes    AND tmptract.token = '#session.token#' ORDER BY name.last_name, name.first_name, name.mi, tmptract.soc_sec, bill_type, (CASE WHEN act_code = '+' THEN '1'      WHEN act_code = '-' THEN '2'      WHEN a

I am looking for a tool that will go through my coldfusion code and add cfqueryparam's where needed. I found many that will scan and show me where I need to make changes but I found one at http://www.webapper.com/blog/index.php/2008/7/22/ColdFusion-SQL-Injection which is pretty close to what I was looking for. But it doesn't add the cfsqltype (or maxlength) and I was wondering if this still prevents sql injection without cfsqltype? And if it is required (I know it is technically optional) do you know of another tool that will do this? I also read that it is also important to make sure that any variables in the order by clause are parameterized also, which this tool doesn't check for.I am thinking of buckling down and changing the code from http://www.webapper.com/blog/index.php/2008/7/22/ColdFusion-SQL-Injection to do all this, but I thought it would be wise to ask first.

Hello, all,I'm trying to find a way to keep something persistent across different application names without using the server scope (which could be lost upon reboot.)Here's the situation.  I've got a very large site.  Many sections utilize the root application.cfc, but others have their own application.cfc with a unique name./dtr/application.cfc   <!--- app name = "dtr" --->/dtr/index.cfm/erc/index.cfm   <!--- uses root app.cfc --->/mov/application.cfc   <!--- app name = "mov" --->/mov/index.cfm/suv/index.cfm   <!--- uses root app.cfc --->/zyx/application.cfc   <!--- app name = "zyx" --->/zyx/index.cfm/root/application.cfc   <!--- app name = "ust" --->/root/index.cfmNo matter which page is loaded, first, (could be bookmarked, or link sent in a message) I need to check to see if the user has seen a banner alert.  If not, display the alert and set a value for all future reference

If I use a chart like this:<cfchart tipStyle="none">     <cfchartseries type="line">         <cfchartdata item="1" value="1">         <cfchartdata item="2" value="2">         <cfchartdata item="3" value="3">         <cfchartdata item="4" value="4">     </cfchartseries>     <cfchartseries type="bar">         <cfchartdata item="1" value="10">         <cfchartdata item="2" value="11">         <cfchartdata item="3" value="12">         <cfchartdata item="4" value="13">         <cfchartdata item="5" value="14">         <cfch

Need to set up data source in CF11 to a SQL server not using  mixed authentication so I need to use a domain account.  When I try to connect SQL see's it as an sql account not and AD.

Sorry for the slightly facetious title.I've been using CFEclipse for years and never had the inclination to move away from it. However, 2 days ago I had a software crash and needed to re-install. Installing Eclipse was no bother but it seems that CFEclipse is down entirely and I really need all my tag-completion and code-colouring nonsense, so I decided to install the latest version of CFB instead.However, even though the installation was fine and it linked to my old workspace no problem, the editor seems just like notepad(!) It's just a grey text editor; no code completion, no colours, no CF toolbar, nada. See attached screenshot.Can anybody advise?

Hi, i need some help.First the environment:OS: Centos 6.7 latestACF: 2016 64bit Linux war deployment Tomcat : 8.0.32 Java Version :openjdk version "1.8.0_71"OpenJDK Runtime Environment (build 1.8.0_71-b15)OpenJDK 64-Bit Server VM (build 25.71-b15, mixed mode)After i deploy the war file the server did not start. Here are some more information (catalinalog):23-Mar-2016 18:32:20.035 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:    Apache Tomcat/8.0.3223-Mar-2016 18:32:20.036 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:      Feb 2 2016 19:34:53 UTC23-Mar-2016 18:32:20.036 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:     8.0.32.023-Mar-2016 18:32:20.036 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:           Linux23-Mar-2016 18:32:20.036 INFO [main]

I can upgrade Tomcat myself, but that approach isn't documented and isn't likely to be supported by Adobe.Tomcat is bundled as part of ColdFusion 11, previously Adobe has provided a hotfix to upgrade Tomcat.  Is this something on your roadmap?Tomcat 7.0.68 fixes the following issues:    Moderate: CSRF token leak CVE-2015-5351    Moderate: Security Manager bypass CVE-2016-0714    Moderate: Security Manager bypass CVE-2016-0763

I have 2 servers in stage setup. Installed Coldfusion in both. My question is1) I would like to manage both servers using a single admin page URL installed in first server only2)  If I create a cluster by adding the second server as remote instance, then do I need CFIDE folder in second server?I am new to coldfusion setup and your suggestions will help me a lot.Thanks,Sarath M

When trying to use the includecolumnnames parameter CF throw and error saying the  spreadsheetaddrows function only supports 2 to 6 parameters, but documentation shows 7. Even the example in the spreadsheetaddrows documentation fails:<cfscript>    out_fl = "#expandpath("./")#header.xlsx";        xlobj = SpreadsheetNew("2d_arr_data", true);        qry_data = queryNew("product, customer, qtr");        queryAddRow(qry_data, {product:"aniseed syrup", customer="annie", qtr="1"});        queryAddRow(qry_data, {product:"camembert pierrot", customer="pierre", qtr="2"});        queryAddRow(qry_data, {product:"scones", customer="connie", qtr="4"});    datatype = [""];        spreadsheetAddRows(xlobj, qry_data,1,1,"true",datatype,true);  &n

I have a cfgrid bound to another cfgrid that always returns null for the value.Worked in CF8Binding to a cfinput displays proper valueCFC is no problem hard coded value in place of bind workswriting to log from cfc verifies null value returned<!--- select office --->  <input type="checkbox" id="pckOffice1" onclick="setOffice();" checked>Bangor  <input type="checkbox" id="pckOffice3" onclick="setOffice();" checked>Lamoine  <input type="checkbox" id="pckOffice5" onclick="setOffice();" checked>Lincoln  <input type="checkbox" id="pckOffice7" onclick="setOffice();" checked>Machias  <br/>  <input type="hidden" id="OfficeFilter" name="OfficeFilter" value="'1','3','5','7','2','9'"><!--- cycle grid --->  <cfgrid name="gdCycle" format="html" colheaderbold="true" striperows="no"         striperowcolor="##ccffcc" selectcolor="#selectcolor#" selectmode="row" selectonload="fa

I am using ColdFusion 11 and have just started using the EncodeForHTML function instead of HTMLEditFormat whenever I need to display text that the user has entered, usually via a textarea.  We need to save the formatting so that information the user has entered remains understandable.  Users have a choice of whether to display the info to the screen or export to a pdf.  We are using EncodeForHTML to make the displayed info safer and we are using <pre> to retain the required formatting.My problem is that when I need to export the data to a pdf, then EncodeForHTML acts differently than HTMLEditFormat does.  For some reason, I get extra lines inserted.Here's some sample code.  Just save to a cfm and run:-------------------------------------------------------<cfsavecontent variable="f">This is my sample data.Value 1  20%Value 2  30%Value 3  50%Here's my summary of this data.</cfsavecontent><cfhtmltopdf saveasname="MyTest.pdf">

Hi everyone. I am testing some simple code on this page: Untitled Document  to do an online order with Stripe.com, but I keep getting this error message when I click Submit:405 - HTTP verb used to access this page is not allowed.The page you are looking for cannot be displayed because an invalid method (HTTP verb) was used to attempt access.Does anyone know what to do to get this to work? Do I need to update something in the CF11 administrator pages or do I need to update something in our IIS server?Andy

Here's my code:<cfif StructKeyExists(cfData.data, "inherited_roles") || IsArray(cfData.data.reader_roles)>  <cfset arrayRoles = "reader_roles" >  <cfif ArrayIsEmpty(cfData.data.inherited_roles)>  <cfset arrayRoles = "inherited_roles" >  </cfif>  <cfloop index="p" from="1" to="#arrayLen(cfData.data.arrayRoles)#">     <!---some code here--->  </cfloop></cfif>And here's the error I kept getting.Element ARRAYROLES is undefined in a CFML structure referenced as part of an expression.The error occurred on line 07 when I have the #arrayLen(cfData.data.arrayRoles)#.Any suggestion is much appreciated

Hi All,For the past few weeks, the ColdFusion Server will randomly just hang... where a page request will just keep spinning... restarting the server has cleared it up... but we're having to do that more frequently.Can you give me some insights into this problem or how to debug it on CF11 Server?Version: ColdFusion 11 Update 7IIS: Windows Server 2012R2 8.5.9600.16384Database: SQL SERVER 2008 R2I suspect the problem may be related to the number of workers/processes running at a given time? How do I increase this from the default installation?Thanks,John

We can't seem to get this running right, and need someone with experience.We have 100 IIS websites, 65 of them are coldfusion. So we "tuned" AJP for that number of connection pools. Under the "ALL" configuration, we have an allotment of 9000 and a reuse size of 138. The server.xml matches thread count and timeout.Originally this was at the default of 250, and sites began to hang and never load. Took us forever to figure out this was the reason...So now we have the sites running, but they use extreme amounts of memory. The worker processes (w3wp.exe) appear to allocate large amounts of ram as soon as they start, and having jakarta in the ISAPI FIlters list reliably causes this. Remove jakarta, and site returns to normal fair memory usage. So naturally we removed jakarta from all PHP sites, and only have it on the CF11 sites. We also began grouping coldfusion sites based on priority into application pools, to try and reduce ram usage.Do we need to tune jakarta for every single site? Is t