David Rogers
06/12/2025, 9:34 PMDavid Rogers
06/12/2025, 9:35 PM// if buggy=true, lucee returns nothing from the query
function foo( required boolean buggy ) {
var q = queryExecute("
declare @foo table(x int);
insert into @foo (x) values (42)
select * from @foo;
", {}, buggy ? {result: "local.result"} : {});
writedump(local);
}
foo( buggy = true );bdw429s
06/12/2025, 9:36 PMbdw429s
06/12/2025, 9:36 PMbdw429s
06/12/2025, 9:37 PMq variable has the correct query in both cases?David Rogers
06/12/2025, 9:37 PMbdw429s
06/12/2025, 9:37 PMbdw429s
06/12/2025, 9:38 PMAll the <cfquery> tag attributes are supported, except the name attribute.
as the options struct.David Rogers
06/12/2025, 9:40 PMvar q = queryExecute("
select * from (select 1 x) x;
", {}, buggy ? {result: "local.result"} : {});bdw429s
06/12/2025, 9:41 PMbdw429s
06/12/2025, 9:42 PMDavid Rogers
06/12/2025, 10:11 PMjfrobishow
06/12/2025, 11:04 PMdswitzer
06/13/2025, 10:49 AM