ColdFusion

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.

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" >