Trying to update multiple rows. If using this:
morder = '#evaluate("form.morder_#myIDX#")#'
..inside the query works fine, but what if the value isn't defined and I
need to set a null?
Here's what I'm using...
<cfloop index="myIDX" list="#FORM.THISid#">
<cfquery name="update">
UPDATE modules set
<cfif NOT IsDefined("FORM.mnote_#myIDX#") AND
#evaluate("form.mnote_#myIDX#")# EQ ''>
mnote = NULL
<cfelse>
mnote = #evaluate("form.mnote_#myIDX#")#
</cfif>
where ID = #myIDX#
</cfquery>
</cfloop>
--
Les Mizzell
-------------------------------------------------------
A vanta as márë órelyar! Nai eleni siluvar antalyannar!
-------------------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
