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 original data
...@indiana.eduwrote:
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
cfdump var=#FORM#
cfdump var=#qName#
- Original Message -
From: Stephens, Larry V steph...@indiana.edu
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, August 19, 2010 7:02 AM
Subject: ***SPAM*** Journaling
The project I'm working on requires Journaling, i.e., track changes
cfloop collection=form item=field
cfoutput#form[field]#cfoutput
/cfloop
cfloop query=query
cfloop list=#query.columinlist# index=column
cfoutput#query[column]#/cfoutput
/cfloop
/cfloop
But I think if I was in your shoes, I would be looking at a database
solution. Something done with
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 compare
Thanks.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Thursday, August 19, 2010 10:10 AM
To: cf-talk
Subject: Re: Journaling
cfloop collection=form item=field cfoutput#form[field]#cfoutput
/cfloop
cfloop query=query
cfloop list=#query.columinlist# index
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
...@indiana.eduwrote:
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
8 matches
Mail list logo