Questions

I'm trying to architect a small feature which reds the full .cfmail files before they leave the server.  The reading can be done either of a copy or the original, I just need to be able to read the contents of every single file that gets written to the spool directory.   Question: does the polling feature work flawlessly for this purpose, or is there a possibility of one/some getting removed by CF before the polled gateway can read it?  And if, the latter are there any solid, production alternative approaches. Thank you in advance. - Pete

 Good morning everyone.I am planning to upgrade from Coldfusion 9 to the 2018 STD version and I would like to know about the file with the Admin's defined settings, such as the annotation of databases, schedules ... So I don't have to rewrite everything again, which file saves these settings so that I can copy to the new version?

I have a CF application sending newsletter emails last 10 years and working just fine. Here is the simple code. As you see I let all connection settings to be taken from the CF server settings (see below) <cfmailsubject="blah blah" from="sender@mydomain.com"to="whatever@whatever.com"type="html" charset="utf-8" timeout="120"> Recently others did an update to the certificates of the email server (smtp.mydomain.com). Now my application can not send emails anymore, although I changed nothing to my system and code. My emails from spool folder go to the Undelivr. The error message I get in the mail.log is"Error","scheduler-1","06/16/20","16:37:56",,"javax.mail.MessagingException: Could not convert socket to TLS; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: timestamp check failed" What's does that mean? Does it mean now something ab

Hi all, I have a CF application sending newsletter emails last 10 years and working just fine. Here is the simple code. As you see I let all connection settings to be taken from the CF server settings (see below) <cfmailsubject="blah blah" from="sender@mydomain.com"to="whatever@whatever.com"type="html" charset="utf-8" timeout="120"> Recently others did an update to the certificates of the email server (smtp.mydomain.com). Now my application can not send emails anymore, although I changed nothing to my system and code. My emails from spool folder go to the Undelivr. The error message I get in the mail.log is"Error","scheduler-1","06/16/20","16:37:56",,"javax.mail.MessagingException: Could not convert socket to TLS; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: timestamp check failed" What's does that mean? Does it mean now

Dear communuity,We have upgraded our CF licence from CF2016 (Standard Edition) to CF2018 (Standard Edition).Is it allowd to use both servers in parallel until the migration is completed (and how many weeks do we have)?Best Regards,Eric

