After reading my answer, I realize the way I worded it may be
confusing. Here's an example.
On your form:
<input type="hidden" name="Val1_orig" value="#val1#">
<input type="text" name="Val1" value="#val1#">
On your processing page.
<cfif form.Val1 neq form.Val1_orig>
<!--- this element has been changed. --->
</cfif>
That's the basics of what I was trying to get at.
thanks,
eric cobb
ecar technologies, llc
http://www.cfgears.com
Eric Cobb wrote:
> The first thing that jumps out at me would be to have hidden form fields
> in the form that contain the original values. Then, when you're
> processing the form any value that doesn't match its corresponding
> hidden value has been changed.
>
> thanks,
>
> eric cobb
> ecar technologies, llc
> http://www.cfgears.com
>
>
>
> Blizzm wrote:
>
>> We have several lengthy forms that are going to be used for updating records
>> and various data. We are also looking at recording which form fields have
>> been updated. Is there a means for updating only those records which have
>> changed?
>>
>> I was thinking of looping through a form collection, comparing submitted vs.
>> existing database values, storing any changed values and then having a CFC
>> process the SQL update. If this is a good starting point, how would I be
>> able to update only those fields that need to be changed?
>>
>> For example if I have 100 fields and only 10 have been updated, how can I
>> write a query to update only those 10 fields?
>>
>> Thanks in advance.
>>
>>
>>
>>
>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331565
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
