http://coldfusion.com logo
Join Slack
Powered by
It seems Lucee6 is handling the cfqueryparam null ...
# lucee
c
It seems Lucee6 is handling the cfqueryparam null attribute differently.. and I don't see any mention of it in the breaking change list.
Copy code
<cfquery datasource="mydsn">
UPDATE mytable
SET mycolumn = <cfqueryparam cfsqltype="cf_sql_integer" value="" null="true">
where id = 1;
</cfquery>
The code above now throws: Invalid data [''] for CFSQLTYPE in CFQUERYPARAM whereas Lucee5 would ignore the value if the null attribute is true.
b
That line of code was touched 23 months ago and appears to only exist on the 6.0 branch
Committed by @pothys-mitrahsoft
Seems like a bug to me-- the logic needs to take account of the 
null
attribute
Meaning, the value is discarded when 
null=true
so the validation check needs to be skipped in those cases
@chapmandu
c
No worries, I’ll log a ticket. Thanks Brad.
b
@chapmandu Hold on that. @zackster asked for 6.0 bugs to be triaged by the team first before logging bugs
@pothys-mitrahsoft may just want to adjust the test case and fix it as part of the existing ticket, which still hasn't technically been deployed yet.
👍 1
z
Just comment on the existing ticket
c
6 Views
Open in Slack
PreviousNext
Powered by