Details
Assignee
Michael OffnerMichael OffnerReporter
Mihail AntiborMihail AntiborPriority
NewNew 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
Michael Offner
Michael OffnerReporter
Mihail Antibor
Mihail AntiborPriority
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 4 January 2021 at 13:23
Updated 19 November 2021 at 14:34
query fails when passing empty valueList() result to
cfqueryparam value type list.
query fails with "list of empty elements" in cfqueryparam
<cfquery name="get_data" datasource="sage" timeout="1">
SELECT
'' as info
UNION ALL
SELECT
'' as info
UNION ALL
SELECT
'' as info
</cfquery>
<cfdump var = "#valueList(get_data.info)#">
<cfquery result="q" datasource="sage" timeout="1">
select 1
WHERE
'1' IN ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#valueList(get_data.info)#" list="true" null="true"> )
</cfquery>