> Update MyTable
> SET email = <cfif
Len(FORM.email)>'#FORM.email#'<cfelse>NULL</cfif>
> Where memberID = #FORM.memberID#
Looks good to me. Unless you want to use <cfqueryparam> -
http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
