ColdFusion

I will preface this as I do most posts, I am not a developer / programmer.  We have a CF10 server for our department intranet.We need to be able to notify a small group of people (less than 100) at once, and thought it would be best to use text messaging.I tried searching for examples of sending text messages using CF, I found a great article from Ben Nadel from 2007 but that was using mail to forward to the text message service.  I was hoping to find an example of testing that I could modify to suit us.Is anyone aware of a sample text page I could modify?Thanks

Does the ColdFusion 2018 installer now available contain all the latest hotfixes? I downloaded the installer a few months ago, and it was a very old version with no hotfixes installed. Installing hotfixes caused the server to become corrupted and I had to reinstall the original. This happened on two different machines. Tom Muck

Hello, We use Adobe Campaign Classic and import audiences from Adobe Audience Manager which we combine with data to send emails.  There has been a use case to target people from different Audience Manager lists with different copy within the email but I can't seem to figure out how to personalize from the event you are in a list from Adobe Audience Manager from within the email in Adobe Campaign. Does anyone have any use cases or tips to get this to work?  Considering the audiences are coming in fine it should be easy but I can't seem to define whether they are in an Adobe Audience Manager from within the email.  Funny enough I can't seem to find specific lists in generic query editor either from within the data but can choose a list fine from within a workflow.  Any tips appreciated.

I have an .htaccess file in a /reports/ folder with the following rule:RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.cfm?path=$1 [L,QSA]There is an index.cfm in the /reports/ folder that loads a list of all manufacturers, if one is not specified in ?path=The rewrite is working on my dev server, and my staging server, but on my production server I get an error from Tomcat:HTTP Status 403 – Forbidden Type Status Report Description The server understood the request but refuses to authorize it. Apache Tomcat/9.0.21I'm on CentOS 7 with Apache 2.4.The .htaccess file is part of the source code.I have another site on the server that uses a RewriteRule in the vhost.conf file and that works fine in dev, staging and production.If I change the RewriteRule to this, it redirects fine. RewriteRule ^(.*)$ https://google.co.uk [L,QSA] If I visit the page directly (/reports/?path=BMW/) the page loads fine.The only thing I've been able to

Hello,I am stuck with a very unique but confusing issue. The charts toolip is not working as expected in modal dialog box. The tooltip is apearing under it rather than on top of it. The same is working fine when directly called in the web page. Direct Call in Page Changing the "position" in json stye hasn't workedAny help will be much approciated.

I have always managed my own CF servers, but over the past couple of years we have moved from CF to WP (not my choice) and we now only have our project management app that I created running on the servers. We would like to move off these servers as there is a not going on (network/hardware) wise that does not justify the expense or time. It's a very simple app running on CF9, and I am looking for a company that hosts CF apps, very similar to what a managed WordPress hosting company would provide. I don't need access to the server or configuration, just the ability to host the site and database and have FTP access to the root dir for updates and changes. Any recommendations would be appreciated.

Hi, I have a problem with cfquery tag inside cfclient tag for Coldfusion 2018.Cfquery is working outside cfclient tag...but inside cfclient is not workingthis code is not working:<cfclient><cfquery name="q1" datasource = "storebooksdmx">select * from collection</cfquery><cfoutput>#serializeJSON(q1)#</cfoutput></cfclient> but this code is working ok: <cfquery name="q1" datasource = "storebooksdmx">select * from collection</cfquery><cfoutput>#serializeJSON(q1)#</cfoutput> Any help please?Thanks!

I need to find information about using ColdFusion as a client for an OData 4 REST service. Is this possible? Is there anyone who has implemented this who could give me direction or point me to some sites or documentation? 

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.