ColdFusion

We have been having this issue for a while, and our hosting provider is unsure of it as well as the server has had Java and CF updates and patches, but it still occurs. We have looked at all of the online resources we could find, but can't find anyone else with a similar issue. We have a SIMPLE ColdFusion created CAPTCHA on our site and we notice that about 1 in 20 images has a UNIQUE character within the image. We have tried to narrow it down but the only thing we can determine is it is based on an 'Arial' font that is being used. Each time it shows up the unique character is different, so not always the 'r' or something like that. We have tried using ' fonts="Times New Roman" ' or another font, but that seemed to work for a while, but now anytime we specify the font, the CAPTCHA no longer displays ( not errors...but it ends the code at that point ). So we currently had to remove the font to get it to work. The character looks like a bunch of lines ' |||| ' so it is impossible to tell

Hello Community Members, I've written a query that generates Cross Tab or Pivot. Image Below. My Query is as followsSELECT * FROM(SELECT TOP(100) PERCENT production.Line_FK_ID,Lines.LineName,production.OP_FK_ID,Operations.OperationName,[Shift].ShiftID,[Shift].ShiftName,production.op_Time_From,production.ProductionFROM productionJOIN Operationson Operations.opID=production.OP_FK_IDJOIN Lineson Lines.lineID=production.Line_FK_IDJOIN [Shift]on [Shift].ShiftID=production.Shift_FK_IDWHEREShiftID in (1)and op_date in ('2021-07-08')Order by production.op_Time_From) ReportPIVOT(Sum (Production)FOR OP_TIME_FROMIN ([06:30:00],[07:30:00],[08:30:00],[09:40:00],[10:30:00],[11:30:00],[13:00:00],[13:30:00],[14:30:00])) As Pivot_ReportI want to make PDF report in which Production Line Wise for 6 operations for each hour. I am unable to Pivot the Hours Horizontly. The CFDUMP is as follows

Hi,Please be kind, this info is coming from one of our programmers, it's likely I will get terms wrong as I am a Blood Banker, not a programmer, hence my username.  🙂We are running CF 2021.  We are trying to connect to an offsite Oracle database.When she tried to create the connection in Data Sources she got "The ColdFusion ODBC Server service is not running or has not been installed."  In the pic below of IIS you can see the error when she tries to start it.  Is there something I need to install too?Thank you! 

I am wondering how framework one (fw1) making `view()` function available in views , like ColdFusion in built functions?. For example, in the below code , the `view()` function can be called like any ColdFusion in built functions. How fw1 making it possible?. #view(‘components/contact’)# The function `view()` has been defined in /framework/one.cfc

I am having difficulty locating documents for Terms and for the EULA for (2) no-cost Adobe Products (ColdFusion Builder and ColdFusion Report Builder).  Adobe LiveChat just indicated I would have to reach out to the Adobe Community for assistance. Any help in obtaining these documents (or links) would be greatly appreciated.Thanks,Jeff

Hello, Due to a gigantic issue that Microsoft has said that they won't fix NTLM needs to be disabled in Windows environments. However it appears that CF only supports NTLM or BASIC authentication when integrated through IIS. What exactly are we supposed to do if CF hasn't been updated in 20 years to support Kerberos 5?

Hi,I have an application for which the final output is a pdf report about an applicant from a database of applicants.If I print the form just once, all the stylesheet formatting is applied correctly.If I try to loop through the database and generate multiple reports of multiple applicants, the styles and formatting get applied ONLY to the first report, and then the subsequent reports do not have any styles applied which of course makes them unacceptable.I've tried loading the stylesheet before the loop and inside the loop, no difference.The styles being lost are for divs and tables and cells.  Fonts are handled separately by calling functions within the report which apply them on the fly.to text based on the section and type of output.Is anyone familiar with this problem?  Is there a workaround? I really really really need this to work.Thanks,RIchard

I was wondering if anyone could provide some advise regarding an app that I've had on my mind for a while back but haven't been able to get off the ground due to being in full-time work. Anyway, I attended the CF development week and that revived my interest in developing my app further but I’m a bit unsure as how to progress and wondered if you have any suggestions or advice. Currently I can see four ways forward for me:- 1) Finding time outside of work to build on my original idea and develop a working prototype. This would mean I would have to learn CFML and programming to a more advanced level than my current knowledge and also find time outside of work. The upside being I would have developed my coding skills and would have the developed some the source code. 2) I raise the funds to hire developers to build the product for me. I imagine that this would be costly! However, not impossible. 3) I find a team of likeminded developers who find the project intere

