ColdFusion

After I installed sqlserver module with > cfpm install sqlserver. My webpage is erroring out with :Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]This driver is locked for use with embedded applications.Now what?

I'm looking for a best practice and have not found one as yet. Within a CFC I have a function A that needs results from function B. In the past, I have done both call (cfset) and cfinvoke. For memory or speed performance is there a clearly best approach? (oversimplified example here) <cffunction name="functionB" access="private" output="no" returntype="numeric"> <cfargument name="myArg1" type="numeric" required="yes" > <cfargument name="myArg2" type="numeric" required="yes" > <cfset var retVal = myArg1 + myArg2> <cfreturn retVal> </cffunction> <cffunction name="functionA" access="public" output="no" returntype="void"> <!---better this way---> <cfset var sum1 = functionB(1,1)> <!---or no difference---> <cfinvoke method="functionB" returnvariable="sum2"> <cfinvokeargument name="myArg1" value="1"/> <cfinvokeargument name="myArg2" value="1"/> </cfinvoke>

Coldfusion Administrator CF 2018Problem Description:Up to Hotfix 4 OK but with Hotfix 5 or higher it is not possible to change 'Maximum number of simultaneous Template requests' in CF-Administrator/Request Tuning/Request Limits:By clicking to 'Submit changes' the info will show: 'Server has been updated successfully' but the page refreshes with the old value. Same time there is an error in the server.log:"Error","http-nio-8500-exec-1","01/27/20","18:14:27",,"Cannot find attribute [maxThreads] on resource [org.apache.tomcat.util.net.SocketProperties@50f4bdef]" System:With Linux or Windows and Developer Edition, there is no ErrorWindows with Standard Edition --> Error (Same error on two different Systems)CF10 was installed, CF 2018 Installed with Migration Wizard -----Server Product ColdFusion 2018Version 2018.0.05.315699Tomcat Version 9.0.21.0Edition StandardOperating System Windows Server 2012 R2OS Version 6.3Adobe Driver Version 5.1.4 (Build 0001)JVM DetailsJava Version 1

Hi all, I've inherited a CF application which required modification, including the addition of a column to the database.  The modification is working/displaying throughout the CFM pages as expected.  The application utilizes CFR reports and I'm now trying to modify one of them to add the data from the new column.  I've opened the report in CFRB, and dragged the new field onto the report but, the report errors out (binding error: unknown column name).  I'm guessing that CFRB is not being able to properly access the datasource. I've got CF 18 developer edition installed on my local workstation and the DSNs reside on a server elsewhere (all verify okay).  I've also installed CFRB on my local machine.  I haven't configured RDS since the CF server is local.  What am I missing? Thanks! Jeri

My company purchased the full version of ColdFusion 2016 a couple of years ago, and I though that ColdFusion Builder came with that.  Does it?  If so, how do we install it.  If not, is there a discount for ColdFusion builder since we purchased the full ColdFusion 2016 product?

Is there a way to add multiple text values to an exisiting PDF? I would need to read the value from the database and add these values to an exisiting PDF in certain locations and multiple lines. The key word is an exisiting PDF. Thank you for any help?Name______Address________City_____

I am downloading  attachments and trying to move the message(s) to a "downloaded" folder   when I use   <cfimap  action="CreateFolder"  folder="downloaded"  connection="gmailconnection"><cfimap action="MoveMail" connection = "gmailconnection" newfolder="downloaded" >  gives me the below error.  An exception occurred while performing action MoveMail in cfimap tag. The cause of this exception was: java.lang.IllegalStateException: This operation is not allowed on a closed folder.I am successfully downloading the attachment(s).  and I can mark the messages as being read.  I can delete the files   I just can't seem to "move" the files.Any help would be greatly appreciated,

I write a  ajax post which is looking data at cfc.But the under of button is not working so usefull.Do u have any idea for make onether button?<span class="input-group-addon"<a href="javascript://" onclick="vkn_kontrol();">VKN</span>

Hi guys, I have a problem regarding the coldfusion function and listing files from the server, we switched the application from cf 9 to the 2016 version and since then when I list files from the folder on the linux system, it returns the wrong encode.i i did this things and it did not help <cfprocessingdirective pageencoding="utf-8"><cfdirectory action="list" name="someDir" directory="directoryToFilder" sort="name ASC" ><cfdump var="#charsetEncode(charsetdecode(someDir.name,"ASCII"),"UTF-8")#">in linux changed .bashrcLANG=de_DE.UTF-8LANGUAGE=LC_CTYPE="de_DE.UTF-8"LC_NUMERIC="de_DE.UTF-8"LC_TIME="de_DE.UTF-8"LC_COLLATE="de_DE.UTF-8"LC_MONETARY="de_DE.UTF-8"LC_MESSAGES="de_DE.UTF-8"LC_PAPER="de_DE.UTF-8"LC_NAME="de_DE.UTF-8"LC_ADDRESS="de_DE.UTF-8"LC_TELEPHONE="de_DE.UTF-8"LC_MEASUREMENT="de_DE.UTF-8"LC_IDENTIFICATION="de_DE.UTF-8"LC_ALL=de_DE.UTF-8Thanks Guys for help  

