Questions

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?

Day 2 of testing CF 2021 and I'm puzzled by what seems to be another bug.  Consider the following: <CFSet A='147.xxx.yyy.zzz'> <CFOutput> #A#---<br> Left 4: #Left(A,4)#---<br> Left 4 eq: #iif(Left(A,4) eq '147.',DE('Yes'),DE('No'))#<br> Left 4 is: #iif(Left(A,4) is '147.',DE('Yes'),DE('No'))#<br> Left 4 equal: #iif(Left(A,4) equal '147.',DE('Yes'),DE('No'))#<br> Left 4 CFIf eq: <CFIf Left(A,4) eq '147.'>Yes<CFElse>No</CFIf><br> Mid dot: #iif(Mid(A,4,1) eq '.',DE('Yes'),DE('No'))#<br> Left 3 Compare: #iif(Left(A,3) eq '147',DE('Yes'),DE('No'))#<br> First Item in List: #iif(GetToken(A,1,'.') eq '147',DE('Yes'),DE('No'))#<br> </CFOutput> This outputs the following in CF 2021 (update 4): 147.xxx.yyy.zzz--- Left 4: 147.--- Left 4 eq: No Left 4 is: No Left 4 equal: No Left 4 CFIf Compare: No Mid dot: Yes Left 3 Compare: Yes First Item in List: Yes But in CF 201

I have an app recently migrated to CF2021 from CF9. We are finally able to get FusionReactor on it to track why it has periodic slow downs and excessive memory usage.  While I am still deducing, I can see chunks of memory allocated to coldfusion.monitor.memory.MemoryTracker. Some research online attributes this class to the PMT, though we do not have PMT enabled. Is this normal? How can I turn off PMT if it is somehow running while not enabled? We have not yet installed our license so are running under Dev mode until we pass testing.    

Can Coldfusion 2016 spider a site out of the box? If not can solr that ships with CF spider a site

I am running a docker container locally and it's running very slowly.I use Windows 10 and WSL 2.I use the app folder as volume.Without volume, it's running better.I use this command: docker-compose up -d --build 

