Forums

This topic is locked

Storing data from multiple customers

Posted 05 Jun 2001 11:32:26
1
has voted
05 Jun 2001 11:32:26 Jacques Roux posted:
We are developing a Web Site that will allow users to enter their employee records in to a database connected to our Web Site. Each user will have secure access to their own data through a username and password. They should also be able to update, delete and change data relevant to each employee's profile. In other words - how can a user access his own data in the database table after having entered his username and password and then work with the data? We are using Clarion to develop the database.

Replies

Replied 07 Jun 2001 12:44:34
07 Jun 2001 12:44:34 Waldo Smeets replied:
You should use a special field in your database that contains the id of the owner of that field. THen when a user logs in you can filter the table on the userId of the visitor. Then the recordset will only contain his own data.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Reply to this topic