Hey folks, We're experiencing a strange ColdFusion 8 Application Server service restart nearly 1 time per hour for the past week. The only thing we can find in the CF logs that looks like it may be the cause is a constant logging of this error in coldfusion-out.log:Content disposition corrupt: Content-Disposition: form-data; name=model In the Windows Server Application log, we see the following three items when the service restart happens. #1 (Error):Faulting application name: jrun.exe, version: 4.0.7.43137, time stamp: 0x47d93af8Faulting module name: ntdll.dll, version: 10.0.17763.2028, time stamp: 0xbf07433aException code: 0xc0000005Fault offset: 0x000a2af9Faulting process id: 0x2284Faulting application start time: 0x01d77e25459648a7Faulting application path: C:\ColdFusion8\runtime\bin\jrun.exeFaulting module path: C:\Windows\SYSTEM32\ntdll.dllReport Id: 9aa3cc7c-c480-40f7-b7b6-7a9383589c96Faulting package full name:Faulting package-relative application ID: #2: (W

Is there a way I can OPEN an MS Word document with CF? I don't want to CREATE one, but only open one that exists already (then let its Autoexec function do a whole lot of stuff with the document). Thanks. -Dale

I'm having problems with the cfsetup.bat tool included with the zip installer of CF 2021. On a clean install, updated to Update 1 and installed the following packages: caching, debugger, mail, scheduler, sqlserver, zip, I encounter some problems exporting and reimporting settings using cfsetup.bat. If I export METRIC using the command:cfsetup.bat export METRIC c:\METRIC.json c:\ColdFusion\cfusion And then immediately try to import it again with:cfsetup.bat import METRIC c:\METRIC.json c:\ColdFusion\cfusion It fails with the following error(s):ERR: Invalid setting key (cfstatHost) for category: (METRIC).ERR: Import of cfstatHost in METRIC is unsuccessful.ERR: Import of METRIC is unsuccessful.ExitStatus: FAIL Why would this be the case? The default for this setting was unchanged from "127.0.0.1" and I can clearly see the setting in the UI so I know this must be a setting somewhere... Additionally I have the same problems with the RUNTIME settings. Exporting those

Hi,When checking the box next to "Enable TLS connection to mail server" in CFadmin, no email will go out. It all ends up in the Undelivr folder. However, if I also include useTLS = "yes" in the CFMAIL tag, it works perfectly.  I have CF Enterprise 2018.  Anyone have any ideas why this is happening? I'd rather not be forced to find the hundreds of places I've used the CFMAIL tag and add useTLS. Oddly, from my Dev version of CF 2018, I don't have to include useTLS... and it's using the same email server. Thank you!- Shawn  

I wrote my code in CF 2018 on my local dev environment. I had no issues with it in 2018. When I load the same code into CF 2021 Standard I'm getting an error when I try to move a file from one directory to another after reading it.  Basic set up is I read the excel file and then move it to a different directory. The file gets moved but errors out on deletion. When I try to manually do anything to the file in Windows, I get a message that the file is being used by coldfusion.exe and cannot be deleted or modified.  The only way I've been able to release this lock on the file is to restart the ColdFusion service. I tried waiting to see  if it gets release but it didn't after 24 hours.  Any ideas on how to get the file  moved to a new directory and deleted from the original after I'm done reading it?

HelloI speak for my client, he is on Windows Server 2019 is on a license of Coldfusion 10.It is since a week he has this kind of message: Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. Resources: • Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. You have how to solve this problem.Kind regardsMichel 

Hi,Suddenly, the Data Source that was working quit working for me in CF2016. The error is:I was following this post to set up DataSource.  Below is my set up.  It worked since  Nov 2020.  But, today, it quits working!  The connection string is EncryptionMethod=SSL;Encrypt=yes;TrustServerCertificate=no;HostNameInCertificate=*.sql.azuresynapse-dogfood.net; I wonder if the "HostNameInCertificate" changed. I believed I got the HostNameInCertificate from an error message in CF2016 when I set it up back in Nov 2016. Any idea on how to solve this?   Thanks!   DChan

Could anybody provide a example YAML script that demonstrates how to take updated code and deliver it to a remote test server?  I'm having trouble wrapping my head around what to deliver after a merge request.  I'm completely new to GitLab and the whole CICD pipeline process, and the examples I'm seeing are for mostly builds of other languages. My process is as follows  pull from develop  edit code  unit test with dev server  commit changes  push changes  UAT  merge request Thanks for any clarification you can offer on what commands would be used to automate this.  

Now that I have PMT monitoring remote instances, I can see a few more questions that need answers. What we have is half a dozen separate instances of CF Ent 2021 running on an Amazon EC2 server,I am running PMT and datastore on my office server. Each CF instance is one separate web site in IIS to allow for application isolation. Here are questions I need help with: 1. In PMT on the Connectors page, I see no info for any of the instances being monitored. I see that connectors are filtered by Sites so ....2. Under Topology / Servers I see all my instances. But under Topology / Sites, I am not seeing any at all. It simply says no sites available. Which might explain why I also don't see any connectors? I assume if I can't see any connectors then PMT also can't autotune them.3. When I set an instance to enable datasource monitoring, it seems to pick up each of the unique DSN names in each instance, but does not show any data at all? No queries, nothing. Even if I change the

