I have write a code in body_supportlog.cfm as below, able to download excel, but it show "The request resource are not available. It suppose link with eclipse's parameter from date and to date. The file path refer to  C:\ColdFusion11\cfusion\runtime\webapps\BIRT\test1.rptdesign<html> <head>  <cfset mid="100000"> <cfset fid="121212121"> <cfinclude template="#rootdir#checkaccess.cfm"> <cfoutput> <TITLE><cfinclude template="#rootdir#pageTitle.cfm"></TITLE> <LINK REL="STYLESHEET" HREF="#css#iesync2.css" TYPE="text/css"> <script language="javascript" src="#jslib#mainframe.js" type=text/javascript></script> <script language="javascript" src="#jslib#iesync2.js" type=text/javascript></script> </cfoutput> <script language="JavaScript"> function urlencode(str) { str = (str+'').toString(); return encodeURIComponent(str).replace(/!/g,

1230

2 years ago

CF10BenFortaParticipant

Questions

CFCOLLECTION CFSEARCH CFINDEX 2023

Hello I am new to Cold Fusion,        Well I am new to Cold Fusion 2023. The last Cold Fusion version I have used is CF 10.We have a web site that I would like to migrate to Cold Fusion 2023 and it is basically a document search web site. I need to know if the 2023 version has the same functionality for collections and search as in the past. I know that Adobe has replaced Verity with SOLR. Any major differences in setuping the collections, indexing and searching them?      Is there is anyway I can move the current web site to testing/development environment to do the testing until we decide on investing in the new Cold Fusion Server? The testing environment should also have SQL server. Thank you so much!

1230

2 years ago

coolidgeKnown Participant

Questions

ColdFusion service will not start

Hello - We're running ColdFusion Standard 2018.  Early yesterday morning the service stopped, and we have not been able to start it.  Is anyone familiar with these errors?  Thank you. Apr 30, 2023 2:02:28 AM org.apache.catalina.core.StandardServer awaitINFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance.Apr 30, 2023 2:02:28 AM org.apache.coyote.AbstractProtocol pauseINFO: Pausing ProtocolHandler ["http-nio-8500"]Apr 30, 2023 2:02:28 AM org.apache.coyote.AbstractProtocol pauseINFO: Pausing ProtocolHandler ["ajp-nio-127.0.0.1-8018"]Apr 30, 2023 2:02:28 AM org.apache.catalina.core.StandardService stopInternalINFO: Stopping service [Catalina]Apr 30, 2023 2:02:34 AM org.apache.catalina.loader.WebappClassLoaderBase checkThreadLocalMapForLeaksSEVERE: The web application [ROOT] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@480d45d0]) and a value of type [org.apache.xerces.parsers.SAXP

9133

2 years ago

ACS LLCInspiring

Questions

Why is cfsqltype="CF_SQL_DECIMAL" rounding values

I am submitting values to MS SQL where I set the value in the CFQUERY usingdatabasefield = <cfqueryparam value="#TheValueHere#" cfsqltype="CF_SQL_DECIMAL"> The database is set to DECIMAL(8,2) If I manually type in a value into the database such as 1.5 it works fineIf I use the cfqueryparam above, and post 1.5, it rounds to 2, so that's not right I removed the cfqueryparam, and again submitted the valkue of 1.5 in the variable, and it worked fine, I end up with 1.5 in the databasedatabasefield = #TheValueHere# Would anybody have any idea why using CFQUERYPARAM DECIMAL is causing it to round? 

10062

2 years ago

gayanbInspiring

Questions

execute oracle stored procedure in CF8

I am executing a stored procedure like this. <cfstoredproc procedure="GetAction" datasource="test_DSN"> <cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="actionId" type="in" value="1"> <cfprocresult name="actions" resultset="1" > </cfstoredproc> and my stored procedure in oracle is, create or replace function GetAction(actionId IN ACTION.ID%TYPE) RETURN ACTION%ROWTYPE IS actions ACTION%ROWTYPE; begin select * INTO actions FROM ACTION WHERE ID = actionId; RETURN actions; end GetAction; then I get the error message like, ORA-01008: not all variables bound Please help me on this. Thanx

9922

2 years ago

Alexis32811824dpclParticipant

Questions

ColdFusion 2016 Download and License Transfer Inquiry

Hello Adobe Support and Community, I am currently in the process of migrating and reconfiguring systems that utilize ColdFusion 2016. For this purpose, I require access to the ColdFusion 2016 installation files. Understanding that Adobe primarily promotes the latest versions of its software, our current infrastructure and applications are specifically tied to ColdFusion 2016, making it essential to obtain this particular version. Details of the ColdFusion 2016 setup:Edition: EnterpriseVersion: 2016.0.0.298074Operating System: Windows Server 2012 R2 I would greatly appreciate it if you could provide a direct download link or guidance on obtaining the installation files for ColdFusion 2016. Furthermore, within the "About" section in the ColdFusion Administrator, I can view the current serial number. I wish to know if it's possible to directly use this serial number on the new server after installing ColdFusion 2016? Are there any specific steps or considerations

3923

2 years ago

