wrote:
>
> The project I'm working on requires Journaling, i.e., track changes made to
> the data.
>
> I'm hoping to do this as a blackbox. My beginning plan is to duplicate the
> query that loads the form to a session variable. Then, when the form
> submits, compare the sub
Larry,
I don't know if this interests you, but I have one case where I use a
database trigger (in SQL Server) to log ALL changes to the table.
Basically, an audit table is created that logs all the data changes ..
here's the trigger
It's quite generic, you just have to change the database name
Thanks.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Thursday, August 19, 2010 10:10 AM
To: cf-talk
Subject: Re: Journaling
#form[field]#
#query[column]#
But I think if I was in your shoes, I would be looking at a database solution.
Something
Thanks.
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: Thursday, August 19, 2010 10:07 AM
To: cf-talk
Subject: Re: Journaling
If you know the column names you just do form.columnName to get it. If you
don't know the column names you can dynamically co
#form[field]#
#query[column]#
But I think if I was in your shoes, I would be looking at a database
solution. Something done with triggers probably. Then it does not
matter what user interface is used to update the data. It will be
'journaled' as you put it.
~~~
- Original Message -
From: "Stephens, Larry V"
To: "cf-talk"
Sent: Thursday, August 19, 2010 7:02 AM
Subject: ***SPAM*** Journaling
>
> The project I'm working on requires Journaling, i.e., track changes made
> to the data.
>
> I'm
ry V wrote:
>
> The project I'm working on requires Journaling, i.e., track changes made to
> the data.
>
> I'm hoping to do this as a blackbox. My beginning plan is to duplicate the
> query that loads the form to a session variable. Then, when the form
> submits, c
The project I'm working on requires Journaling, i.e., track changes made to the
data.
I'm hoping to do this as a blackbox. My beginning plan is to duplicate the
query that loads the form to a session variable. Then, when the form submits,
compare the submitted data to the origina
8 matches
Mail list logo