My question is whether there's a simpler way to do the following than what I've discovered on my own. My user will run a query and make selections of items (MID) from a table. These MIDs will be stored in another table along with the user's UserID. This will allow the user to tailor another query to be populated only with these MIDs. The user might make one set of selections and then replace it later with a different set of selections.  Right now, I'm not worrying about how to code the CFML to produce the query I send to MySQL. I'm just wanting to know if this is a suitable/optimal method of doing it. tbl_user_units has three columns, UUID (autoincrement), UserID, MID.I'm using 202 for the UserID in this exampleThe user is likely to select between 20 and 40 MIDsI would use a form with checkboxes to select the MIDs Not knowing how to delete old selections and insert new ones in a single operation, I propose to first  delete all the old values using this:&nb

When I installed CF 2021 Ent I accepted the defaults like I normally do and set up the instances and all run just fine. BUT now I want to use performance monitoring toolset to monitor those instances from a remote machine and cannot make it work. CF is running everything on the internal server as localhost or 127.0.0.1 and since those are not reachable from a remote machine PMT will not connect to each instance. If I use the domain name assigned to the IIS site for an instance and port 8500, the result is a server 500 error. I assume that when I installed CF I should have specified the DNS hostname for the EC2 server instead of localhost in order to make this work, but server is in production and I cannot re-install coldfusion. So is there any way to edit config files for the internal web server used for admin and PMT to use the hostname of the server instead of localhost or 127.0.0.1? Thanks

Hello Folks,Anyone know what a CF11 upsell key is?Issue trying to upgrade CF11 Standard to Enterprise. Using CF11admin > System Information > New License then pasting in valid Enterprise key.Prompts with:ALERT! Important notice about last submission...You cannot upgrade from a Standard license to Enterprise license. Use an upsell key or reinstall the server to upgrade.Currently a CF11 Standard key is applied:About ColdFusion » Server Details  Server Product  ColdFusion  Version  11,0,04,293328  Tomcat Version  7.0.54.0  Edition  Standard    Thanks in advance, Carl.

We have a new AWS Windows server, according to AWS sizing, this server has 4 cores. We want to install ColdFusion 2021 Standard on it. It sounds like we will need two licenses. So how do we do this?Do we just purchase 2 copies of CF 2021 Standard? Presumably we will end up with 2 serial numbers. How do we get both serial numbers into the install?Thanks

We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2021 release) Update 1 ColdFusion (2018 release) Update 11 ColdFusion (2016 release) Update 17   In these updates, we’ve fixed a few security bugs and some other bugs, which are mentioned in the tech notes.   In ColdFusion (2021 release), we’ve added activation and deactivation of Virtual core licenses. In addition, we’ve introduced support for RHEL 8.3, WildFly 23, Tomcat 9.0.43, PostgreSQL 13, Oracle 19c (2018), and MS SQL Server 2019.   For more information, see the tech notes below: ColdFusion (2021 release) Update 1 ColdFusion (2018 release) Update 11 ColdFusion (2016 release) Update 17   These updates fix security vulnerabilities that are mentioned in the security bulletin,  APSB21-16.   We’ve also updated Performance Monitoring Toolset for the 2018 and 2021 releases of ColdFusion. Check out the tech notes: Col

I am having problems converting XML data into the appropriate data types using a function. I have read in an XML file using XmlParse(). Within that there is an array which I loop around. <Cfloop array=#i.Task# index="t"> My understanding is that the items in this array are XML text. I can display all the items with CFoutput no problem. One item in the array (BaseLineColor) is a colour. #t.BaseLineColor# However this colour value is a single decimal integer number of varying length. I have worked out the maths to convert this decimal number into R,G,B decimal values. All good so far. The problem is that if I try mathematical functions on BaseLineColor, then I get:The value ?xml version="1.0" encoding="UTF-8"? BaseLineColor 255 /BaseLineColor cannot be converted to a number. So OK I have tried a few methods to try and convert BaseLineColor to an integer but nothing works. Val() doesn't work. In fact I can't seem to convert it into any datatype. Fo

I am attempting to run the CF 2018 Auto-Lockdown tool.  When I get to the ColdFusion Configuration and select the available instance of cfusion I get the following error: "ColdFusion server is nor running.  Please start the server and try again." All ColdFusion services are running and I am able to log into the admin portal. I have restarted services and rebooted the maching with the same result. I also could not find any recent documentation on how to lockdown CF 2018 manually since the tool was failing. Thanks.

When installing 2021 on macOSX Big Sur throws error,  “libCFXNeo.jnilib” cannot be opened because the developer cannot be verified. This appears to be a notorization issue with Apple.  This happens with every mouse click.  My guess is the dev team used a forged certificate, which is common, and a full notorization needs to be approved by Apple. Or maybe I should shut my mouth.