ColdFusion

Anyone know how I would resolve this error?

Hi There Have loaded CF 2016 server on a test PC to test the impactof upgrading of our website from CF10, however when defining an ORACLE 11.gdata source am getting this error. Works fine with CF10. Connection verification failed for data source: cls4java.sql.SQLException: [Oracle JDBCDriver][Oracle]ORA-01882: timezone region not found The root cause was that: java.sql.SQLException:[Macromedia][Oracle JDBC Driver][Oracle]ORA-01882: timezone region not found  Any advice on fixing it?

When is the CF2016 Hotfix 1 being released?  I'm blocked on my upgrade project due to this bug: Bug#4126398 - SQL comments inside CFQuery are not ignored

When I select new launch configuration, I get the following error.An error has occurred. See error log for more details.Path for project must have only one segment.!ENTRY org.eclipse.jface 4 2 2016-05-10 11:24:33.317!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.jface".!STACK 0java.lang.IllegalArgumentException: Path for project must have only one segment.  at org.eclipse.core.runtime.Assert.isLegal(Assert.java:63)  at org.eclipse.core.internal.resources.WorkspaceRoot.getProject(WorkspaceRoot.java:184)  at com.adobe.ide.coldfusion.common.projectResources.CFProjectResourceProvider.getProject(CFProjectResourceProvider.java:136)  at com.adobe.ide.coldfusion.debug.ui.CFLauncherMainTab.performApply(CFLauncherMainTab.java:239)  at org.eclipse.debug.internal.ui.launchConfigurations.LaunchConfigurationTabGroupViewer.refresh(LaunchConfigurationTabGroupViewer.java:446)  at org.eclipse.debug.internal.ui.launchConfigurations.LaunchConfigurati

Hi All,I want installer for ColdFusion 11 developer edition 64 bit. As usual I went to Adobe - ColdFusion Support Center : More Downloads , but it seems only ColdFusion (2016 release) - Developer Edition (Free) installer is there and for other version the add-on instillers are there.So, where I can get it?Thanks in advance.

I have been tasked with upgrading our web servers from Windows Server 2008 to 2012. As we are not upgrading our ColdFusion version, is it possible to use the same licenses on the new servers? If so, would we be able to have 2 instances of the license operating for a month long period in order to migrate? We have 4 servers in total, 2 running CF11 Enterprise (production), and 2 running CF11 standard (test).

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