Questions

Hello Everyone Spanish ASCII codes are not inserting properly into the database. I'm using microsoft SQL server 2014.Spanish letters are changed automatically. For example Ñ changed into Á along with special character like ? or '. 

I have found 10 year old examples on the net showing the coordinates included in the returned query, but when I try it on my CF 2021 server, those coordinates are not there, not even referenced in the cfdump. Has this function changed over time?

Bonjour,Ce qui est classique, je dois vérifié si l'IBAN (ou tous autres) est correct.Existe-t-il des solutions en CF ?Sinon comment s'y prendre ?Merci par avance Hello,What is classic, I have to check if the IBAN (or any others) is correct.Are there solutions in CF?Otherwise how to go about it?thanks in advance

I created an Azure Container Instance and Coldfusion 2021 is running on it as a Docker image.The application creates multiple log files. I sent all these logs to Standard Output by the symlink.Now, I want to parse these logs file-wise in Azure Log Analytics Workspace. Can anyone help me? Thanks!

I am having an interesting problem.  Since installing CF2018 Update 14 I am no longer able to use the CFMail tags in my web pages.  It was working before the update without issue.  Since applying the update when the page is called, it acts as if it stops reading the page at the <cfmail> tag.  Nothing else loads after that point.  I just get a blank white page in the browser.Looking at chrome developer tools, the body of the page is blank. Example of my cfmail:<cfmail from="test_noreply@server.com" to="email_address@server.com" subject="test email message"> This is a test email message </cfmail>I get the following error in the server application log:"Error","ajp-nio-127.0.0.1-8018-exec-5","06/28/22","07:46:57","","org/bouncycastle/jce/provider/BouncyCastleProvider The specific sequence of files included or processed is: X:\<path>\page.cfm, line: 2 " I've tried the <cfmail> tag all on one line and get the same error but the

I want to add a database (Microsoft SQL) to the website I'm working on, using Cold Fusion Administrator (latest version).After entering all needed data, I got the issue:Connection verification failed for data source: dbKantine java.sql.SQLException: The sqlserver package is not installed. You can install the package through the CLI package manager (C:/Users/MYNAME/.CommandBox/server/C1EA019F5A81794693D0EA837C1622B4-PROJECTNAME/adobe-2021.0.2.328618/WEB-INF/cfusion/bin/cfpm.bat) by running the command : install sqlserver.I tried to execute the *.bat file mentioned, but nothing happened.I also tried install sqlserver in the CommandBox, but it says:Error getting ForgeBox entry [sqlserver] The entry slug sent is invalid or does not existEDIT:I got it installed using cfpm.sh and wrote there "install sqlserver".But now it tells me this inside of Cold Fusion Administrator:Connection verification failed for data source: MYDB java.sql.SQLNonTransientConnectionException: [Macromedia][

HiFirst post here and very new to CF/Java. I have inherited  a somewhat legacy application that is running on windows/IIS fine. However, I am trying to deploy the same application in a docker container ( linux ) and running into some strange slow down issues.The application runs fine though it seems that half the time ( or more than that ) the application doesnt seem to be able to cache all classes and compiles them everytime . For testing, I remove the container and deploy everything again. Sometimes the system runs fine and is reponsive after deployment. Once its responsive, I can use the application all day without any slowdowns. At other times ( more often than not ), when I deploy the container, it slows down from the first request and never picks up speed. It feels as if the classes are being created everytime or being loaded in mem with every click. The difference is on the order of 2 minutes to browse through all links in the application to up to 2 hours for the

We are getting below message in error log:"There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected." When ever we are trying to update any setting or create new scheduler/gateway, it is redirecting us to login page.Error While Updating any setting in CF Admin

Hello, all,I'm just playing around with CFDIV, seeing what is possible, and something is not working._any.cfm:<cfoutput>This server is: #cgi.server_name#</cfoutput>index.cfm:<cfdiv id="testCFDiv" bind="url:_any.cfm" bindOnLoad="true"></cfdiv>When I open index.cfm in a browser, I get a blank page.  Using F12, I can see:<div id="testCFDiv"></div><!--- empty - nothing --->Shouldn't the CFDIV be loading the contents of _any.cfm???V/r,^ _ ^

