ColdFusion

I have a form that submits to a database. Sometimes users inadvertanly click the submit button 2 or 3 times, resulting in 2 or 3 dupkicate submissions.I would like to stop users from being able to insert any record within 5 seconds of the last insert<cfquery datasource="#APPLICATION.ds#" name="get_max_ID">SELECT MAX(insert_time) AS maxtime FROM FORMS</cfquery>When a form is submitted I need to check if it is within 5 seconds of the maxtime . If it is . I <cfabort> with an error message. If it is after 5 seconds I allow the insert. How do I do this check?

Hi, I have coldfusion 2023 on windows server.Scheduled tasks doesn't work. They are inserted correctly. (some of these already existed on the old server with CF2016).If I try to run them from the administration (the little running man) I get the following message: his scheduled task Gioca-resp - message remind of group default was completed successfully. But in reality it is not executedthe URL used in the task is HTTP - so not key issues. I tried to call the url with CFHTTP but I get the following error message:Connect Exception: Connect to Gioca-responsabile.it:80 [gioca-responsabile.it/194.76.116.40] failed: Connection refused: no further informationwhether I use http (therefore on port 80) or https (port 443).If I try to use CFHTTP with a domain that is not on the server, for example google, it works fine. If I put the URL in the browser it works fine What could it depend on? ThanksMarco  

I'm starting a new thread on this because I discovered my first approach would not work for all possible Solr syntaxes; some of which we difinitely need in our application. Basically, we are now taking a variable value from a forms code as shown below:<INPUT TYPE="hidden" NAME="keywords" VALUE="#Form.keywords#"> Then we are populating CFSEARCH with the syntax for a given query by using encodeForURL & decodeFromURL where appropriate in the application. So our CFSEARCH code is:  Note:  We have included an <cfoutput><cfabort> line of code for testing.******************************************<CFSEARCH NAME="applicants_#var#"COLLECTION="Resumes"TYPE="standard"CRITERIA="#encodeForURL( Form.keywords)#"><cfoutput>#applicants_test.recordcount#</cfoutput><cfabort>******************************************The output shows we are using the solr syntax needed for a given search.However, the only time where we get the correct nu

Adobe ColdFusion (2021 release) is finally here! The completely reimagined Adobe ColdFusion (2021 release) offers a modular, secure, and containerized approach to building applications that can run across multiple cloud providers or on-premises. You can now switch between cloud service providers without having to rewrite your application. For more information, see What’s new and changed in ColdFusion (2021 release). Take your applications to the cloud Seamlessly manage your infrastructure and reduce downtime by quickly connecting to the Microsoft Azure or Amazon Web Services (AWS) database, storage, messaging, Amazon RDS, and email services. Move services from one cloud service provider to another without having to rewrite your application each time. AWS SQS AWS SNS AWS S3 Azure Blob Azure Service Bus Modularization You can now install only the services your application needs, and nothing more. Modularization lets you continuously integrate small pieces of code and deliver applicati

Greetings All. After reviewing my testing below I would VERY, VERY much appreciate any suggestions as to why searches against a collection using a phrase are not working properly, in this case the criteria field = "tribology friction".This issue arises as a function of my attempts to solve a CFsearch problem in another thread.The following is a list of test which were done comparing the results of the Solr Admin tool (SAT), production server (PS), development server application code (DSAC) & deveopment server stand alone script (DSSA) against the same data. Note: the production server is running CF 4.51 & the development server is running CF 2023.The testing searched for the words "tribology" and "friction" using 3 different criteria as described below. Note: For those of you who are curious, tribology is the science of bearing wear.Criteria                       &

Hello All,We recently migrated to CF2021 in last week in Production and we are facing major issue with all Java jars. Jars are in CF2021/jre/lib folder but still we are facing hard errors on createObject function.Whenever CF trying to create Java Object using createObject function, it's giving classnotfound exception on that java object.If anyone faced this issue before please comment here. We will really appreciate your help!Thanks in advance!

Hi there, I recently built a ColdFusion 2021 server and I am trying to run "legacy code" on it. I have a service called getBank which I could call from the browser with https://***/rest/services/getBanl.xml or /getBank.json with ColdFusion 11 which would return a response in the correct format. I am now unable to use getBank.json with the new version of ColdFusion. Please assist. See the service below: <cfcomponent rest="true" restpath="getBanks"> <cfset datasource = "dsn"> <cffunction name="list_type_function" returntype="query"> <cfquery name="resultQuery" datasource="#datasource#"> SELECT bank_id, bank_code, bank_name FROM banks </cfquery> <cfreturn resultQuery> </cffunction> <!--- application/json for content negotiation ---> <cffunction access="remote" name="getBanksJSON" output="false" httpmethod="GET" returntype="query" produces="application/j

