ColdFusion

I am trying to connection a database instance which is gcp , i have the correct credentials but I am getting error on CF admin dsn , I can connect this db instance using sqlserver studio using the login credentials(ip, db username , db password) but not able to connect it from cf admin which is also in gcp. Connection verification failed for data source: testDBjava.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.

Hi, Is it possible to disable some checkboxes in a cfgrid depending on some values and keeping some enabled? If yes, does anyone have an example pls? Thanks and regards, Yogesh Mahadnac

Hi, we are running a Coldfusion server ver. 10,0,23,302580 which is connected to a MS SQL server ver. SQL 2017 And users getting that pages are sporadic not loading with error and we see in the log the following message:  ajp-bio-8012-exec-304","02/18/21","12:20:23","appControl","Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Named Pipes Provider: Could not open a connection to SQL Server [53]." and it can be to any page using a SQL connection. The workaround for the users are to Refresh the page a few times and then they are able to load the page. We do not use Named Pipes on our SQL server.  We have specified the connection string to be: Server=tcp:dbs-**.***.se;Database=***; to force coldfusion not to use Named Pipes, but for some reason Coldfusion still wants to connect using Named Pipes, how can we disable this? thanks for any help or tips best regardsMartin

I created a simple LiveCycle PDF that has 1 image and 3 textfields. Using the ColdFusion code below, I was able to pass data from ColdFusion into the form. However, I can't figure out how to dynamically populate the image. When I run the code, the image is always empty.Does anyone know how to do this? All of my image paths are stored in a database and need to be dynamic.ColdFusion Code---------------------------------------------------------------------<cfpdfform source="c:\webs\testpdf.pdf" destination="c:\webs\result.pdf" action="populate" overwrite="true">     <cfpdfsubform name="form1">         <cfpdfformparam name="img1" value="C:\webs\jellyfish.jpg"/>        <cfpdfformparam name="txt1" value="Swatch 1"/>        <cfpdfformparam name="txt2" value="Orange"/>        <cfpdfformparam name="txt3" value

I am wondering if anyone has any ideas to help me troubleshoot a mail issue with ColdFusion 2016:The server is sending and receiving mail via Google Workspace Gmail. It has been working fine for at least a year, and there haven't been any changes lately. But suddenly, maybe 50% of the time, there is a connection error trying to send or receive mail. I can't seem to figure out what's wrong. This is what the errors look like in the ColdFusion Out logs:Jun 14, 2023 14:30:12 PM Error [ajp-nio-127.0.0.1-8016-exec-6] - com.sun.mail.util.MailConnectException: Couldn't connect to host, port: smtp-relay.gmail.com, 587; timeout 120000; nested exception is: java.net.ConnectException: Connection refused: connectJun 14, 2023 14:30:12 PM Error [ajp-nio-127.0.0.1-8016-exec-6] - A problem occurred when attempting to deliver mail. This exception was caused by: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: smtp-relay.gmail.com, 587; timeout 120000; nested exception is... A

Hi, I am in the process migrating CF 2018 to CF 2023, one issue I notice is in 2018 the PDF created is same as the html regarding hyper link, for example, this html: <a href="/temp/getfile.cfm"> but with CF 2023, the PDF add the context path to the above link, so when user click the link in PDF, it actually go to:http://myserver.com/myapp/temp/getfile.cfmCF 2018: http://myserver.com/temp/getfile.cfmIs it a way to configure CF 2023 not to add the context path "myapp" in PDF ?this is using cfdocument tag.Thanks.

Howdy,We're having issues with our Coldfusion 2021 install and decided to try installing SeeFusion 5.2 to wrap the datasources and get more query info. Part of the instructions say to copy adobe_sqlserverdriver-6.0.jarto<CFROOT>/runtime/libHowever, when we try to startup, we get:WARNING: Failed to scan [file:/C:/ColdFusion2021/cfusion/runtime/lib/adobe_sqlserverdriver-6.0.jar] from classloader hierarchyjava.io.IOException: invalid manifest formatI tried running bnd to look at the jar file but it did'nt complain about anything.Any udeas?Is there an update of the file available?Thanks for any help you can provide.

