Invalid keys detected in your query param struct:

[Adrian-Sanchez]

Error: Invalid keys detected in your query param struct: [NAME]. Usually this happens when you meant to serialize the struct to JSON first.

I understand the error has has to do with the attributes not matching up with the queryparam tag.

However, "name" is not a queryparam tag BUT name is the key used for named parameters.

.whereRaw(" someColumnName = :formval or someOtherColumnName = :formval",[ {name:'formval',value : rc.formval } ])

[elpete]

This has been fixed in 12.1.1. I’m very curious how you are using names parameters in qb. It’s not really set up for that.

…

-- Eric Peterson

On May 20, 2025 at 4:27:57 PM, Adrian-Sanchez ***@***.***) wrote: *Adrian-Sanchez* created an issue (coldbox-modules/qb#293) <#293> Error: Invalid keys detected in your query param struct: [NAME]. Usually this happens when you meant to serialize the struct to JSON first. I understand the error has has to do with the attributes not matching up with the queryparam tag. However, "name" is not a queryparam tag BUT name is the key used for named parameters. .whereRaw(" someColumnName = :formval or someOtherColumnName = :formval",[ {name:'formval',value : rc.formval } ]) — Reply to this email directly, view it on GitHub <#293>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AATWYXVGMAVEGMDCS6IWJ6T27OT63AVCNFSM6AAAAAB5RVM3IOVHI2DSMVQWIX3LMV43ASLTON2WKOZTGA3TQMZWGQ3DCNA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[Adrian-Sanchez]

@elpete I'm not sure what to say....somewhere in the past, i thought it was documented. I've got a report for example that has as much as 13 outer apply's but we only have to use a 3 named parameters. We use a lot of .selectRaw().fromRaw().whereRaw() methods so that we can easily copy them over back into SSMS quickly for tuning and optimizing.

.fromRaw("sometable s
	outer apply dbo.fn1(s.id, :Year,:Id) e
       ... 
	outer apply dbo.fn13(s.id, :Year,:Id) e