I have a line of Oracle pl/sql (9i) where I'm trying to add cfqueryparam in CF7.
I have:
#iif(len(trim(arguments.inStruct.a_person_id))eq
0,DE("NULL"),DE("#arguments.inStruct.a_person_id#"))#,
a coworker suggested:
<cfqueryparam value = "#arguments.inStruct.a_person_id#" CFSQLType =
"CF_SQL_NUMERIC" null="#IIF(len(arguments.inStruct.a_person_id),0,1)#">
But in reviewing it, I cannot tell if that is correct or not. I've gone over
the sql several times. Also, I don't know DE().
Any information on this is welcome. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352378
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
