can anybody help on this......



i have one website for all my customers.

eg.

1 abc 

2. xyz 

3. pqr



i have given different user logins to these customers ...



i have kept data for these customers(data like word documents) in

different folders on the web server.



but some of the data i have to store it in a  remote database.  



so if a customer logs on .and if he request's for the data.

he will get only his data.



ie . if user(abc) has loged on he can view only his data.



question is...



how to write the query to get the data ,according to the user ????

Keep the information in the login table so you use that as the path.





>From: omkarj@h...

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] to write a query to get the data according to the 

>user logins.

>Date: Tue, 20 Feb 2001 08:32:56

>

>can anybody help on this......

>

>i have one website for all my customers.

>eg.

>1 abc

>2. xyz

>3. pqr

>

>i have given different user logins to these customers ...

>

>i have kept data for these customers(data like word documents) in

>different folders on the web server.

>

>but some of the data i have to store it in a  remote database.

>

>so if a customer logs on .and if he request's for the data.

>he will get only his data.

>

>ie . if user(abc) has loged on he can view only his data.

>

>question is...

>

>how to write the query to get the data ,according to the user ????

>

>

HI there,





You can try this way ----- create a table in the database where there are 

fields which give the path to their respective folders according to their 

userids and you can display this information on an asp page and send ur 

particular user to their particular folder





Hope this helps,



BHANU