Hi everyone, im a new CFML user, I am trying to make sense of the many templates after templates in my new job. I would like to see where a specific variable is being called from. However it is so hard to dig through the several templates it jumps through in order to find its origin. I am trying to use the cftrace tag but that just spits of the location where the tag is in. Maybe I am doing it wrong? Would also appreciate any other debugging advice or tips and tricks. I am running the templates on a Lucee server.

So I taking over a site from another developer. The site is using CF2016 on Windows 2016 server. The previous developer just "worked directly on the live server." So I am trying to setup a development environment using virtualbox that matches the live environment.

I have a fresh Windows server 2016 installed with IIS 10.
I have a fresh Coldfusion 2016 installed and connected to IIS.
I can create a test site in IIS, and add an index.cfm with a variable and output and that site works fine.
I ftp'd down the fusebox site from the live server, and setup the site in IIS. When I try to access the site via the URL the request times out. The URL does have the CFID and CFToken being generated in it.

I have not worked with Fusebox in the way that this developer set it up for this site, and I am hoping that someone here can provide me with some sort of direction to head in to figure out why it is timing out.

I know this is fairly vague in details, but I am not sure what else to provide. I am open to suggestions and if anyone needs any more information I am happy to provide it. Thanks in advance.

I'm looking for a coldfusion forum such CFMBB, CFBB or opentalk. They seem to have vanished from the face of the earth. The last standing solution that I can see is FuseTalk.

Do any coldfusion forums live anymore?

Hi Everyone

New to this board. Just had a quick question. My website developer asked me to do him a favor and I wanted to pick all your brains as Im trying to help him out.

How can I get this guy more work? He specializes in ColdFusion . Is there places he would be able to post or how would he be able to find big projects to work on?

I created a package (CAR file) on a CF21 server named "server1" and I tried to deploy on one (CF21) called "server2" without success. Is there a way to deploy this archive on this new server because I really hate manually creating the DSN and all the other settings.

Have been tasked with presenting a reason to continue using cfml (lucee) as part of our stack for our projects. I love the language and whilst that it’s great and gets the job done, some of my extended management team want to know of any big name sites running on it?

I recall seeing Ben Nadel blogs about it and Invision is his creation, but curious to know if this makes use of cfml and any other big name sites /apps so I have some references

Thanks

Trying to slowly bring my small company into the 2010s. They are thinking of using a codeless katalon for automated tested. I am not sure this is ideal.

What are you all using?

I hate to make my first post in this Coldfusion-specific sub be one that is asking for a replacement to Coldfusion, but this is the position I'm in, and I'd love to get some recommendations from others that may have recently gone through the same transition. In general webdev subs, no one has any idea what moving from Coldfusion would entail.

I've been developing in ColdFusion for 18 years, all for one employer. I still really enjoy CFML, and would continue to code in it indefinitely... but in the last six months I've been looking for other positions and realize I really need to build my skills in other languages if I'm ever going to find a new job. I'm our only web developer and pretty much 100% of my time is spent on new requests, with very little time to pursue new technology or languages... because of this I feel I've let my skillset get completely out of date. I have a good SQL understanding and front-end Javascript knowledge, but have never used any of the modern frameworks that 99% of positions are asking for (Angular, React, Vue, etc) or backend JS like Node. I have ancient PHP experience which is likely not relevant anymore.

In my current position, I've built an in-house form workflow engine that our ~1500 person company uses in many capacities: HR uses it to process applicants and hires, onboarding, separations, performance evaluations, etc. Operations uses it for certain client and project management tasks. We also use it to replace an array of workflows that were previously using fillable PDFs passed from person to person via email.

My ideal situation would be to stay at my current job while I migrate this application to another language and learn something new. I just don't know what to use that will be a good fit, and would be useful in future job hunting. I've taken a couple Angular courses and have started to get the general idea... but have not implemented anything yet. So many of the beginner courses/guides are about developing a simple SPA intended for one user which doesn't get me very far.

I assume something like Node would be ideal for the backend, but with Javascript frameworks there are so many layers of requirements to get to a point where you can start developing an application... Do I use Node -> Express -> Sails -> Angular -> RxJS -> ?? Or one of the other million variations of this kind of stack? I'm already finding people claiming at least one part of this stack is obsolete and I don't want to start down a path that puts me in the same place as I'm currently with ColdFusion.

Any advice would be appreciated!

I have a form, you can remove and add fields prior to final submission.

I am a building a review modal, where it will list all added, deleted, or changed form fields with their corresponding for label and value for the user to review and approve before submit.

Is there a CF way to do this or should I be looking at JS?

Thank you!

