Brian
06/09/2023, 1:00 PMzackster
06/09/2023, 6:48 PMSimone
06/09/2023, 8:53 PM<cfif isDefined('title')><cfprocparam type="IN" cfsqltype="VARCHAR" dbvarname="@title" value="#arguments.title#" null="#!len(arguments.title)#"><cfelse>null</cfif>
davequested
06/11/2023, 9:44 PMargs = {};
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.davequested
06/11/2023, 10:57 PMlocal.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}davequested
06/11/2023, 10:59 PMjohnbarrett
06/11/2023, 11:47 PMAdam Cameron
Adam Cameron
Slackbot
06/12/2023, 3:00 PMDave Merrill
06/13/2023, 12:54 PMMauro caresimo
06/13/2023, 1:03 PM<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>Mauro caresimo
06/13/2023, 1:06 PMDave Merrill
06/13/2023, 2:38 PMmalllory.woods
06/13/2023, 2:53 PM<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?ian.hickey
06/13/2023, 3:05 PM<cfset FillPatternType = createObject("java","<http://org.apache.poi.ss|org.apache.poi.ss>.usermodel.FillPatternType")/>
<cfset cellStyleBGYellow.setFillPattern(FillPatternType.SOLID_FOREGROUND)/>
malllory.woods
06/13/2023, 3:18 PMmalllory.woods
06/13/2023, 4:15 PM<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. Thankszackster
06/13/2023, 4:23 PMjohnbarrett
06/14/2023, 12:14 AMgavinbaumanis
06/14/2023, 12:22 AMjohnbarrett
06/14/2023, 1:33 AM<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>
Jullian Rives
06/14/2023, 6:08 PMzackster
06/14/2023, 7:53 PMmjclemente
06/15/2023, 2:43 PMaaronstoddard
06/15/2023, 3:06 PMzackster
06/19/2023, 4:17 PMRafael Bossert Borring
06/19/2023, 4:19 PMBrian
06/20/2023, 2:10 PM