Why all this additional code?

[dlwkqd]

Hi,

To INSERT db2 data my code uses

<cfqueryparam

value="#UCASE(arguments.myData)#" cfsqltype="CF_SQL_CHAR" maxlength="40">,

however

#UCASEarguments.myData#)

is just as effective and the debugger shows the final code result instead of ? where it becomes necessary to match the arguments to get the final result.

What, if any, advantage does the cfqueryparam tag provide?

Can someone enlighten me pleasse?

Thank You in Advance.

[Adam Cameron. · Accepted solution]

Do you need more information than is already presented in the documentation?

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html

--

Adam

[dlwkqd]

Thanks Adam! That's what I needed know.