ColdFusion

I assume that QueryGetResult is meant to be paired with QueryExecute, to get the same thing you would get from the result="..." attribute of <cfquery>. But the only thing I ever use that for is to get the generated_key after an insert, and that doesn't work because QueryExecute returns null on an insert, so I don't have an object I can pass to QueryGetResult. The author of the documentation page on QueryGetResult doesn't seem to be trying to explain what it's good for. There are just some apparently random examples of SELECT queries where the result object doesn't tell you anything new. There's a bug report (CF-4217809) about that documentation page already, from someone who had expectations very different from mine, but was also not helped by the short list of unmotivated examples. There are plenty of other ways to do a query and get a generated_key, so this isn't a major obstacle. I'm just wondering, am I not getting the right result because my environment (MySQL

Hi everyone.I'm attempting to prepopulate an IRS Form 1041 for a population.  I am able to populate the text fields fine, but the checkboxes show as checked but when the form is saved the checked box doesn't persist.Private Sub Command8_Click() Dim FileNm As String Dim FileNm2 As String Dim aApp As Acrobat.AcroApp Dim aAVDoc As Acrobat.AcroAVDoc Dim aPDDoc As Acrobat.AcroPDDoc Dim JSO As Object 'There is no explicit class type for the JSObject FileNm = "\\its\fss\Plans\PEO-MEP\RichAnthony\EditPDF\IRS Form 1041_2023.pdf" FileNm2 = "\\its\fss\Plans\PEO-MEP\RichAnthony\EditPDF\1041_Reports2\" Set aApp = CreateObject("AcroExch.App") Set aAVDoc = CreateObject("AcroExch.AVDoc") If aAVDoc.Open(FileNm, "") Then Set aPDDoc = aAVDoc.GetPDDoc() Set JSO = aPDDoc.GetJSObject() 'Debugging - output all fields ' For i = 0 To JSO.numFields - 1 ' Set Field = JSO.getField(JSO.getNthFieldName(i)) ' Debug.Print i, Field.Name, Field.Value, Field.Type, F

After installing Update 2 for ColdFusion 2021, calls to cfreport with a .cfr template are erroring out with "Report compilation error." I can't see any other details. These reports have been working flawlessly for years. Any ideas how to resolve this?

I have installed coldfusion in my machine recently. The thing is that my cfm files are not recognising the classes of the linked style sheets though I have given the correct path of the location of css file. Also it couldn't recognise <img src=""> tag to display an image. Please help me out to solve this issue.

In ColdFusion (2021 release), you can now install only the services your application needs and nothing more. Modularisation lets you continuously integrate small pieces of code and deliver applications quickly and seamlessly.   Modularization reduces the complexity of a system. More formally, we can define modularization as dividing any system into independent functional units to allow replacement and/or removal of these units.   In Adobe ColdFusion (2021 release), you can install ColdFusion features as packages for a specific purpose. For example, you want to execute oracle database operations, you can install the oracle package.    In this blog, I shall write about installing ColdFusion packages via command line: Interactively Non-interactively   There is also a third way to instal packages, via the ColdFusion Administrator, which I shall discuss in a future blog.   Start CFPM from command line Using the ColdFusion Package Manager (cfpm), you can inst

Hello All, Will try to document this without the wall of text that would fully explain everything. Anything seems unclear, please ask. Trying to save others from wasting some of the time I have. Been working on setting up some new production servers, with Windows Server 2022 Standard and Coldfusion 2021 standard. Following the hardening guide as posted on Adobe website. There are two main issues I have figured out, which may or may not be related under the hood.  Part 1, installing CF2021 and updates:Installed with recommendations from the hardening guide, specifically removing all Sub-components and Servlets as recommended on page 9 of the hardening guide.Upon completion of the install, create a test SQL Server Datasource and test it works (relevant for part 2 below).Check package manager page in Administrator. Latest installer download as of yesterday is at updater 2 download Updater 11 (relevant for the fix of part 2 below) and Updater 12 from

Hello ColdFusion users, We are pleased to announce the availability of the updated ColdFusion Builder extension for Visual Studio Code.    Highlights of the release ColdFusion Builder extension for Visual Studio code (update 2) (release date: January 16, 2024) contains dictionary support for the functions added in ColdFusion (2023 release), such as JWT, serialization, and XML. The update also contains a few bug fixes.   Version information After installation, the new version is 1.0.507.   Release notes View the release note for more information.

Am developing a site which is up & running with CF2023. It serves html pages just fine. However, cfm files produce the following error.  Note: I do have an active mapping to the folder containg the code for the site. I would be very grateful for any suggestions.  Thanks in advance.HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.Most likely causes:It is possible that a handler mapping is missing. By default, the static file handler processes all content.The feature you are trying to use may not be installed.The appropriate MIME map is not enabled for the Web site or application. (Warning: Do not create a MIME map for content that users should not download, such as .ASPX pages or .config files.)If ASP.NET is not installed.

For PCI compliance reasons we need to restrict outbound access on some CF servers. From the license.log we can see that the domain required for activation is adobe.coldfusion.io . That's fine when internet access is enabled. What we would like to do (in AWS) is to effectively whitelist this 'domain' but AWS will  only accept IP addresses, and as far as we can tell this domain uses dynamic IP's. Clearly this can all be worked around by our DevOps guys as and when required , but ideally we would have IAC code to handle this automatically so that newly built AMI servers do not require a manual patch to temporarily allow internet access to activation and then close it down, i.e. we would like a more 'permanent' solution.So the questions to the Adobe community: is there a known range of License activation IP's we could rely on (without having to do reverse lookup and figure it out on-the-fly) ? Or, has anyone else using AWS internet restricted serves encountered this and found an

Hi, i installed CF2023 on windows and apache 2.4.58I configured apache DocumentRoot and directory on c:/www and i test and work fine with virtual hosts with html pages.I configured the connector with "web server configuration tool" but don't run correctly. The configurator add correctly to httpd.conf Include "C:\Apache24\conf\mod_jk.conf"Include "C:\ColdFusion2023\config\wsconfig\1\mod_jk_vhost.conf" when i try to view a page, for example index.cfm I view the index file present in the directoryC:\ColdFusion2023\cfusion\wwwrootwhether you use the server's IP or a domain configured as virtual hoststhe mod_jk.log log doesn't give me any errorsI configured the connector with:appserverhost: localhostweb server propertiesconfig directory: I choose the right dirApache virtual host: I select "all"In Advanced i chose apache exe file where am I wrong or what should I do to make the connector work properly? Many thanksMarco  

Hey, trying to setup CF 2023 / Java 17 to run properly on Kubernetes and while trying to setup jvm.config and setting -XX:MaxRAMPercentage=70 -XX:InitialRAMPercentage=70rather than something like-Xms1024m -Xmx1024mas it is much easier to manage regarding the pods memory requests, Service is starting just fine but the "Java and JVM" admin console is broken with errorElement JDKPATH is undefined in FORM. The specific sequence of files included or processed is: /opt/coldfusion/cfusion/wwwroot/CFIDE/administrator/settings/jvm.cfm, line: 227 My guess is that console is trying to read -Xms and -Xmx values in a non safe way and should fail gracefully or even better deal with XX:MaxRAMPercentage and XX:InitialRAMPercentage (and others).Also, would love to know if anybody has more experience on running CF 2023 in Kubernetes and some best practices for it. Really interested on Garbage Collection settings for example.

Hi,I'm installing cf 2023 standard edition on a windows server.I have installed apache web server.At this link:https://helpx.adobe.com/it/coldfusion/installing/installing-the-server-configuration.htmlI found the installation steps. How do I start this builder? because I downloaded the GUI version but when choosing the webserver it only shows me the build-in  I hope I was clearMany thanksMarco

Adobe published these books for Adobe ColdFusion 8 and 9: Exist some new edition for Adobe ColdFusion 2021 or 2023?

Has anyone attempted to perform OCR with CF? I have been tasked with extracting the text from a faxed image file (TIF).   Are there any open source OCR APIs to integrate with CF? 

Exists a current version about Adobe ColdFusion Report Builder as Adobe ColdFusion Report Builder 2023? 

On my production server (coldfusion 2023) the following error is displayed "The web site you are accessing has experienced an unexpected error. Please contact the website administrator. " and under it it shows the error "The following information is meant for the website developer for debugging purposes.Error Occurred While Processing Request ..."For security reasons I don't want de server to show the error. So I have disabled the debugging output in coldfusion admin but it still shows the error eb=ven after a restart. What am i missing here?

The Coldfusion Application Server service can sometimes just freeze.  It does not fail, it just stops working. Restarting the service fixes this.  Can occur when a server re-boots after overnight patching or just stop in the middle of the day.  There are often serveral days between this happening. (1) Does anyone know why this happens?(2) Thinking of making the service Automatic Delayed start instead of Automatic start (in case it was waiting for other services to start in the re-boot cases) - BUT are there other services who will still be Automatic start that depend on this service? If this does not resolve the issue, we will run a regular job to just restart this service each day.

Hi everyone, I am using the CFDOCUMENT to create the traditional "print this page" method from informational page of services. I am using this tag since CF7 and I would say that I am use to it. since I am now using CF8, it seems that the tag change a bit. I am not talking about the new features we can use with this tag (such as CFDOCUMENTSECTION) but when I am using the CFDOCUMENTITEM to create my "header", the font and the image are not show up as I asked. for an example, I asked to display a text in the font-size 10pt while I display a text in the footer with the font-size 8pt; the text from the footer is much bigger than the text in the header! As for the logo of the company, it has 176 X 117 pixels but it appears on the screen like a 50 X 30 pixels. Is it something that I miss how to use this are of a CFDOCUMENT? And more important for me, Am I the only one who got this problem? Thank you for any assistance! And here some code for the one of you who would like to see the detail

I have a fairly long HTML page which produces a PDF via CFDocument, but this apparently has a mind of its own, as it is not obeying the font sizes I put in. Whether it is 10pt or 50pt, it comes out exactly the same. So I can't tell if I'm missing something, or it's just not working. I've tried putting the CSS directly inside the CFDocument tag, in the stylesheet, etc., no change. I think it may have something to do with the scaling mentioned at the bottom of the LiveDocs page for CFDocument, though I can't get it to scale back up to 100%. It looks larger on page with less data, and smaller on pages with a lot of data. Suggestions?

I have been getting conflicting information. Just want to make sure I will be able to use this license if I buy.

ColdFusion 2023 Licensed Standard Edition (also tried on Enterprise Edition trial). We have a MongoDB NoSQL Database we wish to access from ColdFusion. We have a known-good connection string to the database which we can use with NoSQLBooster and MongoDBCompass on the server. What I cannot get to work is the datasource in ColdFusion. I can configure a datasource using 3rd party JDBC drivers, but these come with a hefty annual fee. ColdFusion advertises support for MongoDB, so cannot justify this unbudgeted expense. In earlier versions of ColdFusion it was necessary to download and install MongoDB separately. I've attempted to follow the instructions to use cfpm.bat with the 'install cfmongodb' command but the server responds with 'cfmongodb (2023.0.05.330608) package is already installed'. Support for MongoDB appears to be present. The message returned by CF Admin NoSQL Datasources is:Data source could not be verified. Unable to connect to the MongoDB datasource with host

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'In******gy.HCSS.App'.  The error occurred in Application.cfc: line 199-1 : Unable to display error's location in a CFML template.VENDORERRORCODE  18456SQLSTATE  28000SQL   UPDATE TApplication SET Web_Path= (param 1) ,Upload_Path= (param 2) ,CFWeb_Path= (param 3) ,CFUpload_Path= (param 4)DATASOURCE  db******4 Resources: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'In*****gy.HCSS.App'. at macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.s

Hello,I have ColdFusion 2021 HF 12 running on Windows Server 2016, connecting to an SQL database and to Crystal Server 2020 for generating reports. Everything works without issue until I request a report over about 400 pages. In that case, CF crashes with a generic 500 error when trying to open the report returned from Crystal Server. I cannot find where in CF I can configure a larger buffer or transfer limit to allow the larger file. Any suggestions? The report will be about 600 pages in pdf format.Thanks,Todd

Hey all.Had something weird happened last night/this morning.Post OS Updates (I don't think it's MS Updates - but it is a change) last night my production instance of our CF21 server stopped connecting to the backend SQL Server with the following error: Connection verification failed for data source: <DSNName>java.sql.SQLException: Timed out trying to establish connection Looking in the coldfusion-error.log I see.... Exception in thread "Thread-948" java.lang.NoClassDefFoundError: com/ddtek/jdbc/extensions/ExtEmbeddedConnectionat macromedia.jdbc.sqlserver.base.r.dg(|SQLServer|6.0.0.1282|:49)at macromedia.jdbc.sqlserver.base.s.I(|SQLServer|6.0.0.1282|:135)at macromedia.jdbc.sqlserver.base.BaseDriver.connect(|SQLServer|6.0.0.1282|:190)at macromedia.jdbc.MacromediaDriver.connect(MacromediaDriver.java:256)at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:666)at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(Conn

We are on CF21 with hotfix update 10 installed.Our IT department runs security scans and the results are flagging these log4j files.Some are in the recycle bin, installer folders, hot fix folders and others in JRE folder. Question, can be deleted and which ones needs to remediated?Thanks in advance.  (F:\ColdFusion2021\cfusion\hf-updates\hf-2021-00005-330109\backup\lib\log4j-core-2.13.3.jar) (F:\$RECYCLE.BIN\S-1-5-21-2905054116-597314085-1704472974-66584\$RJBPHP9\backup\lib\log4j-core-2.13.3.jar) (F:\$RECYCLE.BIN\S-1-5-21-2905054116-597314085-1704472974-66584\$RJBPHP9\backup\jetty\lib\ext\log4j-1.2.17.jar) (F:\ColdFusion2021\cfusion\hf-updates\hf-2021-00005-330109\backup\jetty\lib\ext\log4j-1.2.17.jar) (D:\misc-installers\log4j-core-2.16.0.jar)  (F:\ColdFusion2021\jre\lib\log4j-core-2.13.3.jar)(F:\$RECYCLE.BIN\S-1-5-21-2905054116-597314085-1704472974-66584\$ROWNOOF\backup\lib\log4j-core-2.13.3.jar) (F:\$RECYCLE.BIN\S-1-5-21-2905054116-597314