After much angst, guessing, and internet searches, I finally have a scheduled task running that gets email, processes it, and deletes it from the mail server using MS Graph, Azure, and OAuth. Thank you to anyone who provided any kind of assistance and if anyone is struggling to do the same thing, please feel free to reach out.

Lucee 6 BETA 2 is out !https://dev.lucee.org/t/lucee-6-0-451-beta-2/12673

can i do this in cfstoredproc

<cfif isDefined('title')><cfprocparam type="IN" cfsqltype="VARCHAR" dbvarname="@title" value="#arguments.title#" null="#!len(arguments.title)#"><cfelse>null</cfif>

args = {};

args.amount = 230*100;

writedump(serializeJSON(args));abort;

Gives the result: {"amount":23000.0} WTF?! Why the trailing .0? The only solution I came up with is:

args.amount = javaCast("int", 230*100);

Is there a better way? This is in ACF2023, in ACF2016 it worked as expected.

Another CF2023 bug from what I can tell. "*Preserve case for Struct keys for Serialization" ignores local scope. I have it turned on, in ACF2023, this code:*

local.body = {};
local.body.amount = 2000;
writedump(serializeJSON(local.body));abort;

Produces: {"AMOUNT":2000} It should be lowercase for AMOUNT. In ACF2016, it correctly outputs: {"amount":2000}

@Mark Takata (Adobe) I want to give you my money, but these simple bugs being introduced are crazy.

I am trying to add a Apache Derby to the cf admin using commanndBox, and I get this error - Connection verification failed for data source: derby java.sql.SQLException: Timed out trying to establish connection How can I found out why this is happening? I installed Derby using cfpm so I don't understand the error. This application is for the cf specialist exercises

I haven't given anyone a gold star for a while. This time it's going to @zackster for being a star when it comes to all the hard work he's putting into the Lucee 6 release & especially taking time to assess & discuss individual issues I have raised. ⭐

@abram could you pls punt CF2018 on trycf.com?

This message was deleted.

Basic question about scheduled tasks. If the ColdFusion server is stopped for say 2 hours, when it starts back up, do all scheduled tasks that would have run during that time run "immediately"?

Sorry not sure if there was a dedicated fusebox slack channel so posted here. Apologies in advance! I am having an issue trying to call a case statement that resides in the same cfm file from a cfmodule. This is my code - or more like legacy code I inherited. At the moment the cfmodule part of the code is resulting in a 500 error. I believe that the cfmodule is attempting to call the case statement below called "thevaldetls" but the cfmodule call is bringing about the error because I think it's not correctly syntaxed or the fusebox.rootpath is incorrect. Am I missing something? I can't work out how else to modify the code so it calls the current fuse action below. Any ideas anyone ? Thanks in advance!

<cfif fusebox.iscustomtag is "false">

<cfmodule template="#fusebox.rootpath#/index.cfm" fuseaction="api.thevaldetls" account="#attributes.account#" orderid="#attributes.order#" validID="#attributes.validID#" apicall="true"> <cfelse> <!--- pass the details back to the web front end call ---> <cfset caller.attributes.theorder=attributes.theorder> <cfset caller.attributes.validID=attributes.validID> </cfif> </cfif> </cfcase> <cfcase value="thevaldetls"> Need to get here </cfcase>

sorry should mention that the folder structure is api and this file is the fbx_Switch.cfm in taht directory so \api\fbx_Switch.cfm

Seems it's my day for basic questions. Can someone please point me to basic and complete steps to send an SMS message and tell if it succeeded using CF 2018? I don't need to monitor incoming messages. Possibly lame specifics: • Is an external SMS service required (ex Twilio)? • Where should I be looking for this info besides here?

I am trying to move a site that was on CF11 to CF2021 and there is an issue with moving the POI portion which creates excel files to CF2021. The first thing I did look for is to find the version of POI on CF11 (which is 3.12) and the version of POI on CF2021 (Which is 3.17). The code that is giving me trouble revolves around coloring the foreground of cells. First the workbook is created:

<cfset wb = createObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").init()/>

<cfset fontRedUnderlineBold = wb.createFont()>

<cfset fontRedUnderlineBold.setColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$RED").getIndex())>

<cfset fontRedUnderlineBold.setUnderline(1)>