UPDATE:  They don't know what happened, but it suddenly started working with no errors.  CF2016.  smh Hello, all, The title has the error message that is being sent via email due to error trapping. The odd thing is that no associated or included page, nor on the page itself, has a query running on the line number indicated (86).  I've gone through all of the application.cfc and looked at queries that are in cfcs that are called by application.cfc and none of them are running a query on or near line 86. The REALLY odd thing is that we have two servers running in failover mode (not load-balancing like you'd think) and the error is happening on only one of them.  We've made sure that the webservers have identical configs, and both CFAdmins have identical configs. Our SA will soon email me the coldfusion and error logs for me to peruse, but I thought I'd get this posted ASAP to see if anyone has any ideas. 

having trouble multiplying form variables.  I have not used CFML for years and I am not sure what I am missing.  <cfset variablea - #form.b# * #form.c#>I have use '' and () in this as well.

We have a situation where we have code that works on a developer's computer (Windows 10, CF2018 Dev. Ed. (Enterprise-level functionality), plus whatever else is unique about their system), but does not work on a dev/test server (Windows Server 2019, CF2018 Standard Ed.). The specific issue is with font handling. The code uses fonts, based on a user's language preference (English, Spanish, or Chinese), and builds a PDF, using CFDocument. On the developer's computer, the logic for using this font OR that font works. On the dev/test box, it does not. This indicates to me that the code can access the fonts needed for the either/or choice on the developer's computer, but cannot access those fonts on the dev/test box. Do you have any suggestions on how to find the differences between the two systems? We have confirmed what I think are the easy things, same upgrade level, same Java version, Font Management settings, same CF Admin settings, etc. I have also looked at the system fonts on the sy

 I have a CF application sending newsletter emails last 10 years and working just fine. Here is the simple code. As you see I let all connection settings to be taken from the CF server settings (see below)  <cfmailsubject="blah blah" from="sender@mydomain.com"to="whatever@whatever.com"type="html" charset="utf-8" timeout="120"> Recently others did an update to the certificates of the email server (smtp.mydomain.com). Now my application can not send emails anymore, although I changed nothing to my system and code. My emails from spool folder go to the Undelivr. The error message I get in the mail.log is"Error","scheduler-1","06/16/20","16:37:56",,"javax.mail.MessagingException: Could not convert socket to TLS; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path validation failed: java.security.cert.CertPathValidatorException: timestamp check failed" What's does that mea

Is anyone running ColdFusion 2016 on RHEL 8. Our admin would like to update from RHEL 7. The only system requirements I can find for CF on Adobe's site is two years old.

Hi,I am currently running CF 2018 update 2, Build Number:2018,0,02,313961. I would like to update it to CF 2018 update 9. Can I install CF 2018 update 9 directlly or do I need to update first to 3 then 4,5,6,7,8,9.Thanks. 

Hello, all, I've rarely used the 'result' attribute in a CFQUERY.  But I did some looking around, and on the support page for CFQUERY, looking at what is returned I see: resultName.ROWID: Oracle only. The ID of an inserted row. This is not the primary key of the row, although you can retrieve rows based on this ID. ... resultName.GENERATEDKEY: Supports all databases. The ID of an inserted row.  With ROWID, am I to understand that it returns an ID that is _not_ the auto generated key from the database (assuming that the primary key is default uuid/guid), but can be used to get the auto generated key? And with GENERATEDKEY, is this the auto generated key?  Or is it like ROWID? V/r, ^ _ ^

Hello, all, We had a lead developer, here, who used CFB to generate CFCs for the database tables of a project, and actually used them.  But there has been a change to the way part of this app is going to work, and it involves editing this Celtic-knot cluster to fix.  Basically we are switching from using an old ID to a new ID for authentication, processing, accessing, etc. I thought that I could just remove references in code to the old ID and add the new ID, but without even testing it, I suspect I'm going down the wrong path.  Any insight into how I can get this accomplished would be greatly appreciated. Basically, I don't know/understand how all of the {tablename}Dao, {tablename}Gateway, and others interact.  Please advise. V/r, ^ _ ^

I have enabled Apache support on ColdFusion 2018. I can render http://127.0.0.1:8750/CFIDE/administrator/index.cfm using the built in webserver, but when I try from Apache http://127.0.0.1/CFIDE/administrator/index.cfm I get an error that the page is not found on the server. I have /CFIDE/* = cfusion enabled in the uriworkermap.properties file. I also tried enabling a virtual host Alias in the  mod_jk_vhost.conf to point to the location of the administrator page. Neither works. How would I go about accessing the administrator page from Apache? Is this possible?

Hi, I am trying to export barcodes to an excel sheet using SpreadsheetAddRow.  Being that barcodes are strings of numbers, the SpreadsheetAddRow seems to automatically interpret the string as a number.. e.g., Barcode = 0194112066037In excel it gets returned as 1.94112E+11 (as datatype General) Using SpreadsheetFormatCell(objSheet,{dataformat=0},RowNumber,CellNumberIn excel it gets returned as 194112066037 (without the '0' preceding the string) (as datatype Number). Using SpreadsheetFormatCell(objSheet,{dataformat="text"},RowNumber,CellNumberIn excel it again gets returned as 1.94112E+11 (as datatype Text). It seems that Excel shouldn't alter any value in a datatype text field.  It's very strange. Especially considering we have not run into this issue when using SpreadsheetAddRows. ColdFusion Server Developer 2016,0,11,314546 <cfset strXLS = "C:\Example.xls"><cfset objSheet = SpreadsheetNew(" Export")&gt

HiWe are on CF11, upgrading to CF2018. Checking compatibility for CF2018Below code works in CF11 but not in CF2018 I get 2 alerts in CF11 one - Welcome to VB Script and another as Welcome to Javascript.but only 1 alert in CF2018 as Welcome to Javascript. Below is my .cfm page.... <script language="vbscript" type="text/vbscript">MsgBox("Welcome to VB Script")</script><script language="vbscript" type="text/javascript">alert("Welcome to Javascript")</script>

Hello, all, Just a quick question about ListMap.  According to the Adobe Help page, ListMap "Iterates over every entry of the list and calls the closure function to work on the item of the list." I'm curious, though, if break will break out of the iteration. If ListMap is just a shortcut to a loop, then break would break out of that loop.  But if ListMap is something else, then maybe break won't work? Just curious. V/r, ^ _ ^

Hi, in CF10 this code work perfectly but after switching to 2018 i have problems of elements not found any help plz.<cfform name="theGridForm"> <cfgrid name="theGrid" format="html" colheaderbold="yes" preservePageOnSort="true" bind="cfc:#request.stMapping.strCFC#.admin.cust_meter.getGET_CUST_METER_PER_PARAM(getBrand_name(),getModel_name(),getSerial(),getDN(),getLogger(),getCUST_DBID(),getCONTRACT_DBID(),getWORD_CONTAINS(),getWORD_WHERE(), getACTIVE(), getdate_deb(), getdate_fin(), getAREAID(), getTARIFFID(), getCUSTOMER_TYPEID(), getCONTRACT_GROUPID(), getDMAID(),getSTREET_NUM(),getDIRECT_TO_NET(),getSEPARATOR(),{cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})" bindOnLoad="no" sort="true" stripeRows="true" pagesize="10" >

Hi,The perl script runs fine from the command line but when I execute the same perl script using the coldfusion cfexecute it fails to run. It cannot find the methods/functions used in the perl script like SelectAllEditableRanges, Bookmarks, InsertAfter. The script fails whereever this functions are called in the perl script. How do I run the perl script using cfexecute. Thanks. 

I'm working with the AWS Java 2.0 SDK and I'm trying to implement an async multi part upload, but I'm running into some trouble getting things set up, specifically in creating a BiConsumer Interface. Docs: createMultipartUpload(CreateMultipartUploadRequest createMultipartUploadRequest)  To start this process I have to call a3AsyncInterface.createMultipartUpload() and so I create a CreateMultipartUploadRequest object and pass that object into my call: oCreateMultipartUploadRequest = createObject( 'java', 'software.amazon.awssdk.services.s3.model.CreateMultipartUploadRequest' ).builder() .bucket( ARGUMENTS.bucket ) .key( ARGUMENTS.key ) .contentType( ARGUMENTS.fileMimeType ) .build(); oCreateMultipartUploadResponse = s3AsyncInterface.createMultipartUpload( oCreateMultipartUploadRequest );  So this all works great so far. My call returns a response object of type CompletableFuture<CreateMultipartUploadResponse>, but here's whe

We got the SOAP WSDL File for PDF Assembling/Bookmark/Commenting and we are trying to consume the web service from SAP ABAP.Details:When calling the Invoke Method of the PDF Assembler, system is giving Conversion Error.The PDF Contents which are attached in the application are passed to the Invoke Method in XSTRING format. Please help on this, if anyone worked on calling the PDF Assembler web services from SAP.

When i output a google map online, my map markers from cfmaps only outputs a maximum of 10 or 11 markers of the 31 persons of whom is have addresses for. I then run the same code in MySQL it outputs all of the addresses with no issues.  I there anything I'm doing incorrectly? Thanks in advance for any assistance<!--- Below is the contents of my page: location2.cfm---><cfquery name="foicontact" datasource="master">select FOIID, type, status, squadlt, trim(concat(name.fname, ' ', name.xholy)) as brother, trim(concat(homestreetaddress,' ',homecity,' ',A_state,' ',homezipcode)) as home, homeaddress2 as Unit, photo as photoimg, cellFROM nameWhere homestreetaddress IS NOT NULLAND status = 'a'</cfquery><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><

My company is looking at ways to log and trace our apps which range from Coldfusion, react, and node js applications. We want to log when pages are spent up to actions the end-user performed to errors.My question what are some of the solutions that are a standard way across the board to handle application logging?

We have just upgraded the CF2018. When we installed the new build and are having an access issue.  Here is the error message below. Can someone shed a light on this? Many thanks. Message: The getArrClientReportButtonEnabled package method in the D:\Solutions\R_274_8_1-20200610145034.896\Web\Flexible\IpsPhase.cfc component cannotbe accessed from d:\Solutions\R_274_8_1-20200610145034.896\Web\Flexible\IpsPhase.cfm., Template: /Flexible/IpsPhase.cfm, Diagnostics:The getArrClientReportButtonEnabled package method in the D:\Solutions\R_274_8_1-20200610145034.896\Web\Flexible\IpsPhase.cfc component cannot be accessed from d:\Solutions\R_274_8_1-20200610145034.896\Web\Flexible\IpsPhase.cfm. <br>The error occurred on line 233.,Root Cause: coldfusion.runtime.TemplateProxy$InvalidPackageAccessException: The getArrClientReportButtonEnabled package method in theD:\Solutions\R_274_8_1-20200610145034.896\Web\Flexible\IpsPhase.cfc component cannot be accessed from d:\Solutions\R_274_8_

I see previous versions of the JDK posted at the Adobe link below, but I was wondering approximately how long it takes them to make the new version available? Adobe ColdFusion https://www.adobe.com/support/coldfusion/downloads.htmlOracle JDK 11.0.7 https://www.oracle.com/technetwork/java/javase/11-0-7-oracle-relnotes-5972662.htmlRelated security issues fixed https://www.oracle.com/security-alerts/cpuapr2020.html#AppendixJAVA