Hello I m executing the query with incorrect decimal value 6 cfml #lucee

Hello. I'm executing the query with incorrect deci...

romanstr

05/31/2023, 8:56 AM

Hello. I'm executing the query with incorrect decimal value ("6 5") in Lucee 5.3.10.120.

Copy code

<cfquery name="qryUpdateFTs" datasource="#pvtDSNInnovare#">
    UPDATE Policys2PrFeesTaxes
    SET 
        CommissionGANB = <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="6 5" scale="2">
    WHERE 
        Policy2PrFeeTaxID=<cfqueryparam cfsqltype="CF_SQL_INTEGER" value="2">   
</cfquery>

In debug I see (and in database):

Copy code

UPDATE Policys2PrFeesTaxes
	SET 
		CommissionGANB = 45082
	WHERE 
		Policy2PrFeeTaxID=2

ACF gives error "*Invalid data 6 5 for CFSQLTYPE CF_SQL_DECIMAL."* Is it bug in Lucee? What's the conversion algorithm converts "6 5" to "45082". I see incorrect value "36865.00" in database and need to understand what user has entered.

zackster

05/31/2023, 8:58 AM

erghhh, file a bug https://trycf.com/gist/096d24d7c14c32fc3af3e2698d72a199/lucee5?theme=monokai

romanstr

05/31/2023, 9:05 AM

created ticket https://luceeserver.atlassian.net/browse/LDEV-4506

zackster

05/31/2023, 9:08 AM

thanks!

Adam Cameron

05/31/2023, 4:52 PM

I bet it's interpreting "6 5" as a date (Jun 5 1900?) and then covering that to a number of seconds.

Adam Cameron

05/31/2023, 4:52 PM

Might be garbage-in, garbage-out rather than a bug. Maybe.

zackster

05/31/2023, 4:58 PM

unusually, i'm totally happy with ACF behavior here

Adam Cameron

05/31/2023, 5:00 PM

7f5c53cd786df9677ec1342a8c6d768a yup. GIGO. Not a bug.

Adam Cameron

05/31/2023, 5:01 PM

Although it's crap that Lucee treats "6 5" as a date. It clearly isn't.

zackster

05/31/2023, 5:04 PM

lucee never claimed to be an incel 🙂

Adam Cameron

05/31/2023, 5:25 PM

OMG

Adam Cameron

05/31/2023, 5:25 PM

Hahaha

Adam Cameron

06/01/2023, 6:49 AM

Ugh. Didn't notice that only the guid for the trycf URL pasted y/day. https://trycf.com/scratch-pad/gist/7f5c53cd786df9677ec1342a8c6d768a

Copy code

x = "6 5"
y = x * 1
writeOutput(y & "<br>")
writeOutput(dateTimeFormat(y, "YYYY-mm-dd HH:nn:ss"))

Copy code

45082
2023-06-05 00:00:00

Open in Slack

Previous Next