dazed_o1o
|
| Posted: 07/18/2002, 12:32 PM |
|
Is there a way to write a date/timestamp to a MSSQL database when a record
is opened (not updated or added) using CCS/ASP w/templates?
Thanks
|
|
|
 |
donb
|
| Posted: 07/18/2002, 12:43 PM |
|
You'll have to change the source to be "procedure", then write a stored
procedure to do the SELECT (combining it with an UPDATE to change the
timestamp). You can return records from a stored procedure so it behaves as
if you opened a table (although the data will not be updatable).
You may have a very good reason for doing this, but it sounds like a poor
design. If this is a "audit trail" then you ought to consider writing to a
separate table that collects audit records. Continually updating the
primary table may present issues with locking/contention.
"dazed_o1o" <dazed_o1o@yahoo.com> wrote in message
news:ah753p$ik4$1@news.codecharge.com...
> Is there a way to write a date/timestamp to a MSSQL database when a record
> is opened (not updated or added) using CCS/ASP w/templates?
>
> Thanks
>
>
|
|
|
|
dazed_o1o
|
| Posted: 07/18/2002, 12:55 PM |
|
Thanks for the suggestion. I am new a newbie and did consider this issue.
"donb" <dbweb2@premiersi.com> wrote in message
news:ah75p2$jnk$1@news.codecharge.com...
> You'll have to change the source to be "procedure", then write a stored
> procedure to do the SELECT (combining it with an UPDATE to change the
> timestamp). You can return records from a stored procedure so it behaves
as
> if you opened a table (although the data will not be updatable).
>
> You may have a very good reason for doing this, but it sounds like a poor
> design. If this is a "audit trail" then you ought to consider writing to
a
> separate table that collects audit records. Continually updating the
> primary table may present issues with locking/contention.
>
>
> "dazed_o1o" <dazed_o1o@yahoo.com> wrote in message
>news:ah753p$ik4$1@news.codecharge.com...
> > Is there a way to write a date/timestamp to a MSSQL database when a
record
> > is opened (not updated or added) using CCS/ASP w/templates?
> >
> > Thanks
> >
> >
>
>
|
|
|
|
dazed_o1o
|
| Posted: 07/18/2002, 12:56 PM |
|
....did NOT consider this issue.
"dazed_o1o" <dazed_o1o@yahoo.com> wrote in message
news:ah76fs$l5j$1@news.codecharge.com...
> Thanks for the suggestion. I am new a newbie and did consider this issue.
>
> "donb" <dbweb2@premiersi.com> wrote in message
>news:ah75p2$jnk$1@news.codecharge.com...
> > You'll have to change the source to be "procedure", then write a stored
> > procedure to do the SELECT (combining it with an UPDATE to change the
> > timestamp). You can return records from a stored procedure so it
behaves
> as
> > if you opened a table (although the data will not be updatable).
> >
> > You may have a very good reason for doing this, but it sounds like a
poor
> > design. If this is a "audit trail" then you ought to consider writing
to
> a
> > separate table that collects audit records. Continually updating the
> > primary table may present issues with locking/contention.
> >
> >
> > "dazed_o1o" <dazed_o1o@yahoo.com> wrote in message
> >news:ah753p$ik4$1@news.codecharge.com...
> > > Is there a way to write a date/timestamp to a MSSQL database when a
> record
> > > is opened (not updated or added) using CCS/ASP w/templates?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>
|
|
|
|
|
