Questions

I have a DB with a date field that I need to update periodically. I'd like to set a date on the same template where I insert the record.  I run my insert query, then run a select query for maxID to get the data row. I set a session variable with a calculated date, and I want to "set" that date in the field with an update query. In the following code, setting the value as "2021-09-17" will update the field, as I desire. But, if I try to use my session variable for the update, it doesn't work. I've tried every variation on syntax I can conceive of, and nothting works.  After the form action, debugging on my page shows that the variable exists and holds a value. Is there a chance that it doesn't get set before the update query fires?  <!--- Set ExpireDate column ---> <cfquery datasource="#APPLICATION.dsn#"> UPDATE tbl_user <!---SET ExpireDate = "#session.ExpireDate#"---> SET ExpireDate = "2021-09-17" WHERE U

Hello I recently upgraded my office coldfusion11 server to the coldfusion 2021 server.  Once the upgrade took place I was no longer able to access the coldfusion admin interface. I currently configured the site to run on IIS. I have attached a screenshot of the error I am getting.  Any feedback or help is greatly appericated.  Thank you. 

I'm having issues with creating a useable docker container for a ColdFusion 2021 app. I can create the container, but everytime it is rebuilt I have to reinstall all of the modules (admin, search, etc.). This is an issue because the site that the container will be housed on will be rebuilding the container everyday. The container is being built with docker-compose. I have tried using the installModule and importModule environmental variables, running the install command from the Dockerfile, building the container and creating a .car file to keep the settings, and disabling the secure mode using the environmental variables. I have looked at the log, and all of the different methods used to install/import the modules are actually downloading and installing the modules. However, when the container first starts to spin up there's a section where the selected modules are installed (and the modules that are not installed are listed). That section is followed by the message that the

I'm having issues with creating a useable docker container for a ColdFusion 2021 app. I can create the container, but everytime it is rebuilt I have to reinstall all of the modules (admin, search, etc.). This is an issue because the site that the container will be housed on will be rebuilding the container everyday. The container is being built with docker-compose. I have tried using the installModule and importModule environmental variables, running the install command from the Dockerfile, building the container and creating a .car file to keep the settings, and disabling the secure mode using the environmental variables. I have looked at the log, and all of the different methods used to install/import the modules are actually downloading and installing the modules. However, when the container first starts to spin up there's a section where the selected modules are installed (and the modules that are not installed are listed). That section is followed by the message that the

Hi Everyone, I have a few kiosks that I use this code for and over the last few days I keep receiving this error "Element upload-id is undefined in a CFML structure referenced as part of an expression." on line 93 which I have in bold and Italic. Nothing has changed at all with those code. Here are a few lines from it before and after the error.  </cfoutput><cfhttp url="#baseurl#/api/recipients/upload" method="post" result="uploadresult" ><cfhttpparam type="header" name="Authorization" value="Bearer #token.access_token#" /><cfhttpparam type="FormField" name="stage" value="1" /><cfhttpparam type="FormField" name="updateAll" value="1" /><cfhttpparam type="FormField" name="uniqueUploadId" value="#result['upload-id']#" /></cfhttp><!---cfdump var="#uploadresult#" / ---><cfoutput>Requesting stage 3 processing<BR></cfoutput><cfhttp url="#baseurl#/api/recipients/upload" method="post" result="uploadresult" >&

CF Version: 2021 Enterprise (Licensed)Operating System: Windows 2016 (x64 in Azure)Web Service: IISWhen I attempt to run a .cfm file using cf.bat, it gives the error below.  It seems to error out because it can't contact adobe, however it is behind a very strict network, it might as well be offline.  Is there a way to get past the license check, since the service is already licensed?cf-cli>e:\webroot\scheduled_jobs\nll\index.cfm Aug 13, 2021 23:37:51 PM Error [main] - Unable to install WatchService package: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Security service is not available. SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Security service is not available. cf-cli>Aug 13, 2021 23:38:33 PM Error [Thread-2] - Faile

(CF2016 Update 17) Hi, I've used #CGI.http_referer# on and off for many years. On my recent use I noticed that part of the URL's were missing Example if  link from the local host to the domain and try to log in, I get part of the link http://127.0.0.1/ but not the full link I came from http://127.0.0.1/sometest/testrefer.html for example I just tried it on the local host to the local host and that worked fine. I have some servers on a load balancer and in the past I'd lost some info as the ISP didn't pass it through but this server is not on the balancer so I know that is not the issue Does anybody know where I might look to resolve this? Thanks