I have a default install of Coldfusion 2018 update 13 running without issues. After the update 14 is installed manually via the jre/bin/java.exe, both the admin page and the coldfusion site throw 500 errors. I tried increasing the debug info from the admin panel before beginning, but it still just shows 500. I also made sure my c++ runtime is up to date. I also tried rebuilding the connector to IIS, even though I should not have to as the one from update 13 should work. Nothing fixes the 500 error, though uninstalling update 14 restores functionality. Any other ideas how get this update to work, or where to look to find out more details about what is actually broken?

Help!I can't seem to figure out how to handle WSS (Websockets over SSL). I have a cert that has already been sent/received by verifier. I have a cert and an intermediate cert. I've been looking at documentation and from what I've gathered i need to add the certs to the "keystore". I issued a command like this ->>>  D:\CF11\jre\bin\keytool -import -v -alias myCert-cert -file myCert.cer -keystore D:\CF11\jre\lib\security\cacerts -storepass changeit <-- I see the cert is added. And if list the keystore i see the number of certs increased by one. I then enable the SSL WS, use default port (built in server.. not proxied), and point it to the keystore D:\CF11\jre\lib\security\cacerts and for pass i simply use the default changeit.... I've modified my cfcode to have the secure="true" attribute. So I think everything is setup correctly ....but...  when i goto the webpage the web socket will try to connect then simply not connect (Firebug says the connection was refused) (

I am starting the process of upgrading one of my clients' test server in preparation to upgrading their production server from CF2016 to CF2021 and am seeing some strange QoQ behaviour. I was able to reduce the code to the following: <!--- SQL Server backend create table qoq1 (id int,name varchar(10)) insert into qoq1 select 1,'One' union select 2,'Two' union select 3,'Three' create table qoq2 (appid int,name varchar(10)) insert into qoq2 select 1,'Uno' union select 2,'Dos' union select 3,'Tres' ---> <CFQuery Name="q1b" DataSource="myds"> select qoq1.id,qoq1.name from qoq1 order by qoq1.name </CFQuery> <CFQuery Name="q2b" DataSource="myds"> select qoq2.name as catname,qoq2.appid from qoq2 order by qoq2.name </CFQuery> <CFQuery Name="q3b" DBType="Query"> select q2b.catname,q1b.* from q1b,q2b where q1b.id=q2b.appid order by q2b.catname,q1b.name </CFQuery> <CFDump Var="#q3b#"> The above dump in CF2016 shows 4 columns (which

Is there any variable in coldfusion that stores user ip address?Please let me know.Thank you

I am getting this issue on Coldfusion 2021.JDK 12.0.2 is used.Azure MSSQL Server is used.Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]An SSL socket connection could not be established because JRE 1.4 or above is required. Can anyone help me?Thanks!  

Following the Stripe documentation, which uses curl, I have tried the code:<cfhttp method = "POST" url="https://api.stripe.com/v1/payment_methods/pm_1LCuutGKxC2502V8WNrkE3Ja" result = "result"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_51...."> <cfhttpparam type="FormField" name="customer" value = "cust_admin_1"> ..... </cfhttp> where pm_1LCuutGKxC2502V8WNrkE3Ja is the Payment Method id from the JSON response when the card payment method was set up.The above code gives the error: You cannot attach a PaymentMethod to a Customer during PaymentMethod creation. Please instead create the PaymentMethod and then attach it using the attachment method of the PaymentMethods API.Of course the PaymentMethod had already been created, and indeed if I change the ID slightly I get the message No such PaymentMethod: pm_1LCuutGKxC2502V8WNrkE3Ja22 as would be expected. Thanks in advance for any comments.

