Hello, I am trying to setup a git repo for my business. anyone who is quite comfortable please guide me i want to test 3 environments, Dev/Test and prod test being as pre prod, while my intention is to use dev as building as testing and once the brach is complete on dev, i should be able to push it to test and once on test it is complete should i able to push it to prod how can i set it up, are there any videos/books which guide through this process. i am using jira+github for this. if there is anything i need to purchase, i can do that don't want everything automated but should be quite easy to handle

Whose doing Advent of Code? starts this week.

query question, if you wanted to turn a query result into an array of structs after getting the results back as a query object, how would you do it? the data would then be serialized for use with javascript, if there happens to be a simple action that combines both steps

Incase anyone has older versions of ColdFusion - CF9, 10, 11 or CF2016 and would like to upgrade to CF21 - we're running a special promotion, so you can get 25% off the full price of CF. Normally it's only possible to get a discount if you're upgrading from the previous version (CF2018) - here is a link if anyone is interested - https://www.fusion-reactor.com/blog/news/coldfusion-hot-sale/

thoughts? https://dev.lucee.org/t/ethics-of-posting-an-old-cf-custom-tag/11572

I spent many hours trying to fix my JKS keystore in CF2021 for WebSockets using keytool. Ended up the JRE needed upgraded. Oof. Just putting this out here in case anyone searches…

For Reasons, I want to create a second site, at a different URL, but pointing to the exact same code as an existing one. Not a copy, the same root directory. The only difference would be that code will check the host name and use a different database for the two hosts. This is on IIS running ACF 2021. Is this legit, or am I going to break the world if I try to set this up? You'd think I'd know this, but I've never actually done it.

i am going to ask a very old depreciated feature but i do not have a choice right now, so what i am doing is to use the cfinput type="text" and use the regexd validation to validate date like a us date or euro date but should be in dd/mm/yyyy or mm/dd/yyyy and the alert to be shown right after the input property changed just like onpropertychange but for all browsers this is a more kind of javascript code but devs already using cfinput

Can you create components on https://trycf.com/?

As longs as I've been working in CF, after <some event that happens sometimes>, CF throws this: "[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error". I think the trigger is something having restarted, probably CF. It's stable during normal operation, so this isn't super important, it just emails us devs, so I'm wondering if there's a way to avoid it. Ring any bells?

A JSON response contains the value

Wed Apr 14 2021 12:33:13 GMT+0200

and Lucee can't seem to parse it to a date using deserializeJSON() (while ACF2016 can). Any ideas on how to tackle this (was looking into https://www.petefreitag.com/item/569.cfm).

what is wrong in here https://trycf.com/gist/be3f8fed1d5d9c45aca1498f947556c5/lucee5?theme=monokai why its not going into the session.original code to count the session.orginal

Create a single CSV from multiple AND unmatched queries? (my use case is about 20 queries, with a combined distinct column count of over 30) Before I go and try and do it myself - I thought I would ask if there was a "magic" way to do the following already? At the moment I don't think I need any help in writing my own code - I am just asking if there is something that already exists to do it for me? ( • I have reviewed the CFSpreadsheet library from Julian Halliwell / @cfsimplicity - and from reading the docs, it doesn't look like it does what I need in a blackbox / auto-magic way. • I have also seen Ben Nadel's @ben queryToCSV() blog post - but I don't have a single query. ) Currently we have THIS in place and it is working; Looping through a list of customers Looping through a list of questionnaires Each questionnaire has a unique number of questions Each question has a specific return type. Using a UDF that takes into account a bunch of customer's reporting requirements / customisations THIS UDF returns the string of the required SQL to run Run the SQL created Create a CSV header row of columnNames Add the data from the query to the CSV Save a CSV for THIS questionnaire What we need to create, that we don't currently have working is; All the above - BUT ONE combined csv for all questionnaires. As way of illustration only - I have three different queries, for three different questionnaires. if a question exists in more than one questionnaire, it is ALWAYS the same text and ALWAYS the same data type. "question_1" exists in all three queries and is the same data type "question_2" is ONLY in query 1 (along with question_1) "question_3" is ONLY in query 2 (along with question_1) "question_4" is only from query 3 (along with question_1) What I am hoping to do is create one CSV with 4 columns in total. Where a column does NOT exist in a query, then that "cell" should be NULL. (Below; • "YES" - is just a placeholder for the example • There is only one row returned from each query in this example ) rowFromQuery question_1 question_2 question_3 question_4 1 "YES" "YES" NULL NULL 2 "YES" NULL "YES" NULL 3 "YES" NULL NULL "YES" We have re-arranged the looping, So that we can create a single header row of distinct columnNames (questions) successfully. We can add as many rows as their are results from all queries, into the CSV We have not yet, correctly managed to (is "*qualify"* the right term) the data So instead of what we want above, we end up with the following in a CSV question_1 question_2 question_3 question_4 "YES" "YES" "YES" "YES" "YES" "YES" Which is obviously wrong. Again - I am sure we can we can work on the code we have - and get it working correctly... But if something already exists - we would save some time, developing and testing. As always - Thanks!

Hi I am using cfdiv but it is having one impediment I am trying to use jquery ui sortable but it is not working in the file which is being used in cfdiv When I remove cfdiv tag and use cfinculde then it works Any work around for it becasue I want to use cfdiv

