Hey all,
anyone know of an easy way to set values of
form.fieldnames to null if they are blank
I'm trying to do it so null values instead of blanks are sent
to a storeproc.
Any help would be appreciated.
eg
<cfloop index="field" LIST="#FORM.fieldnames#">
<cfif Trim(evaluate(field)) eq "">
<cfset formVariable = "null">
</cfif>
</cfloop>
===========o00o== o_o ==o00o==============
Bert Herrera &
ITPAYSYOU.COM e-commerce facilitators
http://www.itpaysyou.com
"It's not what you do it's how and why"
===============o00O==O00o=================
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
