Issues
- Lucee 6 - cfqueryparam type="integer" list="true" blank value throwing error.LDEV-4802Resolved issue: LDEV-4802Pothys - MitrahSoft
- Timeout exception is not caught with cferrorLDEV-4311Michael Offner
- Long request and logs for error occured in cferror-templateLDEV-3756Michael Offner
- cferror type=validation is not implementedLDEV-3390Michael Offner
4 of 4
Lucee 6 - cfqueryparam type="integer" list="true" blank value throwing error.
Fixed
Description
Environment
AWS EC2 medium instance running Ubuntu 22.04.4
Details
Assignee
Pothys - MitrahSoftPothys - MitrahSoftReporter
Scott VanDusenScott VanDusenPriority
NewLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoft
Reporter
Scott VanDusen
Scott VanDusen
Priority
NewLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Affects versions
Created 28 February 2024 at 22:11
Updated 29 February 2024 at 07:13
Resolved 29 February 2024 at 07:13
Activity
Show:
Pothys - MitrahSoft29 February 2024 at 06:59
I have checked this ticket. According to the ACF performance, we have improved the Lucee cfqueryparam tag. When null=false, Lucee does not support empty values in Cfsqltype=integer. This is an expected behavior, not a bug. It is better to use null=true in cfqueryparam tag.
Related ticket :
Trycf :
We are trying to upgrade to Lucee 6 from Lucee 5.4.4.38 and while running our tests on beta we started getting the following error:
lucee.runtime.exp.CasterException: can't cast empty string to a number value
at lucee.runtime.op.Caster.toDoubleValue(Caster.java:508)
at lucee.runtime.op.Caster.toIntValue(Caster.java:823)
at lucee.runtime.op.Caster.toIntValue(Caster.java:774)
at lucee.runtime.op.Caster.toInteger(Caster.java:4719)
at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:212)
at lucee.runtime.type.QueryImpl.setItems(QueryImpl.java:587)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305)
at lucee.runtime.type.QueryImpl.(QueryImpl.java:243)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134)
at lucee.runtime.tag.Query._doEndTag(Query.java:701)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
This was not an issue on previous versions but on 6 it no longer allows a blank value to be passed into a cfqueryparam type=”integer” list=”true” value=””. I am wondering if this is the expected result or a bug since it didn’t work that way in previous versions.