sdsinc_pmascariLegend

Questions

Help Converting cURL to CFHTTP

I'm hoping I'm missing something obvious here and this will be a simple fix. I'm working with the LinkedIn API, specifically creating a share. I've got all the authentication working and have successfully created plain text and article shares.  However, in order to include an image with a share I'm hitting a snag. According to the documentation, after making an initial call to obtain the uploadUrl, you then upload the file.  Specifically:  "To upload your image, send a POST request to the uploadUrl with your image included as a binary file." It gives this cURL example: curl -i --upload-file /Users/peter/Desktop/superneatimage.png --header "Authorization: Bearer redacted" 'https://api.linkedin.com/mediaUpload/blahblahblah'  I have tried numerous ways to replicate this call with CFHTTP, but LinkedIn always returns a 400 Bad Request response.  No other info. Here's my latest try: <cfhttp url="#uploadURL#" method="pos

8641

2 years ago

me@AdobeParticipant

Questions

Calling Oracle stored procedure having insert statement into a temporary table does not work

We have a stored procedure in Oracle which has an insert statement into global temporary table. But , calling this stored procedure from ColdFusion application throw error saying "Object no longer exists".  Procedure definition looks like below, INSERT INTO DSB.TT_SP_bill_getBillInfo_Device SELECT DISTINCT 100, 'test', 'test', 'test', 1,'test','test', 10,1,0,1, 0,1,0 from dual; Apprecite your help debug the error.

1960

2 years ago

obxBillParticipant

Questions

CF 2018 Performance Monitor JRE Version

Given the CF2018 PM is updated to HF 5, does anyone know the latest tested Java (JRE) version for the toolkit?  Currently, it is running 11.0.1, though interested if it can/will run 11.0.20, or if not, the latest version currently tested on the CF2018 PM toolkit.

940

2 years ago

michaels14629018Participant

Questions

ORM error when using fieldType="one-to-many" (Migrating from CF11 to CF2023)

Hi, I have a REST-service that is working excellent on CF11. When I copy the files to a new CF2023 server and try to register the service in the administrator I get the following error when the model contains either fieldType="one-to-many" or fieldType="one-to-one" exception.log:Caused by: java.lang.ClassNotFoundException: org.hibernate.engine.spi.SharedSessionContractImplementor not found by orm [155] I tried it with the original build-in Java 17.0.6 and 17.0.8

3861

2 years ago

Parashar5FC0Participant

Questions

ColdFusion 2016 Update 17 Docker - Facing Simlink Issue

