Questions

I am running a Coldfusion application for over 10 years and just upgraded to coldfusion 2016.  Now I am getting strange results.  I have a query that uses values from another query and it says the first query is not defined.  I can get it to work sometimes if I do a cfoutput first but not always.  Also, if I print a value from the first query multilple times, the first time in may be blank and the second time it returns the value.  If I do it 4 times, every other output is correct.  This only starting happening with the latest release.

I'm building a highway noise barrier inventory tool that will allow people to search all the current highway noise barriers in the US by state, type, material, etc (I know, I know, exciting stuff).I'm needing to slice and dice the data many different ways, so I'm using cffunctions and cfcs.  I've found out that it works better to have a function for each thing I want to call, rather than trying to stuff it all into a two or three huge queries.  This has worked well, except for one place, where I have a list of barriers by state and year, and within each record, I have to grab all the materials.  This is sort of a query in a nested loop, and as such, is SLOW.I solved the speed problem on another page by just running one bit cached query at the top of the page, then doing this:<cfset qgetMaterialsbyID = structNew()><cfloop query="qgetallbarriermat">    <cfset qgetMaterialsbyID[qgetallbarriermat.barrierid[qgetallbarriermat.currentRow]] = qgetal

When attempting to send an email to multiple recipients using Cold Fusion, only the first row is receiving the email and it seems to be being hit three times but only sending once. This works but all recipients are visible and the cfoutput is displayed as many times are there are recipients:<cfmail to = "#ValueList(getEmail.Schd_Email)#" from="test@test.edu" subject="This is a Test" type="HTML" query="getEmail" failto="test@test.com"> The location has been moved to <b><cfoutput>#location#</cfoutput></b><br/> </cfmail> This only sends to the first person listed in the query and the cfoutput in the body is still listed as many times as there are recipients.<cfmail to = "#Schd_Email#;" from="test@test.edu" subject="This is a Test" type="HTML" query="getEmail" failto="test@test.com"> The location has been moved to <b><cfoutput>#location#</cfoutput></b><br/> </cfmail> I can output the query to the page and s

HI, I have purchased a licence key for CF Builder 3 but the software will not accept it. In always asks me for a previos key. However this was not an upgrade it was a single purchase.Anyone had this problem?

Having trouble connecting to a remote Solr instance.  Both servers are CF11.  Server A runs Solr locally and has several collections on it.  I want to connect to those collections from Server B. I keep getting the error Cold Fusion Serivce is not running.Is there a guide on how to set this up?

I sure hope there is somebody about who can answer a question.Getting back to ColdFusion after a few years absence.I am trying to connect a ColdFusion 11 installation to an Oracle 11.2 database.  There is no SID associated with this database, rather it apparently uses a Service name: "snet.world".How can I connect to this oracle database with my ColdFusion 11?

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