Mark,
What I would do is add a column in the table to store the identity of the
user who updates the relative row. When the user first accesses the site,
get them to log in and then you can hold an account, or you could just set
a cookie with a unique ID. Then when adding to the database just throw that
unique ID into the new column. If you set up an account with users details
on it you can put that in a different table which gives their unique ID as a
key so you'll be able to cross reference it later on.
Hope this helps
Taz
----- Original Message -----
From: "Mark Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 4:03 PM
Subject: Database Access
> I am designing a system where users log in to see data and can update add
> and delete the data. What I was wondering is whether or not it is
possible
> to tell which user id has edited the database. For instance, is it
possible
> for a user to access the database according to his/her user id and
password
> rather than using the default user id and password given by the coldfusion
> server. Or is it possible to write directly to the logs on the database
> itself with the user name and password of the user who has done the update
> etc.
>
> Any help will be greatly appreciated,
>
> Thanks in advance,
>
> Mark Jones
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