Hi Everyone, I have created a scheduled job that deletes the data from db, when i access the file through browse it runs fine, but when i gave the url in schdule task in CFadmin it does not run, it shows that schedule task ran successfully but it does not run. Code in my cfm file: FormSubmit.cfm<cffunction name="deleteFileFromDB" returnformat="plain"access="remote"><cfargument name="fileId" type="string" required="yes" />        <!--- <cfoutput>Inside Model 2</cfoutput> --->   <cfset myDataSource = "sds_dev" />        <!---  <cfset myDataSource = application.datasource />--->        <cftry><cfquery name="deleteFileDetails" datasource="#myDataSource#">            DELETE            from             uploadFileTest            &nb

I have scheduled tasks that trigger email every day at the same time. The task runs, but the user never receives the email, and the undelivered mail folder is also empty. The task page can be accessed without logging in.When  I restart my ColdFusion services, the user receives the email.Can you guide me to resolve this issue?Using Coldfusion 2021 Update 6

I am creating a PDF document with set of questions answerable by multiple choice.Example:For which of the following disciplines is Nobel Prize awarded?A. Physics and ChemistryB. Physiology or MedicineC. Literature, Peace and EconomicsD. All of the aboveIn this example, the correct answer is "D - All of the above”Here is what I would like to happen:How can I check if the answer selected is correct?I also plan to include a "Next" control button that when click, it goes to the next question and cannot go back to the previous question to change their answer.I want the result (Correct or Wrong) of each question to be display only after the last question has been answer.        Example:        Question 1 - Correct        Question 2 - Correct        Question 3 - Wrong        Question 4 - Correct ...   d. 

Hello,We are having some issues sharing sessions between Redis and CF2021 container. Is there any trouble shooting guide? or anyone has any suggestions?Regards

Admin:   Please delete this question. The problem occurred because I accidentally deleted a few lines of code.

We have moved from old sever to new server using Coldfusion 2016 version. We have below queries regarding this migraton. 1.       Using CFlogin we are validating the current user logged in application or not with help of Isuserloggedin() function.2.       The IsUserloggedin() is working before (cflocation)redirection, once redirected(cflocation) to another page it’s not working.3.       IsUserroles(),GetUserroles() are also not working after redirection(cflocation).