<cfset fontRedUnderlineBold.setBold(true)>

<cfset cellStyleCurrency = wb.createCellStyle()/>

<cfset cellStyleCurrency.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("($##,####0.00_);[Red]($##,####0.00)"))/>

<cfset cellStyleNumeric = wb.createCellStyle()/>

<cfset cellStyleNumeric.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("##,####0.00"))/>

<cfset cellStyleBGYellow = wb.createCellStyle()/>

<cfset cellStyleBGYellow.setFillForegroundColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$LIGHT_YELLOW").getIndex())/>

<cfset cellStyleBGYellow.setFillPattern(cellStyleBGYellow.SOLID_FOREGROUND)/>

The code above works just fine until we get to the last line which used to set the foreground. When this is run this error appears: Element SOLID_FOREGROUND is undefined in CELLSTYLEBGYELLOW. So, this used to work in 3.12 but now doesn't in 3.17. I have been trying to search on what has changed but so far have come up empy. Has anyone else experienced this?

@malllory.woods I've not had the issue but looks like this could work (https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/FillPatternType.html#SOLID_FOREGROUND)?

<cfset FillPatternType = createObject("java","<http://org.apache.poi.ss|org.apache.poi.ss>.usermodel.FillPatternType")/>

<cfset cellStyleBGYellow.setFillPattern(FillPatternType.SOLID_FOREGROUND)/>

Ian, I'll give it a go really quick.. Thanks

Awesome, that worked. I have one last portion that is not working

<cfset cellStyleCurrencyBottomBorder = wb.createCellStyle()/>

<cfset cellStyleCurrencyBottomBorder.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("($##,####0.00_);[Red]($##,####0.00)"))/>

<cfset cellStyleCurrencyBottomBorder.setBorderBottom(cellStyleCurrencyBottomBorder.BORDER_THIN)/>

But, I wanted to ask how to read this so I can figure it out in the future: I know I am looking in the usermodel class am I looking for the function getbuiltinformat? Just trying to see if I can understand what's going on here. Thanks

please use threads!!!!

Does anybody understand Solr searching in ColdFusion that could do a meeting on it for the Hawaii ColdFusion User Group in July?

Nice - I'd love to attend such a presentation!

Does anybody know how to start solr on macOS, I thought that it ran out of the box, but I get an error saying that solr is not running. I tried this create.cfm

<html>                                                                                                           <head>
 <title>Creating Solr Collection</title>
</head>
<body>
<!--- feedback --->
Creating collection ...<br>
<cfflush>

<!--- Create the new verity collection --->
<cfcollection action="create"
              collection="finance"
           path="/Applications/ColdFusion2023/cfusion/jetty/multicore">

<!--- feedback --->
Done!
<cfflush>

</body>
</html>

Good afternoon! Looking for some help/advice concerning a CF Websocket Global Heartbeat Issue i’m experiencing. Previous link leads to original post in #cfml-beginners channel. Thanks all!

figured I needed a better camera for CFCAMP https://twitter.com/zackster/status/1669070269124603905

Question regarding working with untrusted files - as I understand it, the basic flow would be to: 1. Upload to temp directory and rename with guid or other unique identifier 2. Use fileGetMimeType() to verify the file matches an approved list of file types 3. Move to final location (s3 in this case) if valid. 4. Delete if invalid Am I missing anything important?

Is there deeper documentation on the Azure Blob implementation for ACF 2021? All I can find is this article: https://helpx.adobe.com/coldfusion/using/integrate-coldfusion-azure-blob.html I need to know more about the optional arguments for blob uploads to set the mime type and permissions but this article keeps it too simple.

Is anyone from solva.de here at slack? the cfml.de site that has an legacy forum is such a pitty, looked abandoned for many years and is having a 503 unavailable for months now. Any ideas to show some better content for that cfml domain?

CFCAMP rolll call, if your lucky enough to be coming, when do arrive?

Hello everyone, good afternoon, I'm Rafael, a junior dev in ColdFusion, and I'm currently working with the DocBox library... Does anyone know the correct syntax for applying the comments of a <cffunction> in the documentation? (being outside the <cfscript>)

In our move to Azure authentication we've lost some of our CGI variable values like REMOTE_USER. How do these get set under Azure on Windows/IIS?