i am using this to add a check if the structfield ...
# cfml-generalg
gsr
04/20/2024, 11:43 AMi am using this to add a check if the structfield exists, then add else use null, it seems its still asking for name, do i need to add same type in the value
<cfqueryparam cfsqltype="varchar" value="#formfields.name#" null="#NOT (structKeyExists(formfields, 'name') and len(trim(formfields.name)))#">
a
aliaspooryorik
04/20/2024, 3:31 PM
Your logic is :
NOT (structKeyExists(formfields, 'name') and len(trim(formfields.name)))aliaspooryorik
04/20/2024, 3:32 PM
So it will be null if the key does not exist AND the value does not has len - both can not be true
aliaspooryorik
04/20/2024, 3:32 PM
I think you mean 'OR'
b
bkbk
04/22/2024, 11:43 AMApply the principle of "separation of concerns". For example:
<!--- Outside the cfquery tag ---><cfset nameFieldDoesNotExist = NOT structKeyExists(formfields, 'name') OR len(trim(formfields.name)) eq 0><cfqueryparam cfsqltype="varchar" value="#formfields.name#" null="#nameFieldDoesNotExist#">2 Views