ColdFusion

Hi,I am trying to create a Data Source for a Azure SQL database.  I am able to connect when I use the administrator username/password of the Azure SQL database.  But, I am told that it is not the most secure way to do things.  So, may be db_owner is good enough for this Data Source Connection.  I created a new login to Azure SQL database, create a new user using this login to the database and give db_owner permission to this new login.  From Management Studio, I can login with this new login and password.  However, when I set it up like this in the Data Source in ColdFusion 2016 Administrator, I got an error,  "The root cause was that : java.sql.SQLNonTransientCoonnectionExcept: [Macromedia][SQL Server JDBC Driver][SQL Server] Cannot open database "......" requested by the login.  The login failed;" If I were to use the administrator username/password, the connection will be OK.What am I missing? What is the "minimum permission" needed

Hi, Would anyone know why datasources created using setMSSQL aren't showing in CF Admin Datasource screen? They show when I call getdatasources() in a script but not in Coldfusion Administrator. Thanks

I have seen a few older posts that have presented this same issue, but there was no resolution in the thread.  I have posted on those threads asking if they found a solution, however thought I would present the issue myself and hopefully someone has a fix/workaround.CF10, W2008R2, IIS 7.5. Using a group with NTFS permissions and trying to limit the access to the pages.  Anyone can view the page if putting in a username and password in the Windows security popup, click ok and immediately prompted again, click cancel and you can see the page contents.  Tested with an html page and html page is blocked properly.  It is my understanding that IIS passes the control to cf, cf diplays the cfm page.  Since this is IIS 7.5, the checkbox for check if file exists that was working in IIS6 isn't there any longer, it is now items under Handler Mappings.  I saw in one thread dscussion about editing a wildcard mapping, but it was vague, and didn't have the settings I nee

hello community! I am creating a report with the <cfreport> tag, It sent a query by parameter. The problem occurs when any of the query data has some special character. For example: BİEM İLAÇ SAN. VE TİC. ACE. This is the result : B?EM ?LAÇ SAN. VE T?C. ACE.  How can I make the result correct?

Hi,I'm able to use CFcontent and CFheader tags etc. to generate a Word doc with dynamic data on the fly and such Word doc has several pages.  An issue is the last page has double headers and footers.  The following is the process:1) <cfsavecontent      variable = "WDcontent">2) Use Microsoft XML and Word style guide<html xmlns:o="urn:schemas-microsoft-com:office:office"      xmlns:w="urn:schemas-microsoft-com:office:word"       xmlns="http://www.w3.org/TR/REC-html40"> <head><style>p.MsoHeader, li.MsoHeader, div.MsoHeader    {margin:0in;    margin-bottom:.0001pt;    mso-pagination:widow-orphan;    tab-stops:center 3.0in right 6.0in;}p.MsoFooter, li.MsoFooter, div.MsoFooter    {margin:0in;     margin-bottom:.0001pt;     mso-pagination:widow-orphan;    

I have installed ColdFusion builder (CFBuilder) (v3.2.1) as Eclipse (v4.17) plugin and I see that the Quick Diff functionality does not work with CFML Multi Page Editor.I am using the Code Assist Dictionary Version as ColdFusion 2018.I am not sure if this a bug in the CFBuilder or I am missing something here?

Hi, I'm really hoping someone can help me.  Since recent CF updates, then SQL Server updates, both within a week, connection to db is broken and I can't create the datasource in CF Admin anymore.  I've reinstalled CF and SQL server mulitple times, but that didn't help. In SQL server I:  checked ports: All 1433, All TCP/IP. All set to 127.0.0.1I've tried mixed mode authentication and Windows.  Was using Windows authentication before and it worked fine. So, leaving it on Windows Authentication.  I checked firewall. I ran queries in SQL Server to see if I am the user of the db, I am. I've done more things, just can't remember them all.  A troubleshooting guide would be awesome.  But I don't think such a thing exists for ColdFusion. Here's the error in CF Admin I'm getting:Thanks in Advance...!  Connection verification failed for data source: Organizations2java.sql.SQLNonTransientConnectionException: [Macromedia][SQ

Hello    I am trying to hash a password with bcrypt algorithm (try to match password with an off the shell software), but I keep getting error, it works for algorithms "SHA-1", "SHA-256" etc...<cfset hashpw = #hash(password_from_form, "SHA-1")#>, <cfset hashpw = #hash(password_from_form, "SHA-256")#>   but  <cfset hashpw = #hash(password_from_form, "BCrypt")> don't work,  got error : The BCrypt is not supported by the security Provider you have chosen.   Is there no bcrypt algorithm in coldfusion hash function ?   Have been working on it over a week but without luck.   btw, I am using dreamweaver 8.    thank you so much in advance.

https://www.linkedin.com/pulse/three-tiered-architecture-api-service-coldfusion-don-chunshen-li/

Hi,I have some big charts which I want to output as png format. ( I need the png to send it afterwords to pdf output, otherwise I would use html format)In ColdFusion 11 it is running well, but in Cf2018 I get the following error:Encountered code generation error while compiling script: generated bytecode for method exceeds 64K limit. (<cmd>#1) Is there a way to increase the limit?Or is there another solution?Thanks for help in advance!Claudia

Please find below snippet , we have to convert to Coldfusion tags ,any one help me. <script type="text/javascript">var epochTime = "1605070736";var Digest = computeDigest();function computeDigest(){var hmac = Crypto.HMAC(Crypto.SHA256, epochTime, "1308302020102915214099263166", { asBytes: true });var base64String = Crypto.util.bytesToBase64(Crypto.HMAC(Crypto.SHA256, epochTime, "AKI1308302020102915214099263166", { asBytes: true }));return base64String;}</script>

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