<cfif #form.field# EQ #database.field#>
        <Perform normal functions>
<cfelse>
        <UPDATE SQL Statement>
</cfif>

---------- OR ----------

<cfif #form.field# NEQ #database.field#>
        <UPDATE SQL Statement>
</cfif>

============================================
Gary L. Alford
Supplier Product Assurance
Bell Helicopter Textron
Phone: (817) 280-6233
Fax: (817) 278-6233
mailto:[EMAIL PROTECTED]
============================================


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 9:19 AM
To: '[EMAIL PROTECTED]'
Subject: How to determine that a form field's value has been changed


Hi

I want to check a value of a form's text field and if it changed update a
databse. How to determine that the value has been changed?

Thanks,

Henry


-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

Reply via email to