Hi Everyone,Since i did not find any solution to implement progress in FTP upload via coldfusion, I was trying to use JAVA objects in coldfusion to do that, files are geetting uploaded but i need to override CopyStreamAdapter method in coldfusion to see the bytes transferred. Here is the sample code that i am trying. Please let me know what needs to be done.<cfoutput><form action="" method="post" enctype="multipart/form-data" class="upload-form"><input type="file" name="fileToUpload" accept="*"><br><input type="submit" value="Upload File" class="submit-button"></form></cfoutput><cfscript>if (structKeyExists(form, "fileToUpload")) {// FTP server detailsftpServer = "server";ftpUsername = "user";ftpPassword = "password";// Get the uploaded file pathuploadedFilePath = getDirectoryFromPath(cgi.PATH_TRANSLATED);uploadedFileName = form.fileToUpload;// Create an FTP connectionftp = createObject("java", "org.apache.commons.net.ftp.FTPClient");// C

Hi experts,I am facing issue while binding retrieved data through AJAX in select-list box. I am unable to do so. Please suggest where to do changes in my code.This is my ajax code:$('body').on('change','#port_code', function() { //1st list box on change this will execute to update records in 2nd list box. var selected_port = document.getElementById("port_code").value; //1st list box selected valueif (selected_port != ""){var formData = "selected_port_code="+selected_port+"&reload=true"; $.ajax({url: 'index.cfm?action=vehicle.getGateNo',type: 'POST',data: formData,success: function(data, textStatus, jqXHR){console.log(data);$.each (data, function(k, v){vx='<option value="'+v.GATE_NO+'">'+v.GATE_DESC+'</option>';});$('#gate_no').html(vx); //2nd Select-List box where binding data}}); //AJAX End}}); //Function End Getting record in console.log(data):{"COLUMNS":["GATE_NO","GATE_DESC","ACTIVE","CREATED_BY","CREATED_DATE","MAIN_GATE","PORT_CODE","SR_NO

 Hi Experts,                       I am new to ColdFusion, I am unable to run .cfm file in cmd and in web browser. 1. Should I add .cfm file inside coldfusion\wwwroot\2. How to run .cfm file3. how to add server in CF builder4. How to run file in Web browser (Kindly please say how the process works.) I have installed ColdFusion and ColdFusion Builder In cmd - coldfusion.exe -start -console Installed ColdFusion Administrator http://127.0.0.1:8500/CFIDE/administrator/index.cfm  ColdFusion Builder  Kindly please help me to connect and run the .cfm file, please please.  

We are attempting to create a CFCHART and we want to set a time in the value of the yaxis. It seems from our experience that the yaxis value can only be a number. Has anyone had any luck with trying to do this in the past?

Good day I would like to be guided, we have the Coldfusion 10 license using organisational account, we would like to upgrade the current version of Coldfusion because its not supported and brings some security issues in our environment, kindly assist by giving us direction as to what process needs to be followed in order upgrade this product. ThanksKind regards Raphael 

Hi experts,I am facing issue while binding retrieved data through AJAX in select-list box. I am unable to do so. Please suggest where to do changes in my code.This is my ajax code:$('body').on('change','#port_code', function() { //1st list box on change this will execute to update records in 2nd list box. var selected_port = document.getElementById("port_code").value; //1st list box selected valueif (selected_port != ""){var formData = "selected_port_code="+selected_port+"&reload=true"; $.ajax({url: 'index.cfm?action=vehicle.getGateNo',type: 'POST',data: formData,success: function(data, textStatus, jqXHR){console.log(data);$.each (data, function(k, v){vx='<option value="'+v.GATE_NO+'">'+v.GATE_DESC+'</option>';});$('#gate_no').html(vx); //2nd Select-List box where binding data}}); //AJAX End}}); //Function End Getting record in console.log(data):{"COLUMNS":["GATE_NO","GATE_DESC","ACTIVE","CREATED_BY","CREATED_DATE","MAIN_GATE","PORT_CODE","SR_NO"],"D

I have an OLD version of ColdFusion (ColdFusion 5). I use it to tag simple HTML files. Our IT department doesn't support it anymore. However, I have the Adobe CC package. Why is ColdFusion not included in that package? Does it still support simple HTML files? 

We are dealing with image a lot lately and we were able to write text with different text configuration like, font, fontsize, color etc., on each line. Everything is going good so far.Now, our requirement is to read text from db (one to many lines) which will be variable length by user and need to somehow fit everything in that image without text overflowing. Possibily adding line breakswhich will still use same text configuration. This can lead to more than 1 line on the image. Next, read seond line from DB and repeat the same process except this time text configuration may or may not be same. Started researching on using CFImage tag but will not give me height and width of the text so I can determine the coordinates of the next line.Also, tried to do some research on awt* classes and methods but stuck with same problem.I'm working with CF18 and cannot seems to find anything which can solve my problem unless I'm approching this all wrong.I'm looking for guidence on how this

If there is a post or document somewhere that answers this my apologies... Is ColdFusion 2021 compatible with MacOS Ventura 13.2?  Additionally, is anyone (successfully) running CommandBox on MacOS Ventura 13.2? Thanks

Suddenly the mails are stopped going from my coldfusion web application. I am running on Coldfsuion2016. When I verify mail server connection i am getting the "Connection Verification Failed!" error on coldfusion administartor Server Settings > Mail. I found the following info/exception on mail log:com.sun.mail.util.MailConnectException: Couldn't connect to host, port: my.mail.server.com, 25; timeout 200000; nested exception is: java.net.ConnectException: Connection refused: connect The following info is form mailsent log:Moved undelivered mail: Mail#########.cfmail to ColdFusion2016\cfusion/Mail/Undelivr directory Can some one help me on this?

How can I reach Adobe ColdFusion support team? 800 number? email?

Hi,How can we get cflog files created per day? Thank you.