Hi,I am currently running CF10 on an old Windows server.  We need to upgrade the server and I inquired through Adobe about a new CF license.  I wanted to know if we qualified for an upgrade (we don't as it needs to be one version ago) or a non-profit discount.This led into a lot of technical talk (which I am not qualified for) so I got them in tough with our server team.  It came down to how large our site is and how many cores our server had.  They proposed an annual cost of about $7,000. I don't understand this.  When I bought our CF10 license (a hundred years ago) I just bought a Standard license, installed it, and built the site.  It looks like a Standard license is $2,499.00 and an Enterprise (I don't believe I need this) is $9,499.00.  Those are one-time fees.Can't I just purchase a Standard license, transfer my files from one server to the other and move on?  It's a very small sand simple site.  Why is Adobe proposing a

I have an INSERT command in a CF script to add a record to a data table. There are four fields I am populating. Fields three and four are being populated with the same data. Here’s the code:        INSERT INTO tblPQMS_Requests          (          PQMSReq_By,          PQMSReq_Status,          PQMS_Proj,          ERP_PQMS_Proj          )        VALUES          (          'LibMgr',          '1',          '#htmlEditFormat(projectno)#',       &nb

I had newtek update my server from coldfusion 4 to coldfusion 11 server. Then gave me a test IP address of 67.199.50.218 so I could check out the site but I get the foolowing error.Any help will be greatly appreciated.Thankk yuPete Southworthmciol@microcaat.com"Security: The requested template has been denied access to D:/Inetpub/antstudio/customtags.The following is the internal exception message: access denied ("java.io.FilePermission" "D:/Inetpub/antstudio/customtags" "read") 

I have a CF2018 server on which the CF service won't reliably start, and when it does it comes up in "Developer". What is happening in at the following point, at "Starting License"?"Information","main","10/30/20","02:25:24","","Starting license...""Information","main","10/30/20","02:25:26","","Enterprise Edition enabled"These lines are from my production server.  The other server, which is an exact copy (via AWS AMI image) the process begins to timeout, giving a series of lines like:"Information","main","10/28/20","18:19:26","","Starting license...""Information","main","10/28/20","18:19:47","","Connection timed out: connect""Information","main","10/28/20","18:20:08","","Connection timed out: connect""Information","main","10/28/20","18:20:29","","Connection timed out: connect""Information","main","10/28/20","18:20:50","","Connection timed out: connect""Information","main","10/28/20","18:21:11","","Connection timed out: connect".... From the Windows Services Console,

I need to generate an invoice pdf. This invoice can have 1 to hundreds of items and each item description is different. One item can take up 1 line and another could be 9 lines. So, using a mod value based on the number of items doesn't solve the pagebreak issue. If just say show 5 records per page, these 5 records can barely take up space on a page or can take  up more than 1 page.  I'm using CF 2018. I use cfdocument that generate a pdf from HTML/CSS formatted page. Right now counting characters item description gets me closer to what I need it's still doesn't work 100% of the time. This is my code estimate the number of lines used by item description:<cfset ProductDescriptionNumberOfLines = ceiling(Evaluate(len(Description)/33)) >then pagebreak is based on that.  Here's an old post seems to be asking for the same solution:https://community.adobe.com/t5/coldfusion/pdf-creation-page-break-issue-on-table/m-p/4431494?page=1#M1

We have a legacy application with a sprawling directory of files. It is our suspicion that a large number of them were created for purposes long since forgotten. Because of the number of files, it would take a lot of time and effort to go through the directories and identify those which are no longer in use. I often use Search >> File to search file names and see if there are any files containing a file name string, but I would like to delete the extraneous files without doing this for each file in the application. Is there an easy way to identify all of the files which are not linked to other files in the application?

Hi Team,We have installed latest ColdFusion Patch (update 16) in dev server.Patch 16 successfully installed without any issues, but we are unable to access the application - redirects to 503 service unavailable page.Could you plese help us to resolve this issue at the earliest.Regards,Bala.P

Hi, we recently had a security scan on one of our apps and we were dinged with "HTTP Response Splitting" issue. It occured on my .CFC pages. Below is what the testers performed on my CFC and the results.  I am running CF2018 Enterprise 2018.0.09.318650. I was curious if anyone had any suggestions on how to remediate this. My first step was to make sure "Enable Global Script Protection" was checked in the cfadmin, which it is. From there I believe the neo-security.xml file can be updated to help prevent CRLF injection, not sure what that would look like. Quite honestly I am not sure if that is the best or proper method. I get a little leary messing with some of the CF underlying files. Anyone have any other or better ideas? Thanks

I have create scheduled task in Coldfusion to run daily. Basically this task executes 1 URL every day which sends reminder emails for one of or web-app Now problem with this task1. It does not run automatically2. When I click on 'Run' in CF-Admin for this task - it says - This scheduled task was completed successfully. But actually task does nor run (I can confirm as no reminder emails are received for one of our web-app)3. When that URL which is scheduled in scheduled task - is run manually in browsver - it works and reminder emails are received4. One more thing I observed is - I scheduled task to run say at 06:30 AM but when I open the task - the time - it shows is something like this - {ts '1899-12-30 06:30:00'}

Hi,We are whitelisting IP address ranges to access our website in CF11 for my client. Every time the user hits the site my code will pull the IP address using HTTP.REMOTE_ADDR. Once the user hits our site , there are some real IP address coming in, which does not belongs to my or my clients network. While I was checking those IP it belongs to some ISP providers. So this restricts my users to access the site as it is not included in our whitelisting. Our CF server is not a proxy or load balancer. Even I tried to check if it is re-routing using CGI.HTTP_X_Forwarded_For. But it was not. Please help me to know if incoming new real  IP address can be controlled in our web server or in CF server? Or is there a way for the client to control these incoming IP address? Thanks,Jaya

Hello All- I've been using the CFform/CFtextarea richtext editor for years.  And it's been going well.I have just moved my applications to a new server.  In this move, I went up to CF2018, and the latest Windows/IIS versions.  (Server 2019, IIS v. 10) Just about everything is working perfectly, except that CKeditor will no longer display.  I just get a large blank space about the size that the editor window would be.  I have made a super simple page that should just show the textarea with richtext, and that page also does the same thing- big space for the editor, that is completely empty.  (Important, the textarea does not show up, there are no outlines, nothing.  Just a blank space on the page) On the pages where the editor should display, all of the proper .js pages are linked.  I can view the source, and follow those links and all go to valid files.   Could this be some sort of firewall or security issue?&nbs

I am trying to use Twilio to get rid of our fax machine (why do they still exist?!?). I've got inbound fax working but not outbound. They have examples for several languages here but no CF.  I tried using their CURL example and converting it to CF but can't get it to work.CURL:curl -X POST https://fax.twilio.com/v1/Faxes \ --data-urlencode "From=+15017122661" \ --data-urlencode "To=+15555555555" \ --data-urlencode "MediaUrl=https://example.com" \ -u ACXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX:your_auth_token CF: <cfhttp method = "post" result="result" url = "https://fax.twilio.com/v1/Faxes" username = "#session.TwilioAccountSID#" password = "#Session.TwilioAuthToken#"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded"> <cfhttpparam type = "body" encoded="no" value = " ""to=+15083930000"", ""from=+15086580000"", ""mediaUrl=http://someurl.me/faxtest.pdf"" "> </cfhttp> <cfdump var="#result#"> I get t

Hi, Are there plans to update CF 2016 to address Tomcat vulnerabilities? Our customer has run Nessus scans on the server running our ColdFusion instance, and it's identified several Tomcat vulnerabilities, which are causing some concerns with the customer. CF 2016 with update 16 is currently using Tomcat 8.5.42. According to the Nessus scans, Tomcat should be upgraded to 8.5.58. Thanks!-Doug

Hello,I want to  check tax number at our coldfusion sytem of crm-erp.For example we are adding a company of our crm but we dont know that its tax number true or false.So ı tried  make it like this code but ıts not work.Can u help me please?<cfscript>wsURL = ' http://185.198.197.162/vknsorgulama/getall/dogrulama?vkn=18644905568&durum=2';Ad= 'GÜNGÖR',Soyad= 'YILMAZ',BabaAdi= 'MEMET',VergiDairesiAdi= 'KALEKAPI',VergiDairesiKodu= '007252',VKN= '9690365396',Unvan= null,</cfscript><cfxml variable="requestXML"><cfoutput><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://www.w3.org/2001/XMLSchema-instance"><soap:Header/><soap:Body><ws:VKN><ws:VKN>#VKN#</ws:VKN><!--Optional:--><ws:Ad>#Ad#</ws:Ad><!--Optional:--><ws:Soyad>#Soyad#</ws:Soyad><ws:VergiDairesiAdi>#VergiDairesiAdi#</ws:VergiDairesiAdi></ws:VKN></soap:Body></s

How Hibachi Framework help in Cold Fusion development and Is there any link to get some details about Hibachi frame work.

Hello,   CFPDF apparently removes all adobe comments, post-it, highlighting when merging for the second time. For example merge "merge1.pdf" with another file. Then everything is ok. Merge again the result with "merge1.pdf" and you'll see that all adobe comments, post-it, highlighting on the first time disappear, and that they are only visible on the newly add file.   Is this a BUG in CF 2018? Please help.   Kind regards, Didier