ColdFusion

Having issue while inserting value through CF2021.I have a table named Pass having a column COMPANY_NAME VARCHAR2(50 BYTE). While inserting arabic value shows error [Macromedia][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "UATALL"."GATE_PASS"."COMPANY_NAME" (actual: 80, maximum: 50)though, the value I am insering here actually is 43 charectors only but showing actual value 80 while inserting: INSERT INTO PASS(COMPANY_NAME) VALUES (('شركة يخت انترناشيونال للملاحة البحرية ذ م م ') )

The date value passing through .cfm file dd/mm/yyyy ("01/03/2023") while reciving value in CFC file<cfset actualdt=lsdateformat('01/03/2023','dd-mmm-yyyy')><cfdump var="#actualdt#">outcome comes 03/Jan/2023 but it should come 01/Mar/2023.Please guide me how to come out from this issue. 

I am trying to access the collections api for the CF Admin and have a question.  I am executing a call to the reloadCollection method but it does not appear to return any value.  Here is a sample snippet of the code I am trying to execute/collectionObj = createObject("component","cfide.adminapi.collections"); collectionObj.reloadCollection("testCollection");The above executes without issue but if I try setting the method call to a variable and then try and dump the variable the code generates an error that the variable was undefined.tempTest = collectionObj.reloadCollection("testCollection"); writeDump(var="#tempTest#",format="html");Is there a way to determine if the call has executed successfully? 

Hi All,I'm trying to install CF2021 on RedHat 8.7The installer keeps exiting with the error:"JRE libraries are missing or not compatible"  Initially I thought perhaps my /tmp was not large enough so I enlarged it.Then thought to set IATEMP to another location with tons of space --still the same error.I even installed a JRE for the system --still the same errorIs this a problem with running RHEL 8.7 vs 8.5?Is there something else I should be trying? 

Trying to install Coldfusion2021 Developer on Windows 10 Enterprise using InstallAnywhere with all* the sub-components.  After ~10-15 seconds it shot up to 100% completion, and has now been stuck there for an hour.  If I press the "Cancel" button, it says Installation Not Complete and if proceeding with Cancel will not be installed.  What should I do?  I see Adobe Coldfusion 2021 and Adobe Coldfusion 2021 Add-on Services in Windows Programs and Features, so if I do have to bail out and it's not working, seems like I will at least have the chance to uninstall / retry. *If had it to do over, would DE-SELECT all of the sub-components.

In the Administrator page I can see the update 5 available to download and install, but when i click the option it just stays stuck on "starting download". Does this option not work? Or what do I need to check? I don't want to install manually since I am not experienced with CF. Any suggestions would greatly be appreciated.

I installed CF2021 Update 5 and im getting errors in my administrator in the "Server Setting Summary" and the "Updates" page.  Can i back out a hotfix manually and try to reapply it?

Hello. I've got a website that uses cfntauthenticate to authenticate users.It's been working great, but after moving the website to a new server it's suddenly stopped working.When trying to authenticate, this is the error message I get:javax.servlet.jsp.JspException: coldfusion.security.BadUserNameException: The user name or group name <username> is invalid in domain <domain>.The error message sort of makes it seem like there something wonky going on in the connection between the server and the domain controller, but I'm not sure. Old and new server is in the same domain.Can't find anything related to this in the logs.It's even working when I develop locally on my laptop. I've tried to do some googling, but haven't really been able to find anything.Anyone here got any ideas on what the issue could be? (Originally we were using cfldap, but after migrating to using cfldap with starttls, we were seeing intermittent login errors (e.g. your first login would

Hello, I'm trying to create a simple multi-upload page with javascipt progress bar.All wordks fine if I upload a few (22 or less) files, but if I upload more than 22 files, en error occures "net::ERR_CONNECTION_RESET". (the idea is to be able to upload at leats 1000 files in one go) Im running CF2023 on a windows server with IIS. U|sing the page throug IIS or directly with IPadres on port 8501 makes no difference.I have tried to use smaller files, but whatervere I do, I'm not getting the files to upload if uploading 23 or more files.The upload works with XHR2 acync. Can anyone tell me what I'm doing wrong, or where to find the correct setting to change this behaviour Thanks in advance

Hi, I am trying to manually execute Update 5 for Cold Fusion 5. I have stopped the ColdFusion2021 Application Server service. I am trying to execute the following:D:\ColdFusion2021\jre\bin>java.exe -jar D:\Hotfix\hotfix-005-330109.jar I am receiving the following message after trying to the above commandThe process cannot access the file because it is being used by another process. Does someone have an answer? Thanks, Mike  

Hi all,We are seeing a really weird, totally random crash on 2018. This is with code that is currently running fine in production on 2016, and ran fine on 11. Here are definitions for three simple objects that produce the crash:BaseEntity.cfccomponent mappedSuperClass="true" accessors="true" {    property name="id" fieldtype="id" generator="identity";} BaseType.cfccomponent mappedSuperClass="true" accessors="true" extends="BaseEntity" {    property name="title" fieldtype="column" ormtype="string";} PersonType.cfc component accessors="true" extends="BaseType" persistent="true" {    property name="People" fieldtype="one-to-many" cfc="Person" inverse="true" inverseJoinColumn="PersonTypeID" singularname="Person";} PersonType.cfc here is just an example. The third component in the chain could be totally empty (so only containing the inherited ID and Title).What we are seeing is that Coldfusion 2018 will crash at a random time, with an exception t

Hello:I need to replicate the following cURL call, which uses a multipart/form-data header and form fields: curl -L -R POST "https://api.XXXXXXXX.com/api/v1/academic_success/sync/enrollment" \-H "Authorization: Bearer <access_token>" \ # Generated OAuth2 token request-H "Content-Type: multipart/form-data" \-F "input_type=CSV" \-F "input_data=@enrollment_upload.csv" \ # Path to CSV file. Include '@' before path.-F "dry_run=false" \ # Set to true when testing-F 'drop_not_passed_enrollments=true' \ # only enabled when dry_run = false CFHTTP does not allow specifying form fields for multi-part data. I assume I'd have to code a header that included the form fields as part of the body along with the data, but am unclear on how to do this. We are currently production with CF 2018.Thanks.Gerry, Pace University 

Good morning, I recently upgraded from Coldfusion 2016, to 2021, with no real problems but did notice one thing that I cant seem to get a handle on. I do exporting of data though CF to build formatted spreadsheets, and since the upgrade, one thing no longer works and it is related to the setRepeatingRows. I use the "cellRangeAddress = CreateObject("java", "org.apache.poi.ss.util.CellRangeAddress");" followed by "poiSheet.setRepeatingRows(cellRangeAddress.valueOf("$1:$1"));" and get an error that says The setRepeatingRows method was not found.Either there are no methods with the specified method name and argument types or the setRepeatingRows method is overloaded with argument types that ColdFusion cannot decipher reliably.Has anyone run into this and would happen to have an idea around it?  

We've got an intranet hosting web apps written in ColdFusion with some RESTful services set up to query from our databases and return JSON for the web pages. Recently, we upgraded our development server from ColdFusion 2018 to ColdFusion 2021; afterwards, our calls to the REST service began returning objects that break our Javascript. On closer examination in the network tab, the JSON is all present and properly formatted; the only difference we can see is that the 'content-type' header of the returned object is 'application/json' on our production server (still running 2018), but 'text/plain' on our development server. We've confirmed that the RESTful services are all properly registered on the development server and that the REST API scripts, site scripts, and Javascript are all identical between the development and production servers. See below an example function from one of our REST API scripts:  <cffunction name="getProject" access="remote" returntype="Stri

Since upgrading from CF11 to CF2021, the <cfpdfform> tag no longer works - that said, not sure if the upgrade is the issue or not. In the past (on CF11), we’ve successfully generated a pdf file with the code:<cfpdfform source="Avery45008CopierMailingLabels_HBD.pdf"destination="E:\HBD_DEV\files\DestiAvery.pdf"action="populate"overwrite="true"overwriteData="yes"/> No file is generated, nor is there an error message displayed in the browser (see exception log below). I've also used the following code, as suggested by CFSupport via StackOverflow, which results in the same error:<cfpdfform source="Avery45008CopierMailingLabels_HBD.pdf"destination="E:\HBD_DEV\files\DestiAvery.pdf"action="populate"fdf="true" />Coldfusion 2021: Update 5Our JAVA version is: jdk-11.0.17 We've also deleted all files in the cfusion/bin/felix-cache and cfusion/wwwroot/WEB-INF/cfclasses folders. No love.Looking in the exception log, we find:(the culkprit appears to be "java.lang

I'm getting the error "Invalid CFML structure found on line 10019 at column 34."I know the code at line 10019 (in cfscript) has no problem.When adding a new line (by enter key at anywhere before the error line) it still gives an error at line 10020,but when adding one more new line it's OK.What is the cause?I have tried several different things like:add or delete any comment or cftag it's OK.(or remove a space then OK, but adding a space then gives an error ※after a little modification)※any modifications after the error line(10019) is not efficientI use ColdFusion2018 update15, pageEncoding="SJIS".

Recently we moved from cfusion11 to 2021. While generating pdf file sometimes image breaks. Please suggest us solution if anybody face same issue and came out from that.

Using cfinclude tag throwing error and recommended to put this.mappings in application.cfc. but how to use that mapping in cfm file with cfinclude tag. Please guide if anyone face smiler issue.

I've create a excel file with CFSpreadSheet and now I want to change the color of a cell to a hexcolor that is not available with CFSpreadSheet.  Can it be done with javascript? <cfset xl = spreadsheetNew("Hazard Details",true)><cfset SpreadsheetAddRow(xl,"Test")><cfset SpreadsheetFormatCell(xl,{color="red",bold="true"},#xl.rowcount#,1)> Will set it to red.  But I want to use a color that is not available with cfspreadsheet like hexcolor #355f91something like:<cfset SpreadsheetFormatCell(xl,{color="#355f91",bold="true"},#xl.rowcount#,1)> 

We have an instance of CF2021 running on RHEL.  Our database is SQL Server 2019 running on Windows Server 2019.  We are trying to establish a database connection through the CF Admin to said database but keep getting a timeout error.  The server is not running on port 1433 (it is using another port) and has DOD and Entrust certs.  Do I need to export those certs and import them into the CF JVM to establish that "handshake"?  Or, would I be better off just running CF on Windows?  Any help is greatly appreciated.

Hi ! Dear expertsI wrote a simple program to send LINE notifications to customer groups via IFTTT.Just pass three simple URL parameters, which are as follows: <CFHTTP Url=https://maker.ifttt.com/trigger/mic0121_line/with/key/boYiM....   Method="get" Charset="utf-8" ResolveUrl="Yes">  <CFHTTPPARAM Type=“url” Name=“value1” Value='test_url_01'>  <CFHTTPPARAM Type="url" Name="value2" Value='測試參數 2' >  <CFHTTPPARAM Type="url" Name="value3" Value='測試參數3' ></CFHTTP> mic0121_line is the LINE customer group code defined in IFTTT, value1, value2, value3 are 3 URL parameters, some of which are Chinese Traditional characters (big5 code). These codes are OK on the CF2021 Update5 test on ColdFusion Fiddle.But why can't I send it properly when executed on my installed CF2021 Update5 computer. Are there any settings that need to be changed in CF2021 Adminstrator?

Recently we have seen an issues with number having 16 digits.For eg val(9999999999999399) internally getting coverted to some other number. In this case its 9999999999999400.Because of which we are facing a lot of validation issues and challenges. Is there a  way to handle such huge number in coldfusion.The other workaround is to convert it to string but wated to check with all the possibility before doing so. Thanks!

Hi I am facing an issue where in SOLR search result in some results context column is empty string. I am receiving in some but not all. I am using CF 2021.Why is this so?Kindly help

HelloSorry I think I may have asked this question in the past but now this has become a comedy of errors.Simply put, there are two tables in the same DB containing rows of individuals last names, first, DOB etc,Table 1 has 3000 recordsTable 2 has 4000 in which the above 3000 are intermingled with no other matching identity except last name.I need the query to pull out the 1000 names that were added. No success yet on several approaches. Last names are nvarchar max, SQL Server. <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">Select lastname1from TABLE1join TABLE2on ' '+ lastname1+' ' not like '% '+ lastname2+' %'ORDER BY lastname2 ASC <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">SELECT lastname1, lastname2FROM table1, table2WHERE lastname1 NOT LIKE '%lastname2%'ORDER BY lastname2 ASC</cfquery>  <cfquery name="find_added_lastnames" datasource="#Request.BaseDSN#">SELECT lastname1, lastname2FROM tab

We are using Coldfusion 2021 and iText 7.4When loading the license, I get the error _objectFieldValueSeparatorWithSpaces I have finally nailed it down to the fact that iText uses Jackson .jar files version 2.12 while ColdFusion uses the same .jar files version 2.8.Question... will Coldfusion work properly with jackson 2.12?