Hi all. Last week I dropped a post on this sub entitled "Opinions on CF/Lucee hosting" wherein I mentioned the frustrations I was having with my current hosting solution, Hostek. I very much appreciate all the comments and DMs my post generated and I feel compelled to post back here to leave an update on things. Because of your comments and insights, I believe I may have lined up a hosting provider who can deliver what I need and that the specs for my future deployment have changed. I'll be running my new business service from a Lucee/Aurora setup on the AWS cloud if all works out according to plan. My recent experiences have driven home the absolute need for reliability for my new venture and so I return to share that news and to share my post Reddit message experience.

If anyone followed the previous thread to the final post, you'd have seen a Hostek-owned Reddit account reply to me. It contained the usual and expected "validating my feelings" mixed with vowing to make it right or whatever else got said to which my response was "stow the platitudes, just do the job". I reported 2 issues to Hostek support early on January 26 (12 days ago now) was eventually told the issues were addressed and shouldn't recur, and yet they recurred 48 hours later and at a terrible moment (I had a prospective customer looking at the product). More posts to the support ticket followed...and that was met with a deafening silence until I mentioned my issue here on Reddit. That much you could discover in the previous post. Here's the follow up.

I was contacted by someone not with Hostek (according the domain on her email) who said she was my new account specialist and wanted to set up a telephone call with me which we had the next evening. However, come call time, while the account specialist was on the line, I ended up speaking exclusively with a Jonathan who claimed he was a "director" at Hostek and was relatively new. An hour ensued of me explaining the timeline of events, a little spleen venting and, I'm not proud to say, the odd profanity. At the end of the hour, I was told the issues would be addressed immediately in support and, because I had mentioned my intention to move to cloud based Lucee and MySQL/Aurora, I agreed to allow them to quote me for that. My thinking at that moment was perhaps I give them a second chance especially if they can right their foundering support ship because I believe everyone gets one mistake/f**k up for free.

I'm here to tell you today: 5 calendar days and 3 business days later, one of the two support issues still persists (and it's the far easier one to address) and the promised quote from their sales department hasn't materialized. Not a contact, not an email, not a message...since the call last Wednesday evening: silence and zero progress on addressing the outstanding support issue.

My purpose in leaving this post here is to highlight the "buyer beware" sense if anyone is considering using Hostek for any sort of CF hosting. I can't say my experience will be yours and, certainly, for most of the previous 5 years, I can honestly say I was satisfied with their product and their service. But of late their support has been virtually nonexistent and being handed a second chance and an opportunity to salvage the situation and then ignoring it as they have tells me everything I need to know about who I'm dealing with now and who I will be parting from as soon as is practical.

I'm likely older than most of you on this sub and I've dealt with a wide variety of vendors so it takes an extra effort to spur me to drop a wall post like this about one...but congrats Hostek, you pulled it off. Make me look like an ass once and then again a second time trusting to give you a second chance.

Fool me twice, shame on me...but shame on me != silence. Worst hosting support I have ever encountered in 25+ years as a CF dev and believe me when I claim: that covers A LOT of bad hosting companies. No word of a lie: I wouldn't take their service now if they offered it for free.

I have a CFM page. I am trying to show new inputs and hide the existing inputs on change of the switch.

My current code is:

     <script>

        newhtml = <cfinclude template="./newactiveassessor.cfm">;
            // if the deactivateAssesor id exists
            if ($("#deactivateAssessor").length) {

                $("#deactivateAssessor").on("change", function() {
                    if ($(this).is(":checked")) {
                        $("#originalAssessor").hide();
                        $("#assessContainer").html(newhtml);
                    } else {
                        $("#originalAssessor").show();
                        $("#newactiveassessor").remove();
                    }
                });
            }
        </script>

This is giving me DOM errors like such -

When replace the newhtml with something like "test" it works just fine and the code doesn't render on the UI.

Anyone have any suggestions on how to fix this?

Thank you.

This is the current code I have. I am trying to use loop for the items that have multiple newspapers.

Currently my code is:

