I have a report-like view that outputs data, most commonly grouped by some specific column. In that common case, the outer output tag is roughly <cfoutput query="#q#" group="someColumn"> and the inner one has no group attribute. Suppose there's a new flavor that doesn't group at all, just lists the records in some order. Far as I can see, that needs different code to do the rendering, since there's no way to say group="" or anything like that, and in any case, you'd need to only have one level of output tag, not two. So I need different output code, yes?

i was doing a car deployment which was successful except the scheduled 5tasks, that seems to be a bug. after my car file deployment, i did a CF 2021 update to #4 and it just removed all the car file datasources, and other settings any clue why it has donbe so

Just reading though one of the threads here where @bdw429s was helping someone for a long time, and it's probably overdue that I declare him to be a ⭐. (also amazed that not once did you mention CommandBox, which must be some sort of record 😛 ) Brad: yer a star.

Given the following code:

spreadsheet = New spreadsheetLibrary.Spreadsheet();
reportname = "report.xlsx";
spreadsheet.downloadFileFromQuery( data=qRecords, filename=reportname, xmlFormat=true, streamingXml=true );

using the Spreadsheet library (https://github.com/cfsimplicity/spreadsheet-cfml) with Lucee (latest) on ubuntu and getting the error: “The parameter [filename] to function [downloadFileFromQuery] is required but was not passed in”. The above code clearly is passing the filename argument. Am I missing something?

Hi All, found this slack

i am using cflap for authentication and i often see an error in my logs for the accounts logged, the accounts are correct and does not seems to be having any problem, but i constantly see the issue in logs as;

An error has occurred while trying to execute query :[LDAP: error code 49 - 80090308: LdapErr: DSID-0C090447, comment: AcceptSecurityContext error, data 52e, v3839 ].

This is the first time i see this error for cflap, any clues what is going on here

Hey there, was wondering if there's any way to create DSNs via a template, WITHOUT enabling RDS.

Hi all, I'm having a problem with sending a PDF file to a remote CFC. Here's the code snippet that converts the uploaded (on our end) PDF file to a base64 string.

var workplanFile = fileUpload(uploadDir , "workPlan_file" , "application/pdf", "MakeUnique", true);
var workPlanBinary = fileReadBinary("#workPlanFile.serverDirectory#/#workPlanFile.serverFile#");
var workPlanString = binaryEncode(workPlanBinary,'base64');

Then we send it to the remote cfc.

// construct the url and send data to the server
var uri = application.uri & "com/webservices.cfc?method=XXXX";
cfhttp(method="POST", charset="utf-8", url="#uri#", multipart="true", multiparttype="form-data", result="results") {
  cfhttpparam(name="Contact", type="formfield", value="#arguments.Contact#");
  cfhttpparam(name="Notes", type="formfield", value="#arguments.notes#");
  cfhttpparam(name="dataFileString", type="formfield", value="#workPlanString#");

} what comes back is an exception that's mostly escaped json, but I was able to extract a few things:

C:\ColdFusionBuilder2018\ColdFusion\cfusion\runtime\work\Catalina\localhost\tmp\ (The filename or extension is too long)

then later I found this:

The cause of this exception was: java.io.FileNotFoundException: C:\ColdFusionBuilder2018\ColdFusion\cfusion\runtime\work\Catalina\localhost\tmp\MaW5lYXJpemVkIDEv....
An error occurred when performing a file operation readBinary on file C:\ColdFusionBuilder2018\ColdFusion\cfusion\runtime\work\Catalina\localhost\tmp\LdbjOQ67m+....

With some further investigation, It would appear that in the remote CFC the line that's throwing the exception is this line:

binFile = FileReadBinary(arguments.dataFileString);

At this point I am not sure what the solution is. So any suggestions would be most appreciated. thx. larry

filereadbinary takes a physical path, not an encoded string, i think you just have a small mixup there

you probably want binaryDecode or toBinary or the like

thanks, I'll give that a try.

@websolete Many thanks. That worked. I had been beating my head against the keyboard over this. (Now to talk with the dev who wrote that - has anyone seen my cattle prod?)

The post limit settings on one of our production servers are postSizeLimit=100 and postParametersLimit=1500. Both seem pretty high to me on a gut level, but there are occasional "POST parameters exceeds the maximum limit" errors recorded by FusionReactor. What do folks think are reasonable limits for those? I'd guess super huge limits could crash the server with out of memory errors, but it's hard to quantify any of that, especially the max number of parameters. Thoughts?

Hey All.. I have been playing around with serverless cfml (based on the fuseless project) and wanted some constructive feedback on the structure of this small sample app.. it's intended to be super lightweight. I'm mainly wondering about the organisation of the components, naming conventions and if I'm instantiating the

services.utils

component in the Application.cfc in the most acceptable way.. and whether this pattern would be acceptable for the other components eg: main.cfc https://github.com/chapmandu/serverless-cfml/blob/master/functions/greeter/cfml/app/Application.cfc#L10

I just finished watching David Byers' (@pegarm) presentation on improving legacy code and am feeling just a tad cough overwhelmed because the code base I have to work on is all of those things he mentioned except for a dev/test/prod environment. So where does one start? I've been documenting things as I go along, but what's the low hanging fruit? Incorporating a code repository? A framework? Something else? I'm a dev team of one for now if that's a factor at all. Or doesn't it matter? Just pick one and go forth? And yes, I'm also a legacy developer. I learned CF the first time in 2000.

statistics question: can anyone point me in the direction, either a name or the formula itself, for determining the value of the following scenario: say you have four input values, they can be NULL or a number 1 - 10. i want to derive the 'significance' value of the total of those four numbers. for example, say you have the following values: NULL, NULL, 6, and 10. it's not an average of those four values, or the average of the two non-null values, but some result that takes the non-null values and applies the influence of the two NULL values. i'm sure there is a formula or approach for this, but i don't know the name of it or what to search for

like applying the percentage of how many null values to the sum/average/whatever of the non-null values

We have 1100 pdf files of various sizes and I need ColdFusion to look at each one to determine which ones meet a criteria. This page mentions Extracting data from a PDF form submission, but I need to extract data from a pdf file.

Oh wait a minute, I might have found it here: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfpdf.html

Good morning my guess would be you have something in your application.cfc that is running on request end or something i would try putting a cfabort immediately following your </cfoutput>

Hello all! I am trying to create a chart in an excel sheet using apache poi 4.1.2 on CF2018. I can not access the methods in the XDDFChart abstract class. When I try to call it from the XSSFChart class (which extends the XDDFChart), I get a method not found error. I can dump the contents of the XDDFChart and see all the methods from that class there, but I am not able to instantiate the XDDFChart as an object since it is an abstract class. Has anyone else had success building a chart in an excel spreadsheet, and/or had success calling any methods from any of the abstract classes that are extended in apache POI?

Hi, I am setting up a new site in IIS but my CSS,images and JS files are showing as internal server error in the console

anyone can guide what parameters i am missing here

anyone familiar with CFLDAP? I'm 99% there with all this https://github.com/lucee/Lucee/pull/1735

Looks like adobe has released their vscode extension today https://marketplace.visualstudio.com/items?itemName=com-adobe-coldfusion.adobe-cfml-lsp

what is the site which generates the cf code from curl

This seems like something that ought to be obvious from the documentation, but either I'm blind, or it's not there... What is the difference between

decodeFromURL

and

urlDecode

? I see that that latter optioanlly takes a character set, but is there any mor to it than that?

I've talked about parts of this before, with no real resolution, and it's still happening, so here I go again, thoughts are most welcome. Fairly often, when code gets promoted to production, one or both of two errors start happening on that server: • Element EXECUTIONMODE is undefined in THISTAG, in one particular template that's used a lot, and wasn't among the newly updated files • Multiple seemingly random pages that also weren't just updated start crashing because they can't find that same template Clearing the template cache fixes it. Has anyone else seen this? Any idea how to make it not happen?

im excited about the potential for documentation with this https://docusaurus.io has anyone used it before?