On Friday 26 May 2006 11:52, Michael E. Carluen wrote:
>
>
> SQL Update
>
If you follow the pattern of making a hidden field called
'hidden_old_value_X' then you can automate this check by looping over the
form scope and constucting the relavent key for the original value, thus:
htt
Oops...
Should be:
SQL Update
HTH...
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED]
Sent: Friday, May 26, 2006 3:52 AM
To: CF-Talk
Subject: RE: Only update DB if data has changed?
Andy,
I typically do this:
SQL Update
Hope
Andy,
I typically do this:
SQL Update
Hope that helps.
-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED]
Sent: Friday, May 26, 2006 2:25 AM
To: CF-Talk
Subject: Only update DB if data has changed?
Hi all, does anybody have any ideas how I could best
Message -
From: "Andy Mcshane" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, May 26, 2006 3:25 AM
Subject: Only update DB if data has changed?
> Hi all, does anybody have any ideas how I could best implement the
> following;
>
> I have a page that loa
gt;
To: "CF-Talk"
Sent: Friday, May 26, 2006 11:14 AM
Subject: RE: Only update DB if data has changed?
> Should be easy enough and no doubt several way s to achieve thisboth
> in
> CF Code and in SQL. One way would be to load the records at page load
> into
> a st
The problem is related to running too many queries which do an awful lot of
work in themselves and also the fact that the client refuses to have the option
of being able to edit each record individually.
>Is the problem you are trying to solve related to performance of running too
>many queries,
Is the problem you are trying to solve related to performance of running too
many queries, or from updating some sort of LastUpdated column
unnecessarily.
On 5/26/06, Andy Mcshane <[EMAIL PROTECTED]> wrote:
>
> Hi all, does anybody have any ideas how I could best implement the
> following;
>
> I h
cords at page
> load into
> >a structure and then on submit comparing both the pre-edited and post
> edited
> >form struct to see what has changed etc...
> >
> >
> >
> >-Original Message-
> >From: Andy Mcshane [mailto:[EMAIL PROTECTED]
> &
sage-
>From: Andy Mcshane [mailto:[EMAIL PROTECTED]
>Sent: 26 May 2006 10:25
>To: CF-Talk
>Subject: Only update DB if data has changed?
>
>Hi all, does anybody have any ideas how I could best implement the
>following;
>
>I have a page that loads anything up to about 30 i
-
From: Andy Mcshane [mailto:[EMAIL PROTECTED]
Sent: 26 May 2006 10:25
To: CF-Talk
Subject: Only update DB if data has changed?
Hi all, does anybody have any ideas how I could best implement the
following;
I have a page that loads anything up to about 30 individual records at a
time. Each
Hi all, does anybody have any ideas how I could best implement the following;
I have a page that loads anything up to about 30 individual records at a time.
Each record consists of 17 fields of data. All the records are displayed on the
page to give the user the option of editing any individual
11 matches
Mail list logo