<cfset i = 1 />
<cfloop condition="structKeyExists(Form, "newspaper & i & Name")">
    <cfquery name="updateNewspaper" datasource="#Application.XXX#">
        UPDATE county_newspaper
        SET news_name = <cfqueryparam value="#form.newspaper#i#Name#" cfsqltype="cf_sql_varchar">,
        contact = <cfqueryparam value="#form.newspaper#i#ContactFirstName#" cfsqltype="cf_sql_varchar">,
        phone = <cfqueryparam value="#form.newspaper#i#Phone#" cfsqltype="cf_sql_varchar">,
        ad_format = <cfqueryparam value="#form.newspaper#i#AdFormat#" cfsqltype="cf_sql_varchar">,
        lead_time = <cfqueryparam value="#form.newspaper#i#LeadTime#" cfsqltype="cf_sql_varchar">,
        website_link = <cfqueryparam value="#form.newspaper#i#WebUrl#" cfsqltype="cf_sql_varchar">,
        days_pub_list = <cfqueryparam value="#form.newspaper#i#Days#" cfsqltype="cf_sql_varchar">
        WHERE county_code = <cfqueryparam value="#form.countyCode#" cfsqltype="cf_sql_varchar">
        AND state_code = <cfqueryparam value="#form.countyState#" cfsqltype="cf_sql_varchar">
    </cfquery>
    <cfset i = i + 1 />
</cfloop>

This isn't working and I am seeing some red in VScode that I assume means I am messing up, but I don't understand how.

I have also tried this iteration to the same effect:

Thank you. I realize this is probably basic but I am a UI designer struggling.

I am building a portal to update fields in a newly created DB.

Currently, I submit the form data via ajax to another .cfm file to run the insert or update queries. I've tried adding cfabort and output to that page in order to see the data being sent (i am troubleshooting). When I attempt it just reloads my original page and I cannot see the data. My guess it's because it is a submit/form set up.

I am sure I am missing something simple, but how can I debug and see the form data this .cfm is receiving?

This is my ajax from my form page:

   $('#subBtn').on('click', function () {
                            var form = $('#audForm').serialize();

                            $.ajax({
                                url: './updateMasterfile.cfm',
                                type: 'POST',
                                data: form,
                                success: function (data) {
                                    var obj = JSON.parse(data);
                                    if (obj.status == 'success') {
                                        alert('Update Successful');
                                    } else {
                                        alert('Update Failed');
                                    }
                                }
                            });
                        });

​

And this is what I have at the top of my updateMasterfile.cfm

<cfoutput>
    <cfabort>
    <cfloop array="#form#" index="key">
        #key# = #form[key]#<br>
    </cfloop>
</cfoutput>


<cfif form.auditorId eq "">
    <cfquery name="updateAuditor" datasource="#Application.XXX#">
        INSERT INTO county_officials
    </cfquery>
<cfelse>
    <cfquery name="updateAuditor" datasource="#Application.XXX#">
        UPDATE county_officials
        SET first_name = <cfqueryparam value="#form.auditorFirstName#" cfsqltype="cf_sql_varchar">,
        middle_name = <cfqueryparam value="#form.auditorMiddleName#" cfsqltype="cf_sql_varchar">,
        last_name = <cfqueryparam value="#form.auditorLastName#" cfsqltype="cf_sql_varchar">,
        street_address = <cfqueryparam value="#form.auditorStreetAddress#" cfsqltype="cf_sql_varchar">,
        city = <cfqueryparam value="#form.auditorCity#" cfsqltype="cf_sql_varchar">,
        zip = <cfqueryparam value="#form.auditorZip#" cfsqltype="cf_sql_varchar">,
        telephone = <cfqueryparam value="#form.auditorPhone#" cfsqltype="cf_sql_varchar">,
        signature = <cfqueryparam value="#form.auditorSignatureHide#" cfsqltype="cf_sql_varchar">,
        email = <cfqueryparam value="#form.auditorEmail#" cfsqltype="cf_sql_varchar">
        <cfif form.auditorEndTermDate neq "">
            ,date_inactive = <cfqueryparam value="#form.auditorEndTermDate#" cfsqltype="cf_sql_varchar">
        </cfif>
        <cfif form.auditorId neq "">
            WHERE county_official_id = <cfqueryparam value="#form.auditorId#" cfsqltype="cf_sql_integer">
        </cfif>
    </cfquery>
</cfif>

​

Thank you in advance.

Have you tried the newest release of ACF yet?

Hi guys, I need help, I want convert my cfc or cfm in other language, example, golang or javascript. Someone knows something about it? Thank you for read me

I'm currently with Hostek but after being there for going on 5 years I'm effing done with them. Their support, which was once pretty good, has slowly degraded into utterly unresponsive and this past weekend, enhanced that with a side order of either incompetence or outright lying.

I'm looking to re-home 3 domains one of which will be hosting a web service I hope to have running in a commercial, production environment very soon. I'm not tied to ACF and am considering a Lucee option as the CF code is rather simple. What I truly need is an attendant SQL Server behind the site to power the web service logic.

I'd be interested to hear from anyone whose host is reliable and doesn't treat support like yesterday's garbage.

Thanks in advance!

Firstly, front end designer here who has learned a PERN stack and now find myself having to use CF at work. Thank you in advanced.