I am getting the following error when trying to connect CF2021 and Oracle 19. Please let me know if anyone has faced similar issues before.. Only complexity is that the StoredProcs are created referencing Column type. Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 This code works when run form CF10 environment (Driver used SeeFusion (Oracle)However from CF2018 or CF2021 it does not work (Driver used Oracle) Below is a sample code (cfml page).I have tried with CF_SQL_NUMERIC as well instead of CF_SQL_DECIMAL <cfset arguments = StructNew() /> <cfset arguments.username = "userName" /> <cfset arguments.P_GROUP_PR_SEQ_NO = "10" /> <cfset arguments.groupName = "g" /> <cfset arguments.cboID = "17065" /> <cfset arguments.P_GROUP_MANAGER_PR_SEQ_NO = "10" /> <cfset arguments.groupIdentifier = "g" />

Hello,For a new installation, I get an error 500 with the detailed information as follow:Module: IsapiModuleNotification: ExecuteRequestHandlerhandler: cfmHandlerError Code: 0x800700c1 I checked that IISUser has permissions in c:ColdFusion2021/config and at the physical path of the directory I try to access.ColdFusion administrator works with the 8500 port. Does it means taht the error is with IIS or could it be something I have not set properly?I also checked everything suggested on the following post:https://helpx.adobe.com/ca/coldfusion/kb/troubleshoot-error-500-coldfusion.html Any suggestion on how to fix this 500 error that was not covered by the previous link?

Hi, Is there way to prevent host header attack on CF2016 (Win Server 2008 IIS7.5)? We had server scan and identified this vulnerability where X-Forwarded-Host was modified to trigger redirect to potentially malicious site.I have seen some references to adding dummy virtual hosts to apache server but, I am not skilled in server administration and not sure how to do that in CF2016. Thank you,Gena

Hello all, We recently upgraded from Coldfusion 9 to 2021.  Coldfusion 9 was using jrun as the java server, while 2021 uses Tomcat. On 9, we had a separate server running some servlets we had written, and works just fine.  I can't figure out how to duplicate this feature in 2021.   I created a separate instance, and placed the class files (after recompiling) into the classes directory, but it cannot find them.  I get a 404 error, with the message "The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.".  I did create a simple .cfm page that works fine, but cannot call the class.  Is there a document or something that could point me in the right direction?   In jrun, the main thing I had to do was add to the config was "<attribute name="url">file:<path_to_servlets></attribute>".  I don't see an equivalent in tomcat. Any hint

We have released fixes for both ColdFusion (2021 release) and ColdFusion (2018 release) that help authenticate IMAP, POP, SMTP, and Exchange connections using OAuth. For more information, see this KB document.   We've also released an update for cfexchange for both ColdFusion (2021 release) and ColdFusion (2018 release). The document also lists the steps to apply the update.   Apply these updates and let us know your feedback.

HelloI need to keep the accent marks in the SQL Server database.My imported data (4000 + records) from a CSV in Excel contains hundreds of French diacriticals:é –  (l'accent aigu)à/è/ì/ò/ù – (l'accent grave)â/ê/î/ô/û –  (l'accent circonflexe)ç – (la cédille)ë/ï/ü –  (l'accent tréma)Each instance in the strings have changed to ? diamonds no matter what they were supposed to be. Is there a way to repair them after they have been imported or do I need to do this in the CSV file before the import, if possible?  What character encoding will SQL Server keep?Thanks for any help with this.

Hello, part of our website is down and our institution uses Cold Fusion.  Currently our primary support person is not available.  Can anyone suggest a company or group that might be able to help?  We are located in Western NY.  Thanks!

Just a heads-up: the URL for joining the CFML Slack workspace and channels has changed. If you want to join the CFML Slack, use the form at cfml-slack.net.   As some may have noticed, the old URL for joining (cfml-slack.herokuapp.com) no longer works. Since it's mentioned in many places on the web, I wanted to help spread this news. This cfml-slack.net URL replaces that one, while the URL for the CFML Slack channel itself is unchanged: cfml.slack.com.   For more explanation/context, and especially if you may be new to considering the CFML Slack, see my blog post with more on this recent change.

Back in ColdFusion 10 we developed a few APIs using the new (at the time) abilities of CF to publish REST services.  Fast forward to now and we're looking to make some upgrades in how the APIs are published and how we manage them.  First we looked at the ColdFusion API Manager that Adobe began giving away in CF2016.  While this looked to have promise, we're running into issues with it and a lack of support know how.  So, we're thinking of going with a service more popular with the rest of the world. As we've dug further, we're intrigued with Rapid API and publishing on their platform.  Going through the setup, there is an option to upload your OpenAPI specs to auto-load your API.  However, the earliest version of Swagger/OpenAPI they support is 2.0.  Unfortunately, it seems Adobe has let this part of ColdFusion languish without an update because CF only produces Swagger 1.2 docs. Does anyone know if CF will be updating their Swagger/Ope

HelloI'm using a query to match first & last names from a main table (ged_main-3543 records) on a lookup table (marier_main- 264 records). When I use this query, I get 25 matches:<cfquery name="match_ged_fam" datasource="#Request.BaseDSN#">SELECT ged_lastname, ged_firstname, ged_datebirth, ged_placebirth, ged_datedeath, ged_placedeath, marier_lastname, marier_firstnameFROM ged_main, marier_mainWHERE ged_lastname LIKE marier_lastnameAND marier_firstname LIKE ged_firstname</cfquery> When I use this query, I get 67 matches: <cfquery name="match_fam_name" datasource="#Request.BaseDSN#">SELECT ged_lastname, ged_firstname, ged_datebirth, ged_placebirth, ged_datedeath, ged_placedeathFROM ged_main t1WHERE exists(SELECT marier_lastname, marier_firstnameFROM marier_main t2WHERE CHARINDEX(t2.marier_lastname,t1.ged_lastname)>0AND CHARINDEX(t2.marier_firstname,t1.ged_firstname)>0)</cfquery> I am trying to figure out why the results are not the s

We have a failing web server, and legacy Coldfusion Application I am trying to migrate to a new server.So I have a new server I am installing on and going from CF 2016 to 21. Things for the most part are working fine, but I am stumped on one error. I am not a CF guy , just inherited an app. Years ago I had to do an upgrade form one older version to another and found it was due to variable case sensitivity changing so I have hunted around in the past as well. I keep thinking the behavior means something small is missing like that variable I have seen in the past Out of a few menu choices, one lets me run a few queries and export to excel. The queries run fine but I get an immediate 503 error when I try to export. One of the other tabs has export code and works with no problem.if I hit the website(its an internal website) using http://192.XXX.X.XX:8500/WEBSITE, I get no errors at all, even on the menu that perviously errors. The 503 error is if I hit it by name http://intr