Good day. I have been tasked with implementing a SAML solution via CF. My production application servers are 2018 but I have access to an internal 2021 server ( with the new SAML tool ). Scenario: My org will be acting as the IDP and redirecting our users - which will be logged in via tradition login to our application - to a third party provider requiring SAML. The CF SAML docs appear to indicate that the process is initiated by calling an SSO url. I only need to send a SAML Response document to the SP. Can CF SAML generate a SAML Response document, which I can then post to the service provider, without the SSO workflow?

Afternoon all. Any ideas why the following post would work find in Postman but pasting that same json payload body into a cfhttp request fails? WORKS FINE

curl --location --request POST '<https://apis-sandbox.fedex.com/track/v1/trackingnumbers>' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer TOKEN_HERE' \
--data-raw '{
    "trackingInfo": [
        {
            "trackingNumberInfo": {
                "trackingNumber": "123456789012"
            }
        }
    ],
    "includeDetailedScans": true
}'

ERRORS OUT “422 Unprocessable Entity” with this error resp: {“transactionId”:“36d89e9d-dcef-480f-8abc-315f8e3aa5e3",“errors”[{“code”“INVALID.INPUT.EXCEPTION”,“message”:“Invalid field value in the input”}]}

http url="<https://apis-sandbox.fedex.com/track/v1/trackingnumbers>" method="POST" result="resp_track" {
	httpparam type="header" name="Content-Type" value="application/json";
	httpparam type="header" name="Authorization" value="Bearer TOKEN_HERE";
	httpparam name="body" value='{"trackingInfo":[{"trackingNumberInfo":{"trackingNumber":"123456789012"}}],"includeDetailedScans":true}';
}

what webkit rendering engine does CF use when using cfhtmltopdf?

is it wkhtmltopdf?

I am looking for a speaker for the Hawaii ColdFusion User Group to speak on the search abilities build into ColdFusion better know as Solr. If you have some experience with working with Solr, and would like to give this talk, please get a hold of me. Thanks!

Hi all, I completely revamped the CFBlogs ColdFusion Blog aggregator at https://www.gregoryalexander.com/cfblogs/. It takes data from up to 150 CF related sites, has up to a decade of data, and has search functionality along with various Kendo Grids to analyze posting trends. Please contact me if you want your blog added or have any feedback. Please see https://www.gregoryalexander.com/blog/2022/12/5/CFBlogsorg-20-Released for more information.

Anyone tried doing a maths expression parser with CFML? Found a JS library https://mathjs.org/ and a old Java one https://github.com/fasseg/exp4j. Knocked up a super simple CFML version (uses evaluate) but defence against arbitrary code execution is my main worry.

Hi Everyone, is there a better way - other than using evaluate(), to name a variable, with a dynamic portion?

<cfscript>
	myArray = ["myObj1", "myObj2", "myObj3"];

	myResultsArray = [];

	loop item="item" index="i" array=myArray {

		"myStruct#i#" = {};

		// run some function here for result Z. "item.someFunction()"
		z = "myVal_I_got_back";

		structInsert(evaluate("myStruct#i#"), "theZ", "#z#");
		structInsert(evaluate("myStruct#i#"), "someOtherStuff", "MoreStuff");

		arrayAppend(myResultsArray, evaluate("myStruct#i#"));
	}

	dump(myResultsArray);
</cfscript>

It works - but I would like to avoid

evaluate()

, if I can. Instead of

structInsert()

I tried

myStruct#i#.theZ =

myStruct#i#[thez] =

myStruct#i#["theZ"] =

myStruct#i#.[theZ] =

mystruct#i#.["theZ"] =

and also tried all of those again but quoting the start;

"myStruct#i#".theZ =

"myStruct#i#"[theZ] =

"mystruct#i#"...

And it kept complaining about using the "#" in the name portion... Thanks.

The latest update to CF2018 server is patch 15. Part of this release is introducing Strict Equality/In-Equality. Will the implementation of this impact the use of EQ/NEQ? Will code have to be refactored?

Anyone have success using ORM's EntityLoad function to load via uuid with postgreSQL? I'm trying to run something like

EntityLoad("table_name", {"id": "1ffb79e8-a8ca-4e1c-b4e3-422f9d22f6e8"})

but I consistently get stopped by ORM errors, mainly

ERROR: operator does not exist: uuid = character varying.

Doesn't seem to matter what type my entity model

id

is set to

I need to add second site to a production server running IIS and CF. Two questions. 1. In wsconfig.exe's Configured Web Sites dlg, if I just add the new site, without doing Remove All then Add All, will that interrupt traffic on the production site? I'm not there any more, but I think the binding is currently set up for All now, not individual sites. 2. Does the IIS site have to be running while I do this? It's currently not, since I'm not done setting it up.

Does anybody know how to install ColdFusion 2021 on Ubuntu Linux, I am lost. I could not find anything useful on Google.

Hi everyone, not sure if this has been asked before but here goes. When I create a PDF document using cfdocument it appears that the first page of the PDF has all text in BOLD. The other pages are in normal text. In most cases the text is from a loop of data so all the same code is being used. There appears to be NO way to prevent this as I have tried many things (ie. CSS, hard coding, etc.). I have CF2018 V15 but this problem has seem to be around for quite some time. Anyone know of a way to get around this or should I just use another html to PDF tool. I'm trying not to as my dev server is MAC and my production is Linux. Thanks for any help.

Hello. I'm working on a migration from ACF to Lucee. The app I'm testing uses SerializeXML which is not supported by Lucee. I've tried Lucee's Serialize now I'm overflowing the stack ugh. Any ideas? Thanks