ColdFusion

Hello , after applied update 17 to CF 2016 all cfsqltype variables dodn't work anymore . I should change cfsqltype="cf_sql_varchar2" with cfsqltype="varchar" and cfsqltype="cf_sql_number" with cfsqltype="integer" to eliminate this error of "invalid type variable" .My Question is what kind of update is it if I should retype all CF scripts or is it some kind of update bug ?   

Greetings, We are still using the CF11. Our production servers crashed and I need to download and install it.Can someone help? I need the link. We have already purchased this edition back in 2014. Thanks, Theo

I have a simple chart based off a simple query. I am trying to display the various value labels in the legend. If I set the chart type to bar, the legend just shows "Series 1" as the label. If I change the chart type to pie, then everything displays fine. Is this a known bug or am I doing something wrong?  The query gives me output like  COUNTDAMAGE1757Complete2248Landscape31060N/A4938Partial5318Smoke61464Unknown My chart definition is: <cfchart format="html" xaxistitle="Damage" yaxistitle="Calamities" style="blue" showlegend="true" chartheight="400" chartwidth="500" title="Damage Distribution" labelformat="number" > <cfchartseries type="bar" query="damage" itemcolumn="damage" valuecolumn="count" colorlist="##b7e1f3,##189aa8,##aad356,##f9c908,##f35844" > </cfchartseries> </cfchart> The result is:I would have expected each color to be in the legend with the label for that data (Complete, landscape, partial, etc). If all I change

Hello CF Community, Not sure if this is a bug, undocumented feature, or edge case, but let's start with the resolution (or workaround) that allowed our servers to come back online: Replace <struct type="coldfusion.server.ConfigMap"> with <struct> under the <var name='CONNECTIONPROPS'> node within each datasource in neo-datasource.xml Now for the problem we faced: After installing Update 17 for ColdFusion 2016 we could no longer reach the ColdFusion Administrator. The 500 Internal Server Error on screen read "The DataSource service is not available." Our database driven websites were also down, but static sites were up and running. On server startup, the server.log file in the ColdFusion logs had the following error: "Error","localhost-startStop-1","03/23/21","10:41:42","","Unable to initialise SQL service: coldfusion.server.ServiceException: coldfusion.server.ConfigMap cannot be cast to coldfusion.runtime.Struct" Comparing the <cf

Hi I am applying Update 11 to our CF Server 2018 Installations on Windows Server as a result of the critical security update from https://us-cert.cisa.gov/ncas/current-activity/2021/03/23/adobe-releases-security-updates-coldfusionDo I just need to apply Update 11 to our servers and that's it as the Java updated info doesn't specifically mention a Windows Server and IIS install regarding modifying the Java Instance Appreciate to know if we need to do or check anything else or just apply update 11?ThanksSimon

Hello, The link to PDF of CF2021 support matrix is not working. Where can I find what CF2021 is supported on? Details: https://helpx.adobe.com/pdf/coldfusion2021-support-matrix.pdf Thanks in advance, Carl.

After CF2018 Upgrade from CF11, I get an intermittent ORA-01012:Not logged on error. Anyone know what's causing this? Note: The obvious question, am I logged in? Yes, via the Oracle Datasource in CFAdmin.