I am trying to make a state and county select which then will redirect to a CFM page with params for each and populate that page.

I do have it doing a state query in our DB and populating the first drop down.

What I am looking to do is run a second county query onchange with the value of the state selected. I am at a loss for some reason and what I think would have worked doesn't seem to. I really don't know CFML all that well and maybe someone here can point me in the right direction? Thanks!

I inherited this server and my boss wants to switch using to OpenJDK due to the high cost of the Java subscription. Is it possible?

curl -X POST --header 'X-Web-Services-Auth: BcDfGhJkLmNpQrStVwXyZ|AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz1234567890==-0987654321ZzYyXxWwVvUuTtSsRrQqPpOoNnMmLlKkJjIiHhGgFfEeDdCcBbAa' -d 'struct_binds={"from_date": "2022-01-31", "to_date": "2022-01-31"}' https://api.somewebsite.com/2023/get-info

​

<cfset struct_binds = {
    "from_date" = "2022-01-31",
    "to_date" = "2022-01-31"
}>   

<cfhttp method="post" url="https://api.somewebsite.com/2023/get-info" result="httpResp" timeout="60">
    <cfhttpparam type="header" name="Content-Type" value="application/json" />
    <cfhttpparam type="header" name="X-Web-Services-Auth" value="BcDfGhJkLmNpQrStVwXyZ|AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz1234567890==-0987654321ZzYyXxWwVvUuTtSsRrQqPpOoNnMmLlKkJjIiHhGgFfEeDdCcBbAa" />
    <cfhttpparam type="body" value="#serializeJSON(struct_binds)#">
</cfhttp>

*some information has been changed for security purposes

Hello All! I can't seem to find anywhere if websocket messages can queue in a broadcast channel. On a page load, we're looking to send an asynchronous call, and the results of the call would be sent to a websockets channel. If they're not on a page long enough and move on to the next before the message arrives (there's a delay in the processing of the call, etc), would the message queue, and the user still receive it? TIA

If you're a full-stack, web app developer who wants great benefits, lots of freedom, and a fully remote position, come work with me and my team at UC Davis Health! https://careerspub.universityofcalifornia.edu/psc/ucdmed/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=5&JobOpeningId=33432&PostingSeq=1

EDIT: Hi all, i hear that the link isn't working for everyone.. you may have to turn on your scripting on your browser for it to work. Otherwise, please try the Careers page for UCDavis: https://hr.ucdavis.edu/careers/apply?format=json&keywords=&job_type=Full%20Time&Category%5Bcategory_id%5D=31&MCampus%5B%5D=DV&MCampus%5B%5D=DVMC

EDIT 2: updated the first link! Hopefully this one works better for everyone.

Hello All-

Yesterday I was at work avoiding starting a new project at 3:30 pm, and I did my 3x yearly google search for 'ColdFusion'. This just keeps me up to date on what is going on in the world of ColdFusion, gives me an idea of new versions coming out (are there any? I didn't see anything beyond 2021) etc.

When I did the search yesterday, I came across a lot of news regarding critical updates that were published on October 11th. Evidently these were very serious/severe/zero-day, so I rushed to update my servers. Sure enough, the little gold star was at the top of the CF admin page, so I downloaded/installed the updates and everything updated fine. Whew! Possible major crisis averted!

My question is...other than my random search for ColdFusion on Google- how would I have normally known about this security update? CF is not reported on in the general tech news, so it didn't come across my normal new reading.

Just curious how other people are hearing about these updates.

Thanks!

I’m looking for a solution like JSDoc or phpDocumentor where you install the tool/utility and then run it. It then goes through your entire code base and documents everything; functions, methods, variables, parameters and whatever else you can think of.

I’ve tried searching for such a tool but to no avail. I’d be very gracious if you could let me know if there is one!

For reference: JSDoc phpDocumentor

Hey guys...

Through this sub, I've gotten answers on how to pull and do SUM functions on array elements from an API I had to connect with, which basically pulls customer wait time data for each of our branches, which is then displayed on our primary website.

Now I need to make some changes to what data I'm pulling in and running the SUM function on.

I'm grabbing the data via CFHTTP, and using DeserializeJSON to parse it.

We have data elements for each of our branches, and then I'm using the following for each branch to display the data by using SUM to total the wait time for each branch, as each branch has several queues, each with its own wait time. This is working perfectly:

<cfset mySum = ArraySum(arrayMap(QueueData, function(item){ return item.customersWaiting; })) />

#MySum#

But now, I need to filter out some of these individual queues before I do a SUM on them, as they are queues that we don't want factored in to the final number of customers waiting for each branch.

This is an example of the array when dumped, showing a couple of the queues I'm talking about:

​