ColdFusion

Good evening,For my recordings, I have always gone through CFForm but this leads to the opening of another page.Is there another way that does not go through a new page in order to be able to easily use the modal windowsthanks in advance

Update 7/15/2020: The Docker images for both these versions are up.   We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2018 release) Update 10 ColdFusion (2016 release) Update 16   In this update, we’ve fixed a few security bugs and some other bugs, which are mentioned in the tech notes.   Charlie Arehart has written an excellent blog on the importance of securing the CAR files. Read it here.   For more information, see the tech notes below: ColdFusion (2018 release) Update 10 ColdFusion (2016 release) Update 16   These updates fix security vulnerabilities that are mentioned in the security bulletin,  APSB20-43.   Please update your ColdFusion versions today. Let us know if you face any issues while installing the updates. Your feedback is essential to further enhancing the product.   Note: We’ve also updated the add-on installers.   We thank you for your conti

Hello! This might be a stupid question, but I'm a bit confused and can't find anything anywhere. I am building a new internal application in ColdFusion 2018.  A team member has said that it needs to be entirely RESTful.  I have built RESTful APIs to applications to expose portions of the application funtionality or data to outside tools/applications.  However, there will be no outside tools inegrating with this application.  If I am already using an MVC design, is there a good reason for the apparent extra work of making RESTful methods and access if everything is only accessible within the single application? Thank you for any input.

It is considered bad practice to allow other systems and users to connect to a database using the 'sa' login on SQL Server, so the best method would be to use Windows Authentication.... but how?I have gone to Datasources in CF9 administrator, added a new Datasource, put in the correct server name and database names. I have left the username and password blank as per the instructions on Adobe's CF documentation:http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe5.html#WS7EBC2C2B-C1AE-45cf-9374-F468BC63AF0A It simply will not connect, I get a notice along the lines of "login failed" for the database. If I put in 'SA' as the username and the password it will connect fine.How can I allow CF to accces my SQL Server database through just Windows Authentication? My CF9 and SQL Server installation are on the same machine on the same hard drive.I am running Windows Server 2008 R2 with SQL Server 2012 Enterprise.

I am migrating our db from Oracle (12c) to SQL Server (2019) but I am new to SQL Server, and I am on CF 2016. One stored procedure that runs just fine in Oracle is giving me trouble. It’s a SP developed by someone and I don’t have control over, but I know it basically generates a primary key from a table and returns an integer (only one number). In Oracle environment I would use:<cfstoredproc procedure="mySP" datasource="#dsn#"><cfprocparam cfsqltype="cf_sql_numeric" type="out" name=”next_pk”></cfstoredproc>Then I can access the value of #next_pk# and insert it into a table for a new record. In SQL Server environment, if I use the same code, it says “has too many arguments”. I saw someone said we can’t use type=”out” in SQL Server. So I use:<cfstoredproc procedure="mySP" datasource="#dsn#"><cfprocresult resultset="1" name="next_pk"></cfstoredproc>and try to output #next_pk#, it says next_pk is undefined. If I try to output #next_pk.UseKey#,

I am doing a cfinclude in my Application.cfc and the include sets variables in a cfscript. <cffunction name="OnRequestStart">        <cfinclude template="encryption.cfm"></cffunction> The varialbes that are set are known within the Application.cfc but are not available to the .cfm that made the call to the Application.cfc Is there a workaround? 

Generate a keystore pkcs12 Follow the steps below: Generate the keystore using JRE keytool. Navigate to the JRE/JDK\bin folder in your machine. Run the commands: keytool -genkeypair -keystore myKeystore.p12 -storetype PKCS12 -storepass changeit -alias mycert -keyalg RSA -keysize 2048 -validity 99999 keytool -exportcert -keystore myKeystore.p12 -storepass changeit -alias mycert -rfc -file mycert.pem Once the .p12 and .PEM files are generated, copy these to an appropriate location. Take the backup of server.xml in your instances. The file is located in ColdFusion\{instance}\runtime\conf. Once you back up the file, search for 8443 in server.xml. There is an entry, which is commented. <!--<Connector packetSize="65535" port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol" maxThreads="150" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" />--> The code above is commented in serve

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