Questions

How do you break out of the arrayEach function - stop execution?break acts like continueCode<cfscript> myArray = [ 1, 2, 3, 4, 5, 6, 7, 8, 9 ]; writeoutput("<h2>Loop</h2>"); for ( counter=1; counter<=arrayLen(myArray); counter++ ) { thisElement = myArray[counter]; if ( counter == 5 ) { continue; } if ( counter == 8 ) { break; } outString = counter & " : " & thisElement & "<br>"; writeOutput(outString); }; writeoutput("<h2>ArrayEach</h2>"); counter = 0; arrayEach( myArray , function( thisElement ){ counter += 1; if ( counter == 5 ) { continue; } if ( counter == 8 ) { break; } outString = counter & " : " & thisElement & "<br>"; writeOutput(outString); }); </cfscript> OutputLoop 1 : 1 2 : 2 3 : 3 4 : 4 6 : 6 7 : 7 ArrayEach 1 : 1 2 : 2 3 : 3 4 : 4 6 : 6 7 : 7 9 : 9 this should not be here Answer would be much apprecia

Is there a way that I can use two textboxes on a page to perform a math function and populate a third box? 

Hello, all, I just learned something interesting about FireFox and JavaScript, and I'm curious if other browsers do the same. I am working on a POC for adding to an existing project, later.  A form with five input type="text", and a textarea.  The inputs are all named 'cct_' where the _ represents a number, 0-4.  There are also two spans after each input, one to indicate success, the other to indicate fail. In JavaScript, I had manually created an array for the inputs:   var ccThese = [].slice.call(document.querySelectorAll('[name=ccThese]'); ccThese.forEach(function(ele,ind){ window['cct' + ind] = ele; }); //Creates an array, then creates a global variable that points to each element.   But I didn't do the same for the spans.  Didn't even think of it.  But, later in the code, I have something like:   window['cct' + i].classList.remove('malAddress'); window['mal' + i].style.visibility='hidden'; window[

Hi! My app. has many CFScripts in it and almost can't find anything written in javascript. I read about cfscript and it is not a client side scripting, just like cf tags it goes to the CF server for processing. So my question is why bother using cfscript? what is the advantages in using cfscript rather than cf tags? Maybe this application doesn't need to be coded in javascript but still in that case why the previous developer bother using cfscript instead of just use regular cftags. Is there many advantages in using cfscript and I just don't have enough knowledge to know these advabtages? For me, I found it easier to debug when using cftags because I can cfdump everything?

Hello: 1210921200000 is the number of milliseconds from Jan 1 1970 to a certain date/time. How do I convert that into a date/time using CF? I am sure somebody has faced this before. Thanks

Hi All - Our company has been trying to upgrade from CF11 to CF2018 Enterprise in a VM on a Windows Server 2012 R2 Standard server, and each time we get over 1100 non-fatal errors, and the final page of the installer has a checkbox that says "I understand that there were errors" rather than "Launch the configuration wizard in the default browser". We are making sure to shut down all ColdFusion services prior to the install as well as the IIS service. After this, we have not been able to open the Administator because the main screen shows a search box that won't submit. (So much for non-fatal errors.) The JQuery files were not writen or were not accessible, the creation of many new folders failed, etc. Has anyone experienced this? Any ideas? The server does not have access to the internet. Is that required?

Hello, all, I'm in the middle of troubleshooting an issue with server-side form validation, and am now curious. If a form contains <input type="file" name="foo" /> but no file is selected when the form is submit, does the form element "foo" exist?  I mean, I know that if no checkboxes are checked, that element doesn't exist on form submit.  Do file inputs do the same? V/r, ^ _ ^

Hi,We are in the process of deciding whether to move to Windows Server 2016 or 2019.  We are on Coldfusion 2016 and intend to stay with it for a while.Is CF 2016 supported on WIndows Server 2019, and if not, will it be?Thanks,ChrisChris Cosart | Senior Developer/AnalystCenter for Community College Student EngagementProgram in Higher Education LeadershipDepartment of Educational Leadership and PolicyCollege of EducationThe University of Texas at Austin

Not much hair left to pull out here...I have two CF sites, each with a MySQL database, on an ISP's server. I'm managing them on a local instance of Coldfusion 18 (on 64-bit Win10) via localhost. Sometime back, I got the first of these set up to access its datasource on the ISP with no problem. Using the same settings (I think), I can't get my second site to recognize its datasource. I placed the files on a subdomain and the datasource for my queries works fine there. It's just the access from localhost. I set up both datasources through Coldfusion Admin the same way, using ODBC Socket. Both datasources test OK there. Neither site's application.cfc affects the datasources. Is there some setting for the local sites that could produce a problem? Because I can't find anything amiss anywhere else.Thanks!  

Query Of Queries runtime error. Unsupported Cast Excpetion: Casting to type "NULL" is unsupported. I am getting this error when I try to query a query for a search tool that I developed. Problem is, it doesn't happen everytime. And, after dumping the main query, before I query it (when the error happens), there is nothing visible in the query that indicates a NULL casting. We have even filtered out special characters, thinking that might be the problem. I was wondering, what really causes this error, and is it something I am doing, or maybe a bug in CF7. I did not get this error until our company recently upgraded to CF7.

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=