<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