ColdFusion

I am trying to get the link inside my excel to open a file on my CF folder. The Excel file is in the same folder.For the sake of explaining this is how the folders and files are structured:I have 3 folders A, B, and C.In folder A I have PDF_A1.pdf, PDF_A2.pdf and an excel file EXCEL_A.xlsx. The Excel file has 2 links to the 2 PDF files as described. Folder B and C are also similarly structured.I use cfdirectory and navigating in and out of each folders and able to open the PDF files - no issue.The problem is when I clicked to open the Excel file which opens fine, the link to the PDF points to my local temporary folder. But I wanted it to point the PDF file inside folder AThank you.

Windows Server 2019, IIS running.  Database engine is SQL Server Express 2019, Cold Fusion 2021.I created a new database (Westfield_New) using SQL Server Management Studio, using Administrator (owner) and the password.  Can add tables, etc from SSMS, so database and connection good.I now try to add a new datasource from ColdFusion Administrator.  Data Source Name = Westfield, Driver = Microsoft SQL Server, click 'Add'.CF Data Source Name = Westfield, Database=Westfield_New(what it's called in SQL Server),Server=WindowsServer, Port=1433, User Name=Administrator(owner of the database in SQL Server), Password=[Administrator password], Description blank.  Click 'Submit'.I get the following error message;"Connection verification failed for data source: Westfieldjava.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'Administrator'."Any ideas, as I'm using the same credentials to access the database from CF as I

I would like to use the ColdFusion 2021 with Apache. OS                     :  Windows10 (64bit)Apache Version :  2.4.41-win64-VC14Adobe                : ColdFusion 2021(Developer Version) ColdFusion and Apache are already installed and both are working fine.But the problem is I can not add the Apache server to ColdFusion.The error message is "An unknown error has occurred."

HiI have created a python script that genarete a word document. I want to call this script from coldfusion app. so i add this code :<cfexecute name="C:\tmp\docGen.exe" outputFile = "C:\tmp\output.txt" timeout="10000" errorVariable="error" /> But notthing happens , only output.txt is created. But no result.docx file and no error displayed  

Hi,I have recently upgraded to CF2021.I am having an issue with date formatting.I have the code below. & #DateFormat(Now(),'YYYY')#& "_" & #DateFormat(Now(),'MM')# & "_" & #DateFormat(Now(),'DD')the output is    2021_04_91 But it should be 2021_04_01 It appears to put a 9 instead of a 0Would anyone might know what would be causing this?

I am using Coldfusion 2018 cfsearch, which uses SOLR. When I do a search on a dynamic boolean field like so, it works and returns correct results.<CFSEARCH name = "GetResults" collection = "mycollection" criteria="is_ethics_b:1" >When I try to query more than one dynamic boolean fields:<CFSEARCH name = "GetResults" collection = "mycollection" criteria="is_ethics_b:1 is_visible_b:0" ><CFSEARCH name = "GetResults" collection = "mycollection" criteria="is_ethics_b:1 AND is_visible_b:0"><CFSEARCH name = 'GetResults' collection = 'mycollection' criteria=' ""is_ethics_b:1"" AND ""is_visible_b:0"" '> I have tried other combinations but I get variations of the same error:cannot convert the value "1 AND is_visible_b:0" to a boolean What is best way to query two dynamic _b fields?Also, is there a way to test the query directly on the SOLR server?  Thank you for any help. 

Hi all,i create a xsl file with: <cfcontent type="application/vnd.ms-excel" ><cfheader name="Content-Disposition" value="filename=fehlmenge2.xls"> But the browser wat everytime to download the file.i want to make a shedule cfm site and save the file to the server... but how can i say save as to server not open in browser? Kindly regards.thorsten 

I'm coding a CF11 application on a Windows virtual machine. I made the mistake of seeing the orange icon flashing telling me I needed to do a Java update. After running through the update and restarting everything, the Coldfusion Application did not start. I got the "Service Not Avaialble" error in the browser. So I tried restart the Coldfusion Application and it wouldn't let me start it at all. Then went to Google and located these two somewhat helpful articles:https://handyman.dulare.com/service-not-available-on-coldfusion-host-after-java-update/https://community.hostek.com/t/coldfusion-service-startup-failures/550On there they mentioned going into the CF files to the cfusion\bin\jvm.config file and updating the "java.home" variable with the current path to the Java directory. Which I did. That variable is now: C:\Program Files\Java\jre1.8.0_281 for me. I tried starting the Coldfusion Application again and now it tries to start, but then stops. Which is better than nothing at all, bu

Hello All- I have a strange problem with CFHTTP. I am sending JSON to a server using HTTPS via CFHTTP.  My code worked successfully under CF2016 for quite a while.  I migrated servers, now using CF2018, on Windows 2019.   My problem is that now I can send ONE post successfully via cfhttp, then it will no longer work.  I receive a 'Connection Failure' error after the first success.  I've repeated this exercise at least 30 times, with the same result each time. This is secure, and initially I thought the problem was with my Java certificates.  I installed what I believe are the correct certs. The strange part, is that it will work ONCE every time I restart CF.  I can successfully POST the JSON, and view the results on the target server, as well as receiving the appropriate response from the server.  The next POST will fail.  Every attempt after that will fail- even re-running the initial post that was successful p

Is it possible to see the actual query sent to the Solr server in a log? If yes, where is it located?

We've installed CF 2018 but are having an issue running the Auto-lockdown tool for 2018 Server.  It won't accept the CF admin credentials we put in as valid.  We've confirmed multiple times including copy/paste from notepad into both CF admin and into Auto-lockdown tool and CF Admin logs in fine.  Just Auto-lockdown won't accept.  Anyone else hit this?

Will there be any support for Australians to get this information too or are only Americans being given this information?      The first of this webinar series begins on Thursday at 3am (Sydney time)  and the second is on Friday at 3am (Sydney time) .  Will there be a recording made available so we can share the knowledge too?   Incidentally i've spent yet another frustrating hour trying to find someone who will talk to me about it but no.   There are no Australian phone numbers for Adobe and the online support just sends me to the CF Documentation.       Help for those of us trying to sell the Adobe ColdFusion product is as non-existent as it has always been here.  Mike KearWIndsor, NSW, Australia  

I am not having any success in changing the Solr defaultOperator to AND so that searches are more like web searches.  If I add an AND between words in my search form, I get what I want.  Without the AND it defaults to OR.I've changed the defaultOperator  parameter in all the schema.xml files I could find:\ColdFusion2018\cfusion\jetty\solr\conf\schema.xml\ColdFusion2018\cfusion\jetty\multicore\collections\CollectionName\conf\schema.xmlI also tried deleting and rebuilding all the collections once the changes to the \ColdFusion2018\cfusion\jetty\solr\conf\schema.xml were made without any joy.  The schema.xml files for each collection had the default set as desired after being deleted and rebuilt, but it still doesn't work right. My recollection is that I had to do this to get the default operator to work right in CF10.  I'm not seeing any documented changes to <cfsearch> or <cfindex> that should affect this. Ideas anyone?

I have PMT 2021 installed on my MacOS laptop and all is good. I then began the install on a Windows server we use as backup. First go install completed and all looked good but service wouldn't start. I tried making some progress reviewing logs and starting the services at the command prompt but decided reinstalling was worth the effort. I used the uninstall option from Windows control panel and then started over. This time however the only option I have to install is the datastore. There's no option for installing PMT any more, and going with just datastore installs just that. There doesn't appear to be any other trace of the previous install. Any idea on how I can get back to installing the entire package?  

I have a coldfusion web application. And I want to implement SSO for my ColdFusion application.As per my understanding ,Service Provider , in this case , is my ColdFusion application ?.Identity Provider is someone like Microsoft Azure ?. I am confused about this. Who should act as Identity Provider?. Do I need to create my own Identity Provider?. Or if there are already existing Identity Providers then should I register my ColdFusion application (say , www.xyz.com) with Identity Providers?.Should my ColdFusion application be "https" to register with Identity Provider?.Which one - small or small 2.0 - should I use? Also , my understanding regarding process workflow is as below , User click Login button on my ColdFusion application.Invoke a web service call to my ColdFusion app which then produces SAML request XML ?. What all data we need to capture in SAML request XML?My ColdFusion app then passes this SAML Request XML to Identity Provider?. How we can pass this XML to Identit

Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value. However, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. I believe the issue is security related.

I've installed ColdFusion 2021 developer edition on a Windows machine.  I accepted the defaults when installing.  Did this install Apache for the web host or IIS or something else?  

We have a ColdFusion application that used ColdFusion 10 on a Windows 2008 R2 server. The server crashed after a windows update and we can't get it back. So, we commissioned a VM virtual server running Windows 2019 Server to run ColdFusion. Questions:* What version of ColdFusion should we install on Windows Server 2019? Certified?* Our application uses an MS Access mdb file. Can we still use this in ColdFusion xx and Windows 2019?* Can our ColdFusion 10 code work on the newer ColdFusion version in Windows 2019?This is a mission-critical application and we need to ensure success in this transition. Any advice? Carlos Coronel

Hi,Has anyone had license activation issues with CF2021? We have been experiencing license issues in all the servers we have installed at different times. Server 1 - We had CF2021 installed, but this machine did not have internet connectivity, hence we did the offline activation and activated the license for Enterprise version. However CF lost its license activation suddenly and reverted back to trial version. Server 2 - CF2021 was installed, server had internet connectivty, so the license key worked when applied through CF Admin console and activated as Enterprise version, ran for a month without any issues. Package manager was run to install reporting servlet, this also applied the Updater 1 in the background, 2 hours after this update, the server lost its license again, CF was trying to validate the cached license and then stopped after that. The next day we started the service and everything started working again. Server 3 - CF2021 was installed, license was activate

We are planning to upgrade windows server 2012 VM to Windows server 2019 .wanted to confirm if ColdFusion 11 will work on it ?Or do we need to upgrade the ColdFusion version along with Windows?

I imported the CF2018 setting using CFadmin package manager into newly installed CF2021 and now I'm getting a following error when I try to edit ORACLE specific Datasource. (MySQL and MS SQL are OK)Element urlmap.servicename is undefined in STDSN. I recreated one datasource and it seems to be ok, however, I have over 200 DS's that would prefer not to recreate manually. CF is running on Centos 7.9, cf v2021. Any suggestions?

Getting this error when attempting to update Server Settings: "Error","ajp-nio-127.0.0.1-8009-exec-8","03/31/21","10:36:29","cfadmin","Provider org.apache.xalan.processor.TransformerFactoryImpl not found The specific sequence of files included or processed is: C:\ColdfusionX\cfusion\wwwroot\CFIDE\administrator\settings\server_settings.cfm, line: 675 " System Specifics:   Windows Server 2016 on a Physical Server. Any ideas on why it would be doing this?Other information:It seems to update Timeout Requests after seconds and Enable Per Application Settings, even though I get the error page, but everything after that it does not register the change.   

I am trying to use cfldap with the secure="CFSSL_CLIENT_AUTH" on Coldfusion 2016. I specified the p12 file location using clientcert and the password using clientcertpassword. I also imported the sever's cert into the cacert keystore. When I run the page I always get "One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server." Anyone have experience with this?

We recently upgraded to ColdFusion 2018 Enterprise, which is currently running on four different servers. Each of these servers has two instances running in a cluster. The servers are Win 2K19 with 8GB RAM. CPU usage in generally very low (i.e. < 10%). The number of concurrent users would be less than 50, which are accessing a single site, so I would not say there is excessive load. We have found that each Adobe ColdFusion Launcher Application service will start at around 700-800 MB and then slowly climb up until the point where, presumably, there is no more memory available to it and the ColdFusion site will become unavailable. Restarting the services resolves the issue until it eventually happens again. I have tried increasing the JVM memory allocation earlier from 1024 MB to 2048 MB in the CF admin, but I am guessing this is just going to allow the system to operate for a bit longer that usual rather than actually fixing the underlying problem. Any suggestions on h

Good afternoon.  I am currently using cfx_SNMP.java to enable SNMP queries/etc from my Coldfusion Webpages.  This code was built back in 2009.  I believe it is using SNMP v1.  I am introducing new devices into my system that will not respond with SNMP v1 so I am needing to incorporate this code into using v2c.  I am  not sure how to do this and was wondering if I could get somme pointers.  I ahve attached my cfc_SNMP.java code file to this request.  Thank you.// Decompiled by DJ v3.11.11.95 Copyright 2009 Atanas Neshkov Date: 5/13/2010 4:59:22 PM // Home Page: http://members.fortunecity.com/neshkov/dj.html http://www.neshkov.com/dj.html - Check often for new version! // Decompiler options: packimports(3) // Source File Name: cfx_SNMP.java import com.allaire.cfx.*; import java.net.InetAddress; import java.util.StringTokenizer; import snmp.*; public class cfx_SNMP implements CustomTag { public cfx_SNMP() { } public void