Any reason to validate before the <cfquery> as some suggested or is it just
personal preference vs doing in the SQL statement?
** Purely personal, I just like my SQL to look clean. If you have to do this
for 30 fields, I'd write a quick function:
<cffunction name="CleanupVar" returntype="string">
<cfargument name="FormValue">
<cfif FormValue EQ "">
<cfset NewVal = "Null">
<cfreturn x>
</cffunction>
and then call it like
<cfquery...
UPDATE MyTable
SET MySmallDateTime = #CleanupVar(form.SmallDateTimeValue)#
I hope that makes sense.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