I have ColdFusion 2018 Update 11 installed on the Windows server. This ColdFusion uses a Tomcat version 9.0.41 as a connector . Is it any way to upgrade tomcat version 9.0.46 internally without upgrading ColdFusion 2018 Update 11?And also if there is way then ColdFusion 2018 don't have any compatibility issue, It should run smooth on Tomcat 9.0.46 because I am having old ColdFusion code.Any suggestion please help.Thanks.  

System Information:MACOS: Catalina 10.15.7 Docker DEV Envirment – MSSQL + Coldfusion:FROM mcr.microsoft.com/mssql/server:2019-latestCFENGINE: adobe@2021 Context:Recently updated docker software and now dev envirment won't complete build. Worth noting this used to work prior to the update but there was a few unrelated changes that needed to be made - i.e. the MSSQL image needed to be pulled from a new repository. Once I changed the DockerFile FROM microsoft/mssql-server-linux:2017-latest to the newer repository... FROM mcr.microsoft.com/mssql/server:2017-latest the "docker-compose up" build process worked up until initiating the database. The build is now stuck on this Terminal message and never completes:cfml_1 | WARNING: org.xerial's sqlite-jdbc is not loaded.cfml_1 | Please provide the jar on your classpath to parse sqlite files. cfml_1 | See tika-parsers/pom.xml for the correct version.database_1 | 2021-07-19 21:34:50.

We attempted to upgrade from Coldfusion 11 to 2018 today and we are now getting  our cross-origin requests blocked by Chrome. Reverting back to CF11 (changing no settings in IIS, just switching the connector) we have no problems. So, my question is this: What has changed in the Rest Services served by CF2018 so that cross-origin requests would start getting blocked when the same code served by CF11 works fine? And, what, if anything, might be done to get around this issue?

I have a server with 4 instances set up with the CFadmin Instance Manager.All is well, but when I try to get a user count, you only get the count on your logged in instance.I'm trying to log in to a specific instance, any suggestions? -Chuck   

Hi Team,We  are  using ColdFusion 2016 Services in one of  the application. We observed that service is  not starting automatically even after  mutiple restart . Could you please check and assist further on this issue Please find the error  log for the same and let us know in case ofany further logs required.  RegardsHemanth 

