Dave Merrill
07/22/2022, 3:24 PMgsr
07/22/2022, 6:07 PMAdam Cameron
davla
07/23/2022, 9:13 PMspreadsheet = 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?mk
07/25/2022, 7:48 PMmk
07/25/2022, 7:49 PMAn 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 herePaul Costello
07/25/2022, 9:09 PMlarryclyons
07/26/2022, 5:06 PMvar 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.
larrywebsolete
07/26/2022, 5:11 PMwebsolete
07/26/2022, 5:12 PMlarryclyons
07/26/2022, 5:13 PMlarryclyons
07/26/2022, 7:24 PMDave Merrill
07/26/2022, 7:48 PMchapmandu
07/27/2022, 7:27 AMservices.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#L10Brian
07/27/2022, 2:40 PMwebsolete
07/27/2022, 3:47 PMwebsolete
07/27/2022, 3:49 PMphillipsenn
07/27/2022, 4:16 PMphillipsenn
07/27/2022, 4:20 PMMichael Schmidt
07/28/2022, 12:44 PMzackster
07/29/2022, 10:21 AMjhyman
07/29/2022, 2:09 PMgsr
07/29/2022, 2:56 PMgsr
07/29/2022, 2:56 PMzackster
07/29/2022, 3:30 PMblusol
07/29/2022, 5:00 PMgsr
07/30/2022, 12:47 AMTim
08/01/2022, 8:14 PMdecodeFromURL
and urlDecode
? I see that that latter optioanlly takes a character set, but is there any mor to it than that?Dave Merrill
08/02/2022, 1:59 PMScott Steinbeck
08/02/2022, 7:15 PM