Can someone explain how to set up a core in SOLR in coldfusion? I delted the core that was there (don't ask...) and now no cores are available. I can get to the screen that says Add Core but I don't know what to put for the various fields. In particular, the instanceDir and dataDir. Thanks for any help you can provide.

Weird behavior of cfc defined using shorthand:component {remote function get() {return "helllooooo";}} compared to normal behavior defined this way:<cfcomponent><cffunction name="get" access="remote" returntype="String" httpmethod="GET"><cfreturn "hello world"></cffunction></cfcomponent> The 2nd example called as a REST service correctly returns hello worldThe 1st example however returns helllooooo but ALSO appends the entire component's .cfc code as follows: helllooooocomponent { remote string function get() { return "helllooooo"; } } Any ideas anybody what could be causing this? I'm stumped. Thks

Hi, Just wondering if anyone has any experience of decrypting an EncryptedAssertion from an IDP. My current workflow is:- 1. Decrypt the symetric key from EncryptedKey element using RSA and my private key. This is giving me a string like �4Q��2�r���h` (doesn't look right, or is it?)2. Use the key extracted above to decrypt the contents of the EncryptedData/CipherData/CipherValue element. This decryption is being done using AES. This is giving me "Invalid AES key length: 28 bytes" error. The decoded xml looks like below:-<saml2:EncryptedAssertion xmlns:saml2="urn:oasis:names:tc:SAML:2.0:assertion"> <xenc:EncryptedData xmlns:xenc="http://www.w3.org/2001/04/xmlenc#" Id="_1244b2f8ed8a27e5454455b4" Type="http://www.w3.org/2001/04/xmlenc#Element"> <xenc:EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#aes128-cbc" xmlns:xenc="http://www.w3.org/2001/04/xmlenc#"/> <ds:KeyInfo xmlns:ds="http://www.w3.org/2000/09/x

Hii Im a beginner in this adobe cold fusion .im come acros with an old project developed in adobe cold fusion.i have confugured the product in my windows system but im not able to add the existing project .can anyone help me with this ?thanks in advance .

I have a query where I am trying to get all records from a data table (TIMELOG) that have happened (EVENTTIME) in the past 7 days or less. The table name is TIMELOG and the field name is EVENTTIME.I want all records where EVENTTIME is in the past 7 days or less.SELECT * FROM TIMELOGWHERE #DateDiff("d",EVENTTIME,now())# < 7I don't know why this doesn't work.I get this error messageVariable EVENTTIME is undefined. 

I am attempting to do an offline activation on a ColdFusion 2021 installation on a server that is behind a protected network and does not have internet access.  I attempted to follow the instructions listed on the https://helpx.adobe.com/ca/coldfusion/using/coldfusion-licensing-activation.html#Offlineactivation help page but the option to generate a Activation Request is missing. Is there an alternative command line option or different method to generate the activation request?

Hello All, I have been working with the API manager trying to set it up so that we can use custom endpoints and not have to use the port 8500 rest calls setup in the ColdFusion administrator. I have had things working great until I needed to "secure" the ColdFusion administrator and REST APIs on port 8500 with an SSL certificate.  As soon as I setup the certificate the API manager could no longer "test" the API calls and if I remove the API set and attempt to reimport I get the following error.[ERROR] 2021-03-16 14:42:10.173 [XNIO-2 task-1] CFDiscoveryPortalServiceImpl - Error retrieving available REST servicesI suspect that it likely has something to do with adding the certificate to the keystore/truststore for the API Manager but so far I have not had luck with that. I have used keytool and added the cert to the [APIManagerHome]/jre/Contents/Home/jre/lib/security/cacerts and have also made sure it was added to the ColdFusion installs trust store as well. Coul

I am installing ColdFusion 2018 on Windows 10 forothe first time usingColdFusion (2018 release) .NET Integration Service Installerfrom https://www.adobe.com/support/coldfusion/downloads.html The listed MD5 Checksum is 2541d06f9a0e99350f498276ec44adeaBut when I runCertUtil -hashfile C:\ColdFusion2018\ColdFusion_2018_DotNetIntegration_WWEJ_win64.exe MD5It returns MD5 checksum 0ea51b7119566cde2b2bab586ecacc95 Is there a problem with the listed checksum or what I have done? 

The ColdFusion Scheduler works for scheduled jobs, but when manually triggering a job for the first time each day from the ColdFusion Scheduler screen in ColdFusion administrator, the job appears to run successfully.  There are no application log entries with errors and the scheduler log indicates the job was manually triggered. The problem is... the job doesn't really run until I manually trigger it a second time.  Subsequent jobs run when manually triggered from the same screen until the next day by which

The documentation does not list fieldBoost in the list of valid attributes to cfindex, yet further down the page its function is described (see https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-i/cfindex.html ). It does not seem to have any effect on the cfindex tag. Has fieldBoost been removed (and how can we then boost a particular field) or has the syntax changed (and to what)? This is a ColdFusion 2018 Standard Edition running on Win Server 2016. Best, Robert

We are running ColdFusion 2021 Enterprise on a virutal Windows 2016 platform in Azure, and our code uses the DateFormat function with the uppercase D, or DD to signify the day of the month.   I injected the "-Dcoldfusion.datemask.useDasdayofmonth" parameter into the jvm.config file however it appears that it is still interpresting "DD" as day of year.  Has anyone else been able get this to work correctly, and if so how did you do it? My CFSETUP command to inject the arguments: cfsetup.bat set jvm jvmArgs="-server --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/sun.util.cldr=ALL-UNNAMED --add-opens=java.base/sun.util.locale.provider=ALL-UNNAMED --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED -XX:+UseParallelGC -Djdk.attach.allowAttachSelf=true -Dcoldfusion.home={application.home} -Dcoldfusion.rootDir={application.ho

Hi alli dont understand what the Adobe help mean  where i get the secret für the connector...Server.XML and Properties? In i Start the Shell update connector Script in coldfusion ... error  the Problem is i Need the Update because i Need the "Samesite Attribut  i have ubuntu and apache2 and coldfusion 2016 

Multimple issues here.  Env is Windows 2016 (VM) with CF 2016 Issue #1 wsconfig reporting "all the iis sites are already configured by some other version of coldfusion"Details:There has never been another version of CF on this specific server.  Was Built with CF 2016.Restored server back to patch 8 once (Via full Comvaut harddrive  restore) and issue was present with patch 8.Followed manul config guide to remove all configs from IIS at patch level 8.  Also used notepad++ to search .config files, found a few hidden ones which the IIS UI did not pull out.Renamed the wsconfig folder to a copy.Patched back to update 16 from 8.Wsconfig would still not see the websites.Added a new temp website, wsconfig would not see that one either.Followed the manual config guide, building a new wsconfig folder.After, CFIDE from IIS showed 403 errors from IIS, but worked on port 8500 directly.Followed some guide on this, turned out it was the connector needing password, is not

trying to get query of queries to work in script. It wil not work when where clause is added.I have a function and i pass in a query and trying to query that passed in query.it works when i take out the where clause: cannot find any docs that specify the where clause being written differently.  thanks.function(query orgData){adminUsersQuery = new Query();adminUsersQuery.setDBType('query');adminUsersQuery.setAttributes(sourceQuery=orgData);adminUsersQuery.addParam(name='region', value='midwest', cfsqltype='cf_sql_varchar');adminUsersQuery.setSQL("SELECT distinct aoi FROM sourceQuery where region = :region"); newOrgData = adminUsersQuery.execute().getResult();}

Hi, Team:Good day!We have ColdFunstion of 2016 version(ColdFusion_2016_WWEJ_win64) in one server before, now need to update to 2021 version, then I uninstalled the 2016 with its uninstall tool, then reinstalled the 2021 ColdFustion version(ColdFusion_2021_GUI_WWEJ_win64), but after installed success,our current application system which developed with coldfusion cannot access, it prompt error, II try to install the web server with wsconfig tool for all IIS, but seems as error as below. Do you have some advice why install the latest version, current coldfusion system cannot work well? Is there anything other configuration?By the way, do I need to 2021 API manager to replace the 2016 version API manager? Appreciate to you if you have one member to help to resolve this issue, it is urgent. Thanks. 

Hi All, Currently i am using Cold fusion 2016 update 16 version. The ISAPI_redirect.dll of this version is 1.2.46 which has a known vulnerability CVE-2020-1938. we tired to update the latest dll but the application does not work.  Can you please let me know if there is any way in which the update can be done.

I had CFB installed about 2 days ago. I uninstalled reinstalled it becauseof some issues. When I reinstalled CFB it would not launch. My issue is very similar to this user's I have a mac so I could not use the uninstaller program the user recommends. Does anyone have any solutions for this?

Has anybody gone beyond Java 8?I currently have JDK 1.8.0.162, I see build 202 is currently available which I presume will be ok with it being version 8 still however I'm wondering if I can move to a higher version?