hi
can someone please tell me how i can post to different users (in my website) the concerned data from the database

i would like the users to see the data in tables only.

suppose i hav ISBN, bookdesc,author,status,issued,reserve

n i want the data say ISBN,author,status, in a table to 10 different users

how can it be implemented.

thanking you
Satish

Can you be a little more specific with your question?

Do you want to duplicate the data into different tables (one for each user) in the database?
What do you mean by "post to different users"?

Peter
----------------------------------------
Work smarter, not harder.

hi

i should not duplicate the data.rather from my database i should retrieve the data into tables for different users.

thanking you
satish

Ok, so you mean you want to display data in an HTML table? You might need to be more specific when you use the term "tables" in a ASP database forum. I was confused as to whether you were referring to DB tables or output (HTML) tables.

You will need to select the pertinent data from your database, then construct the HTML for the table on the fly. How familiar are you with doing all this in ASP?

Peter
------------------------------------------------------
Work smarter, not harder.

hi peter

thanx very much for the reply.i am sorry for not making my problem clear .
i am a novice in ASP. i learnt how to create a html table n retrieve data in it dynamically using ASP. is that the same thing u meant by saying"construct the HTML for the table on the fly. "

if so how do i do it for each user? is it that i should query whoch is general to all using the session variable.


i mean SELECT * FROM TABLES WHERE userid=sessionvariable(userid) n sort them in html tables.
will this work out. i am sceptical if it will workout for each n every user.

thank u very much
satish

Do you have some mechanism to allow a user to choose what data they want to look at? Do you have some login process? Either way, as long as you have some unique user identifier you can then build an ASP page that will show only the data for that user.

I'm not sure what you mean by "sort them in html tables" but I think you are on the right track.

Create a SQL query that filters the data based on the user identifier (userid) then show that data in your dynamically constructed HTML table.

If you have more specific questions regarding how to manage state (remember what user is browsing the site) search around the forums and elsewhere online. There is a lot written about maintain state in ASP and building user authentication systems.

Peter
------------------------------------------------------
Work smarter, not harder.

thank u very much peter
satish