We are running CF 2016 update 17 docker image. CF Admin trying to use Simlink feature in Tomcat using file /opt/coldfusion/cfusion/runtime/conf/server.xml   CF Admin added <Resources allowLinking="true" to get simlink working, When we are restarting the container, the file is getting replaced by the default file.  If i'm trying to mount this file using file-mapping, then CF container isn't strating successfully. showing this:   [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status...   Can someone advise how to get arounf with this issue?

11421

2 years ago

joeyg60012433Inspiring

Questions

CF2023 updates clearing out YUI cf_scripts files

Bit of an odd one here. We are still using the YUI library for cftree back from when it was included pre CF2016.When installing an update through the CFAdmin UI, the update seems to delete some things from the cf_scripts folder. Most notably the yui folder containing the yui.css file at: cf_scripts\scripts\ajax\resources\yuiDoes installing an update clean up things in cf_scripts or something? This behaviour did not exist in CF2018. We skipped over CF2021 so not sure there.

10202

2 years ago

danlbnParticipating Frequently

Questions

Secure CFIDE admin cf 2023

Is there a way to restrict access to  CFIDE admin in docker containter in CF 2023? Mapping or using special port? 

2371

2 years ago

Laura32781154plhtInspiring

Questions

ColdFusion Datasource Connection Errors as Usual

Hi All, Running ColdFusion 2023 on Windows Pro 11.MSSQL 2022 server installed. Does CF "REQUIRE" jdbc driver to connect to SQL server or is it only an option? If it's required CF should clearly state that. I know I've dealt with this before, but can't remember how I fixed it. I downloaded the jar file for it ( mssql-jdbc-12.4.1.jre8.jar )  and put it in the lib folder in coldfusion. Still no go. I don't see it listed as a driver when creating the datasource.I did restart CF and SQL server afterwards. I'm logging into SQL server using Windows authentication. I don't recall seeing a choice during installation to do it any other way. Web searches suggesting:1. make sure TCP/IP is enabled: Yes, did that.2. Get jdbc driver: Yes, did that.  Put in CF lib folder.3. Add "AuthenticationMethod=ntlm" in the advanced settings Connection String CF settings: Did that.4. Tried putting servername/username in that didn't help. Still not working. Head is

29822

2 years ago

Akash299451589siyParticipating Frequently

Questions

Failed to load resource wddx.js and wddxDes.js in coldfusion 2016

Hi We recently upgraded from coldfusion 9 to coldfusion 2016 and the error that we are getting when we try to load the code is runWddx.js:15 Uncaught ReferenceError: WddxDeserializer is not defined.From inspecting it seems that it is not able to load wddx.js and wddxDes.js these two files.Please suggest what needs to be done.Screenshot is attached for ref.

7001

2 years ago

Souvik Saha ChoudhuryKnown Participant

Questions

java.lang.IllegalArgumentException: Response cannot be null

I have a component that declares a closure,  executing the closure fails when run outside of the original request. It's calling another component function but getting this error java.lang.IllegalArgumentException: Response cannot be nullAny solution will be helpful. 

4622

2 years ago

IamJimbusParticipant

Questions

Using valuearray in cfset seems like it should be obvious and easy...

I'm trying to do the following: The query works and cfdumps 2 items as expected. valuearray fails as part of cfset set and I've tried various and sundry combinations of quotes and such with no luck. Can someone help me sort this out? The end goal is to have an array I can do an arrayFind against to see if someone gets to see a particular web app or not. Tanks, JimB 

3321

2 years ago

Anonymous

Questions

Prompt to download/ open when opening .cfm files

Hello allI have a new installation of CF8 on a Windows XP Pro machine. Configured to run on IIS. Whenever I try to open CF Administrator or other cfm files, I get a download pop-up instead of loading the file. I have IIS set up to recognized index.cfm files. I made sure CF8 is actually running.Any input?ThanksKhaled

ebcohenInspiring

Hello All,I am impressed that ChatGPT does seem to have somewhat of a handle on writing ColdFusion code. It definitely can do some things that are beyond the basics.One thing I wonder is whether anyone has any code to share to integrate ChatGPT with a text box or something via ColdFusion...so it could help answer customer questions, etc. Anyone have any ideas on this? Thank you

19062

2 years ago

georget37352040Inspiring

Questions

CF 2021 Update 10 failed to install

Hello,I am having issues updating CF2021 Update 10. After running the install i recive this error at the end of the update wizzardThe log file show these errors:Installation: Unsuccessful. 148 Successes 1 Warnings 2 NonFatalErrors 2 FatalErrors Action Notes: Failed to copy hotfix files:C:\Users\administrator.BAYNET\321779.tmp\dist\updates: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Failed to copy hotfix files:C:\Users\administrator.BAYNET\321779.tmp\dist\wwwroot: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Failed to copy hotfix files:C:\Users\administrator.BAYNET\321779.tmp\dist\updates Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:C:\ColdFusion2021\cfusion\lib\updates FATAL ERROR - C:\Users\administrator.BAYN

21033

2 years ago

danlbnParticipating Frequently

Questions

Coldfusion 2023 Docker container on ECS EC2

Hello,I'm trying to run Coldfusion 2023 Docker container on AWS ECS EC2 but the task stays in Provisioning state. Maybe someone has installed this version on AWS cloud?Another issue: Amazon image scan is showing vunerabilities in this container version.Thanks

1290

2 years ago

DavidRpsParticipant

Questions

Coldfusion 2021 Update 5 and later / XML error

Hi, I have seen this discussed with other posts, but so far they have not solved my problem. https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-update-5-breaks-xml/m-p/13387420 Here's sample code (from Ben Nadel) that works under ColdFusion 2021 Update 4 or older - but does not work on Update 5 or later.  <cfsavecontent variable="dirtyHtml"> <!doctype html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Dana Linn Bailey</title> <meta name="description" content="Strong female muscle, FTW!"> <meta name="keywords" content="female muscle,femmuscle,sexy"> </head> <body> <h1> Dana Linn Bailey </h1> <h2> Professional Bodyb

3061

2 years ago

howardt56577616Participant

Questions

Scheduled tasks not working after migrating to new server

Good morning, Im hoping to get some help with an issue with CF2021 when migrating to new server. Hoping something simple to look for but since setting up CF on a new box, my schedulede taks no longer work. I keep getting the Connection Failure: Status Code Unavailable. We did nothing different with the install of CF, and dont understand why this isnt working.

4661

2 years ago

NDiyParticipant

Questions

Activate ColdFusion 2021

Hi, I need help in activating the coldfusion 2021. I tried activate thru online and offline, unfortunately both showing failed to activate (online) and activation response file is invalid. Do you guys facing any issue on this? Tried restarted the CF services but still same, its in trial version.It's hard to connect with Coldfusion expert thru the live chat.Please help.Thank you

4031

2 years ago

MikeyBParticipant

Questions

Display Results for TextArea fields

I am a novice ColdFusion user. I am trying to display results taken from an Access database to a CF form in which users can update their responses and then re-submit. Some of the fields displayed can be responsed in one line such as #1 below (which is correct).However, I need to code how to display results to a bigger TextArea field such as #2 below which is not coded correct. How should #2 be re-written so that it can be displayed? #1<tr><td width="20%" height="25"><b><font size="3" color="#FFFFFF">Kids-Ages<br></font></b></td><td width="54%" height="25"><input type="text" name="Kids" value="<cfoutput>#Query1.Kids#</cfoutput>" size="40" maxlength="40"></td></tr>-----------------------------------------------------------------------------------------#2<tr><td width="20%" height="25"><b><font size="3" color="#FFFFFF">Grandchildren<br></font></b></td>&l

1561

2 years ago