ColdFusion

Hi,CF2016 does not list Windows 2016 in it's support matrix. Will CF2016 be supported on Windows 2016?I note when I try install CF2016 on Windows 2016 it fails:where Details button offers:Flexeraayd$aaa: Windows DLL failed to load  at Flexeraayd.af(Unknown Source)  at Flexeraayd.aa(Unknown Source)  at com.zerog.ia.installer.LifeCycleManager.init(Unknown Source)  at com.zerog.ia.installer.LifeCycleManager.executeApplication(Unknown Source)  at com.zerog.ia.installer.Main.main(Unknown Source)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at com.zerog.lax.LAX.launch(Unknown Source)  at com.zerog.lax.LAX.main(Unknown Source)Kind Regards, Carl.

Hello communityI have been researching routes in ColdFusion and I want to know if there is any function that returns the root node of the directory.Example: C:\mydirectory\myotherdirectory  output:   C:\          Example: D:\mydirectory\myotherdirectory  output:   D:\          

I have a query that is going to return multiple of the same number (order numbers with add-ons).  How can I query the db and only output 1 of the those duplicate numbers? 

Hi,I am trying to upload a file using cffile tag. It is working fine when I upload the file small in size but, when I try to upload the file like size 50 MB I am getting error - HTTP Error 413.1 - Request Entity Too Large. I increased the size in the IIS for system.webServer/serverRuntime@uploadReadAheadSize but still getting below error: HTTP Error 413.1 - Request Entity Too LargeThe page was not displayed because the request entity is too large. Most likely causes:•The Web server is refusing to service the request because the request entity is too large.•The Web server cannot service the request because it is trying to negotiate a client certificate but the request entity is too large.•The request URL or the physical mapping to the URL (i.e., the physical file system path to the URL's content) is too long. Things you can try:•Verify that the request is valid.•If using client certificates, try: ◦Increasing system.webServer/serverRuntime@uploadReadAheadSize◦Configur

HiI'm on the road trying to configure Dreamweaver CC for a CF10 project on my laptop.Back in my office on my server i have DWCC configured using the CF10 extensions and I remember that I used an extensions file with the '.zxp' suffix; for the life of me I can't find that file on the web anywhere. (The .mxp extension simply won't run in the CC extension manager).Anyone know where it is?Thanks in advance, and happy holidays.Rich

We just upgraded to ColdFusion 2018. When we go to create a CAR archive, we get the following error and the CAR file is not create. "Error","","06/24/20","09:09:44",,"The metrics service is not available." If we deselect All in the server settings , we are able to create CAR. Any ideas what is causing this error? Thanks, Mark

as above. at the moment, I'm using the Jsoup Java library. I'm just trying to see if there's anything written in CF out there. Thanks!

I am getting this message when trying to add a mySQL (don't ask) database in CF Admin. Connection verification failed for data source: shownets java.sql.SQLException: No suitable driver available for shownets, please check the driver setting in resources file, error: com.mysql.jdbc.Driver The root cause was that: java.sql.SQLException: No suitable driver available for shownets, please check the driver setting in resources file, error: com.mysql.jdbc.Driver I've tried all kinds of instructions from posts and nothing seems to werk.  This is on my 32 bit platform. Tryng to get all the bugs out before setting up 64 bit version. Tnx a

Greetings, I just discovered based on incomplete recording in PROD database that CFTRANSACTION tag is not working anymore. Not sure if that specific to our environment or global issue.  Don't know if CF upgade or MS SQL upgrade caused that.. I know that it was working in CF11 environment, we have switched to CF18 about a year and half ago.  My environment:ColdFusion 2018 Version 2018.0.09.318650Edition- developer(but it doesn't work in enteprize also)Microsoft SQL Server EnterprisePlatform NTx64Version 13.0.5081.1 Example of simple test code below: <cftransaction  action="begin" ><cfquery name="Test1" datasource="XXX">INSERT INTO TrTest1 (TestString) VALUES('Recording 1')</cfquery><cfquery name="Test2" datasource="XXX">INSERT INTO TrTest2 (TestString) VALUES('Recording 2')</cfquery> <cftransaction action="rollback" /> Rollback is not working, records are inserted Can anybody verfy that or point i

Hello,I've searched net and Adobe forums before creating the thread. We have webserver using ColdFusion 10 and IIS 7.5, we are trying to retore our ColdFusion website on it. We are getting following errors:Error 101 (net::ERR_CONNECTION_RESET): The connection was reset.on some of the pages. The website is not live now so in order to access it you should modify your hosts file using the line : 198.61.145.21 6figurejobs.com www.6figurejobs.com .The errror will occur when you try to go to any of the companies in Featured compamies section. example:http://6figurejobs.com/company/Deloittehttp://6figurejobs.com/company/Rain-Bird-Corporationetc.More problem pages:http://6figurejobs.com/Career-News/Information-Technology/How-women-can-make-an-impact-in-the-IT-industry-$100001345-438039515.htmlhttp://6figurejobs.com/Career-News/Healthcare/Healthcare-adds-jobs-in-August-$100001332-438039511.htmletc.I assume this is ColdFusion/IIS settings thread? Could someone assist us with the errors? I would

Greetings everybody,we are currently running a Windows Server 2016 server with IIS. We have installed ColdFusion 2018 and successfully run one IIS website (let's call it "does.work.com") connected to the default "cfusion" instance.The server has one IP.Now we added a second instance (let's call it "dnw") via the Enterprise Manager in the CF administrator. Afterwards we added a second website to IIS. Let's call this website does-not.work.com. Since we only have one IP we're using two different host names and checked "Require Server Name Indication" for both websites. does-not.work.com outputs HTML correctly.After checking this we ran the Web Server Configuration Tool to connect the "does-not.work.com" IIS website to the second CF instance "dnw".However (also after re-booting the server, re-starting IIS, re-starting the CF Application servers, ...) we receive the following error when calling any ColdFusion resources on does-not.work.com:At the beginning we looked at missing permissi

HiI 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="...."to="....."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 about certificates in my server

if I want to us a certain number of places in an order number how would I do so? it is comprised of the date and 4 more places which is the cordcount of the date entered plus 1. I have this working but not with the extra 0's in front of the second part of the order number. So today would start with 061720202 which is the second order of the day. I want 06172020002

OK.  Why isn't this working?  I have ben out of CF since about 2008. SELECT *FROM PURCHASEORDERTABLEWHERE shipdate IS '#dateformat(Now(), "MM/DD/YYYY")#' AND Company IS CP Having an issue with the AND statement.

We have migrated CF11 to CF2018, however the unit tests are no longer working anymore. The error message is shown below. I am wondering if anyone else has the similiar issue.  The value returned from the getTests function is not of type array.If the component name is specified as a return type, it is possible that either a definition file for the component cannot be found or is not accessible. The error occurred in D:/Solutions/frst/UnitTests/net/sourceforge/cfunit/framework/TestSuite.cfc: line 133Called from D:/Solutions/frst/UnitTests/net/sourceforge/cfunit/framework/TestSuite.cfc: line 203Called from D:/Solutions/frst/UnitTests/net/sourceforge/cfunit/framework/TestSuite.cfc: line 181Called from D:/Solutions/frst/UnitTests/net/sourceforge/cfunit/framework/TestSuite.cfc: line 102Called from D:/Solutions/frst/UnitTests/net/sourceforge/cfunit/framework/tester.cfm: line 120131 : <cffunction name="addTest" access="public" returntype="void" hint=

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.