Hi,The JSON format I would like to send  is like this:{"InvoiceID": "12345",  "InvoiceLine": [{"Description": "Item1", "Quantity": 1, "LineTotal": 20} ,                            {"Description": "Item2", "Quantity": 2, "LineTotal": 15} ]} I tried to create the above by <cfset LineInfo =' {"Description": "Item1", "Quantity": 1, "LineTotal": 20} ,                            {"Description": "Item2", "Quantity": 2, "LineTotal": 15} '>This is done after some looping to find out the number of lines I have.  <cfscript>myStruct= {"InvoiceID": "12345",  "InvoiceLine": [#LineInfo#]}</cfscript> Then, #serialize JSON(myStruct)# becomes{"InvoiceID": "12345", "InvoiceLine": ["{\"Description\": \"Item1\", \"Quantity\": 1, \"LineTotal\": 20} ,             

Hi, Just wondering if anyone has any experience of upgrading the Microsoft SQL Server driver from the Adobe one to the Microsoft one and if there was any improvement in performance. We did it but ran into issues with identity fields not being returned from insert queries but if there was a noticeable improvement in performance from them its something we would revisit. Thanks,Paul

Want to migrate from CF2016 to CF2021.  Have 2021 developers version with update 1 running.  My site has many cflayout tab areas with cflayoutarea tags for each tab.  These layouts are bound to dropdowns.  When another dropdown selection is made CF returns the following error: Component with the name tabname already exists.  Please use unique names for all the components.  Layout will not be rendered. If i remove the name= property in the cflayout then no tabs are rendered, so name is needed.  The page has one name for each tab and worked just fine in CF2016. Coding unique names seems like it shouldnt be needed for each time the dropdown is selected. Any suggestions?

I have been using ColdFusion 2016 for about 5 months without problem. Two days ago I suddenly could not access the built in server, receiving such messages as:127.0.0.1 refused to connect. in Opera and ERR_CONNECTION_REFUSED in Chrome.I thought it could be a firewall issue, since when booting up I saw a message saying that another app (Akamai NetSession)  was being blocked and that Windows Firewall had made some changes. However on checking the firewall, ColdFusion Server is being allowed through (as are Opera Chrome, etc).I tried to start CFServer from a command prompt, but after navigating to the bin directory and typing ColdFusion.exe start I got no message of any kind.I am on port 8501 with the server (8500 was used by and old version of CF11) but have never had any running problems.I noted that the IIS start page appears on 127.0.0.1 when I checked the relevant options - so localhost is not completely disabled.I am not an expert on server issues. Anyone any ideas? Thanks in a

I ran into an issue where a condition (CFIF) that should be true is returning false. I'm hoping someone has a nifty answer to this. Here's some code I created to demonstrate the test:<cfif url.userid is "session.userid"> <!--- Condition True ---> My test is <cfif url.userid is "session.userid"><br><br> url.userid IS equal to session.userid<br><br> The values are:<br> url.userid = <cfoutput>#url.userid#</cfoutput><br> session.userid = <cfoutput>#session.userid#</cfoutput><br><br> <cfelse> <!--- Condition False ---> My test is <cfif url.userid is "session.userid"><br><br> url.userid is NOT equal to session.userid<br><br> The values are:<br> url.userid = <cfoutput>#url.userid#</cfoutput><br> session.userid = <cfoutput>#session.userid#</cfoutput><br><b

I'm installing Coldfusion 2021 on a RHEL8 server.  It is supposed to be running under Tomcat 9.0.50.  We run this succesfully on a CentOS 8 server/Coldfusion 2018.  However, RHEL, both cf2018 and cf2021 give the following message:"Error","main","08/04/21","08:52:35","","The Runtime service is not available. This exception is usually caused by service startup failure. Check your server configuration."coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available.How can I mitigate this?

Good afternoon,      CF 2018 installed on a CentOS 7 server.  I'm having what seems like a permission issue when using tag:<cfdocument>, PDF generated file.  The error report indicates "java.io.FileNotFoundException" <path to PDF file> (Permission denied).  This is happening for all PDF generated files using <cfdocument>.  Has anyone had experience with granting the appropriate permissions to generate these PDF files on linux?  I'm guessing the ColdFusion user needs to be granted the appropritate permissions to generate the file, or this is something having to do with the way the hosted server is setup in regards to network security.  Any insight will be much appreciated. Thanks, -Daniel

ColdFusion 2021 and cfhtmltopdf fail to correctly render a PDF that uses the SegoeUI font.  ColdFusion Admin indicates the font is installed.  The PDF is generated but there is no visible text.  Inspection of the generated PDF indicates there are no embedded fonts. Code to Reproduce Problem <cfset fntPsName = "SegoeUI"> <cfsavecontent variable="pdfContent"> <!DOCTYPE html> <html> <head> <style> body { <cfoutput> font-family: #fntPsName# ; </cfoutput> font-size: 18px; color: black; font-style: normal; font-weight: normal; background-color: white; } </style> <title><cfoutput>#fntPsName#</cfoutput></title> </head> <body> <cfoutput> <h1>#fntPsName#</h1> </cfoutput> <!--- https://www.lipsum.com/ ---> <h1>What is Lorem Ipsum?</h1> <p><strong>Lorem Ipsum

Can the output of the analyzer be exported to a text file, or any sort of file?  Thanks

Hi!I have an action file that creates a record with a hashed password: <cfquery datasource="#ds#"> INSERT INTO tbl_User(Email, RoleID, password) VALUES ('#email#', '#session.UserRoleID#', '#hash(form.Password,'SHA')#'); </cfquery>The password field in my new database record begins with "2879EA..."The next file in my registration process invokes a CFC method: <cfinvoke component="users" method="get" Userid="#session.UserID#" returnvariable="userData"> </cfinvoke>It sets the password variable using that query's results: <cfset password=Trim(userData.password)>And populates the update form: <tr><td>Password:</td> <td><cfinput type="password" name="Password" size="17" maxlength="50" required="Yes" value="#hash(Password,'SHA')# " message="You must enter a password." style="font-size: 83%;"> </td></tr> When I click the update button,

Hi,I have batch & js file which convert to word to pdf using cscript.exe.when I execute batch file directly it convert the files. But if call through browser using below cfm file  I my coldfusion page never end the execution and no output files created.<cfexecute name="C:\Windows\System32\cmd.exe" arguments="/c #expandpath('./Word2PDF.bat')#" timeout="2000"></cfexecute> 

I tried over the weekend to reply to https://community.adobe.com/t5/coldfusion/2021-odbc-agent/td-p/12216384, I click the post button, and nothing happens.  I click it again, it tells me I'm flooding and need to wait an hour. Is it me? Thanks

I* don'[t have IIS locally (sadly) so I'm trying to define the default doc that opens when you click 127.0.0.1:8500. I want it to be default.cfm.Looking through tomcat docs I thought I found it at C:\ColdFusion2018\cfusion\runtime\conf\web.xml:    <welcome-file-list>        <welcome-file>default.cfm</welcome-file>        <welcome-file>default.cfml</welcome-file>        <welcome-file>default.html</welcome-file>        <welcome-file>index.html</welcome-file>        <welcome-file>index.htm</welcome-file>        <welcome-file>index.jsp</welcome-file>    </welcome-file-list> But now it defaults to index.cfm (which I did not