[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. My environment is CF16 with 2 servers connected through a public facing IP load balancer.  The SQL db is on a cluster. CF admin all datasource is pointed to an IP server. It has been working for quite a long time. Suddlenly last Thursday, we got a network issue. Network issue resolved. We are  kept getting this connection error. I rebooted 2 CF servers, telnet to DB server are ok. DBA stated he did the fell over to other node of the cluster. instead of bouncing the DB server.Are there anyone encounter this kind error and kindly guide me to solve this issue. 

I am attempting -- unsuccessfully -- to establish SSL connectivity to SQL Server 2019 from ColdFusion 2021 Enterprise running on Tomcat 9. Tomcat itself is configured with SSL and its own separate web server certificate. I have previously been able to connect ColdFusion Standard 2016 to the SQL instance from a different server, so I'm fairly sure the SQL instance is configured properly. The Java version for CF is 11.0.14 -- I have checked to make sure that Tomcat and CF are actually running this version of the JVM. I have added the root CA, the web server certificate, and the SQL Server cert to the Java keystore in cacerts for this Java instance. I have also added EncryptionMethod and other parameters to the Connection String in the datasource definition, and pointed it to the correct Java keystore with the correct password. This is what I get when I try to add the datasource:SSL socket connection could not be established because JRE 1.4 or above is required. I don't und

Hey there, I'm playing around with CF locally with a Reac Front End, for speed of testing I'm using the built in webserver to see whether it's work keeping legacy CF components for a REST API. I can get the GET and POST methods to work but am getting a CORS issue with DELETE. I've tried including the following inside my Rest service but still no luck. <cfheader name="Access-Control-Allow-Origin" value="*" /><cfheader name="Access-Control-Allow-Methods" value="GET,PUT,POST,DELETE" /><cfheader name="Access-Control-Allow-Headers" value="Content-Type" /> Any help would be much appreciated.Cheers

I am able to pass field values to Stripe's Customer object using the code   <cfhttp method = "POST" url="https://api.stripe.com/v1/customers"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_....."> <cfhttpparam type="FormField" name="id" value = "cust_admin_18"> <cfhttpparam type="FormField" name="address[country]" value = "US"> ........ </cfhttp>   However when I try similar code with other Stripe objects, for example Payment_Method, I get an error with the id field. So <cfhttp method = "POST" url="https://api.stripe.com/v1/payment_methods"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_....."> <cfhttpparam type="FormField" name="id" value = "pm_123"> <cfhttpparam type="FormField" name="type" value = "card"> <cfhttpparam type="FormField" name="card[number]" value = "4242424242424242">  </cfhttp> produces an error parameter_unknown - id   Changing "F

Hello - I am having difficulty installing the ajax package. The package I'm trying to install is ajax (2021.0.02.328618) and I've tried using CFAdmin and cfpm. Is there anyone that has run into a similar problem? I'm running CF2021 on Windows server 2016.  thanks

A part of a Google pay implementation we need to attach a certificate .PEM file and key to a CFHTTP request. It seems some envoronments like Node can do a HTTP POST and specifiy such files. Is this possible in CFML? Unless we do a CFHTTP POST with a specific .PEM file, the request is rejected. Help appreciated.

Is it possible to throw site wide error of each unique type only once? Using CF 2016 . The website application has on error exception handling mechanism used in Application.cfc. The site encounter ed a SQL injection attempt and numerous error sent like mail flood.Can we handle without using any black list table creation in such a way that the spam kind of mail throw only once in a day? Also, genuine error mails are not prevented.Any suggestion is appreciated.

I have an Azure Container Instance service and deployed the Docker service there. Now ColdFusion server is running on the Docker service. Now I want the ColdFusion log through the Docker and Container Instance.Currently, I mapped between Azure Container Instance and Log Analytics workspace. And I got the Container Instance log. But I can't see the Docker or ColdFusion log.Can anyone help me to get the ColdFusion log using the Azure Container Instance and Docker? Please give me the same example or any documentation.let me know if you want more information.

Is there an upgrade path from ColdFusion 11 to ColdFusion 2021 using an upgrade?

I'm totally stumped! Some users are having a problem with our site because CF can't seem to maintain the session. The users keep saying their browsers are set to accept cookies but CF, for some reason, can't read them. I am having a hard time diagnosing the problem because I can't recreate it. The website is accessed from two domains and the problem is only encountered when someone tries to place something in the shopping cart. The domains are: nottinghillnotes.com nottinghillnotes.co.uk One user was kind enough to spend some of his time helping me. Here's what we have so far... This particular user has Safari on a Mac (we've also received complaints from users with IE 6) He verified his browser is set to accept cookies and even sent me a screenshot... Screenshot 1 - Cookies in the Safari Browser I had the user browse to a test page that just dumps out the cookie structure using the cfdump tag. The request sent to the webserver included the proper cookies. Here is part of