I have set up ColdFusion in a pod of my Kubernetes cluster. I have configured all settings (services, ingress, etc.), and everything is working fine. However, I'm unable to connect ColdFusion to the Apache web server through wsconfig.I've successfully done the same setup in a Docker container, but I encounter errors only in the Kubernetes cluster. The process of connecting wsconfig to Apache seems to proceed without errors, and when I list the wsconfig connected server, Apache is displayed.When I access the server (Apache), it's working, and I can reach it. However, when I try to run a CFM file, it gives a 503 error.I referred to the following documentation for guidance:https://helpx.adobe.com/in/coldfusion/configuring-administering/web-server-management.htmlVersions used: ColdFusion 2021/23 

Hello All, I am looking for simple solution to list down all objects unders S3 bucket specific folder. I can list down one object but challenge is object/keyname is dynamic. So, I cannot specify keyname while retrieving the object from s3 bucket. Is there any simple way if anyone come across to pull all S3 bucket folder objects and copy them into local directory?Then I can use <cfdirectory> to filter the files I want.Please suggest.Thanks in advance!

Hello Coldfusion Community!  It's nice to meet you all.  I'm seeking out some help performing a JRE update on our CF Server.  I am troubleshooting an high-priority incident with our software and hope I can some guideance toward a solution. Problem:Yesterday morning, we noticed that emails were not being sent from the site, getting stuck in the "Undelivered Mail" list.Upon reviewing mail.log, I found this message each time CF attempted to send an email.javax.mail.MessagingException: Could not connect to SMTP host: secure.emailsrvr.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetResearching this error led me to believe that it's possible our email provider or their CA had a security configuration change that doesn't work with this old server.   (C

I am trying to figure this out. Anything I try that uses s3:// prefix like readAsBinary() always ends up with "The AWS Access Key Id you provided does not exist in our records". Yet when I use downloadToFile() on the bucket object, there are no issues. Are there special perms to use that prefix? I am not the AWS admin.CF2023.

I am running CF2023 with JDK-21 using commandbox. I am getting the following error (see attached screenshot), which doesn't occur for me on prior versions of CF/Java. I added the following to my server.json which my understanding is this should be added by commandbox to the jvm.config file and I had assumed this would have stop the error, but it did not. Any advice/help would be appreciated:"jvm":{        "minHeapSize":"${MINHEAP:1G}",        "heapSize":"${MAXHEAP:2G}",        "args":[            "-Dcoldfusion.datemask.useDasdayofmonth=true",            "-Dcoldfusion.xml.allowPathCharacters=true",            "--add-opens=java.desktop/com.sun.awt=ALL-UNNAMED"     &nbs

Getting a few errors when we are cf document to generate a pdf file. coldfusion-error.log records: java.lang.NoClassDefFoundError: Could not initialize class java.awt.Toolkitand coldfusion-out.log records the error: Feb 1, 2023 14:16:36 PM Error [main] - Unable to initialise JAI service: java.lang.UnsatisfiedLinkError: C:\Program Files\Java\jdk-11.0.17\bin\awt.dll: Can't find dependent libraries Do I need to reinstall or repair either the Java SE Dev Kit app or CF 2018?

(CF2016/Win 2022/IIS 10) I want my users to be able to stay logged in for a long period of time, however as Microsoft release it's updates every second Tuesday of the month, I like to make sure these are in place asap and this almost always requires a reboot. A reboot loses all of the sessions, so the users would have to log back in again. I believe (well according to my new friend ChatGPT) early versions of CF used to have an option write the session to a file so it could be recovered but now it's memory or Redis. I did find a thread in the forum regards editing of Tomcats config, but I was a little uncomfortable doing that. Does anybody have any solutions to this? My thought is that I'll write a big unique token (or two) into a cookie and stored in their database record, and when they return if they are logged out, use that to reauthenticate them and create a new logged in session, a "remember me" so it automatically logs them back in seemlessly. One dow

 I'm trying to do the following:secret_key = "sometihng"; web_token = CreateSignedJWT(payload_string, secret_key, hash_params ); And I receive error: signOptions type not supported, it has to be of type Key or KeyPair or StructColdfusion's jwt documentation states the secret_key parameter should be a struct, which I understand. However, I'm unclear on how to use the secret key as a string without using the keystore, because if I usekey_options = { key = secret_key } web_token = CreateSignedJWT(payload_string, key_options, hash_params );then I receive error Either the keystore path is invalid or corrupt or the keystore password is wrong.The key itself is stored in an encrypted database column, so I want to pass a string version of it. How can I do this without the keystore?

The following information is meant for the website developer for debugging purposes.Error Occurred While Processing RequestElement COMPANYUSERID is undefined in VARIABLES.  The error occurred in /app/cfincludes/bld_Session.ProNet.cfm: line 384Called from /app/Application.cfm: line 304Called from /app/Application.cfm: line 1382 : </cfif> 383 : <cfelseif Session.IMAPPROLENM EQ "ProNetCCRUser"> 384 : <cfif (Len(Variables.CompanyUserId) is 😎 385 : and (Len(Variables.UEI) is 12)> 386 : Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem. Browser  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36Remote Address  172.22.0.137Referrer  https://connect.sba.gov/Date/Time  13-Feb-24 03:58 AMStack Traceat

We are migrating from CF2018 to CF2023 and many of our S3 calls have broken. In CF2018 we are using delete object calls like this: fileDelete("s3://#s3accessKeyId#:#s3awsSecretKey#@#s3Bucket#/#object#") When we try the same code on CF2023 we get this error:Cannot invoke "java.lang.Boolean.booleanValue()" because the return value of "coldfusion.vfs.s3.S3FileSystemConfigBuilder.getParam(org.apache.commons.vfs2.FileSystemOptions, String)" is null null Any help figuring out how to delete a file in S3 would be greatly appreciated.

[CF2016 - Windows Server 2022 - IIS 10] I have a problem where if I replace a set of files, for instance 12 small CFM's and then I run one of them, it takes about 7 to 8 seconds for the page to load, then it's fine. This does not appear to impact HTML pages, just CFM. It's not database related, I saved the static results of a page, and saved that as a CFM so there was no database queries and it still did it. I never had a problem until I updated from Windows Server 2016 to 2022 I cloned the server and then installed a CF2023 trial so it made me think that perhaps CF2016 did not work well with Win2022/IIS 10. However, I then cloned it again, removed the CF2016 and reinstalled it, and it seems to be just fine. So the fix looks like I have to take down the production server, uninstall and reinstall, but before I do that, I was wondering if anybody has any thoughts on anything I might check that could fix this? Thanks

I am using CF21 at window server having enterprise edition. Last couple of days i have restarted server and it converted to Developer edition. What shall i do to overcome with this? Please advise. For your information we are keeping our server in offline mode.

Good afternoon, I am having problems with coldfusion 2021 enterprise, I make two requests with cfhttp to a balancer with two microservices in node and it always gives me the following error, I really don't know what could be happening. In PHP it also marked an error for SSL certificates but its verification in CURL was disabled and it was solved. Thank you all and have a good day! 

I have to update the connection string property in about 200 datasources in CF admin on mutiple servers. I'm looking for an easier wasy to do this instead of editing each datasource, perhaps editing a file or something. Does anyone have any suggestions on how to do that? 

OK.I do a search against my Resumes collection in CF 2023 with the Solr Admin tool using the criteria "medical device" & I get 1325 hits which mirrors what I get from our CF 4.51 producton server.. I do a search inside CF 2023 using the below code & I get 15,574 hits.  This approximately mirrors the number of hits I get on the production side if I do a search for either of the terms medical or device. Edit#1:  It occured to me to do a search inside CF 2023 using the  criteria string "medical" OR "device" and I got precisely 15,574 hits, the same as "medical device"!!  Hmmm ....So what am I doing wrong?************************<CFSEARCH NAME="applicants_#var#"COLLECTION="Resumes"TYPE="standard"CRITERIA="medical device" >*************************

We have been running Coldfusion Standard Edition on Centos7 for 5 years and curently on CF2021.  However, Centos7 will reach EOL in June 2024 and we need to start planning the move now. The most popular sucessor to Centos is currently AlmaLinux. Can you confirm that either CF2021 or CF2023 is compatible with AlmaLinux.  If not, can you please provide an update as to whether an installer for AlmaLinux is being worked on and when we can expect an announcement.  Because of the massive popularity of this platform I imagine there will be a flood of requests over the coming months.   

At this point, I may be the only person on the planet who would need this advice But here goes.As stated in previous threads we're upgrading from CF 4.51 to CF 2023.In CF 4.51 we had 3 collections for applicant data . Each of them contained data from both a database field and a file for each candidate.  Note:  We had 3 to shorten the search processing time. The collection1 had candidates with last names starting with a-g, collection2 with h-o & thirdly p-z.  That way, we only needed to search approx. 20,000 records vs. 60,000 in any given search after a quick code check of the 1st letter of the last name.We did this by converting all .doc & .docx resumes to .txt with a custom tag we had developed which converted word docs to txt (doc2txt).  the converted .txt file was then indexed (HTML, HTM & txt resume files were simply loaded into the collection as .txt without any need of conversion.Now, for each candidate we would also append the txt from a database

Does anyone know if CF 2023 uses Solr’s default Query Parser is also known as the “lucene” parser? I have been testing searches using the term modifiers suggested in the Solr Reference Guide 8.2.A simple one word keyword search seems to function properly.  However, i am getting results with more complex keyword strings that are out of whack.For example, If I do a search using "medical device" including the quotes as indicated by the guide, the result is 55868 candidate hits.  That is roughly 500 hits short of every caniddate in the system! Using our production machine running verity against the same data the actual result should be 1618 candidate hits.Another example, using "medical device"~4 again results in 55868 candidate hits.  The verity equivalent medical<near/4>device is actually 8649.  Just for the heck of it, I tried "medical device"~4 without the quotes on the development machine and get 16698 hits.  Again, nowhere near the correct number o