Henry,
When the form is submitted you need to run a query on the database to
retrieve the record that contains the value that originally populated
the text field. Then simply compare the two values, if there's a
difference you're good to go.
<cfquery name="qryCheck">
...
</cfquery>
<cfif Compare(qryCheck.fieldN, form.fieldN)>
<!---Compare returns 0 if the values are identical. The cfif will be
true if the values differ --->
<cfquery name="upt">
...
</cfquery>
</cfif>
On Thu, Jul 05, 2001 at 09:18:57AM -0500, [EMAIL PROTECTED] wrote:
> 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
--
Josh Meekhof
Sr. Software Engineer
Techniki Informatica / Network Staffing Services Inc.
(972) 233 1525
-------------------------------------------------------------------------
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
