Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 5th, 2003, 05:48 AM
Registered User
 
Join Date: Nov 2003
Location: pune, maharastra, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to satishb
Default posting table data

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

Reply With Quote
  #2 (permalink)  
Old November 5th, 2003, 10:12 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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.
Reply With Quote
  #3 (permalink)  
Old November 6th, 2003, 01:28 AM
Registered User
 
Join Date: Nov 2003
Location: pune, maharastra, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to satishb
Default

hi

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

thanking you
satish

Reply With Quote
  #4 (permalink)  
Old November 6th, 2003, 11:24 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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.
Reply With Quote
  #5 (permalink)  
Old November 7th, 2003, 01:40 AM
Registered User
 
Join Date: Nov 2003
Location: pune, maharastra, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to satishb
Default

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

Reply With Quote
  #6 (permalink)  
Old November 7th, 2003, 10:05 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

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.
Reply With Quote
  #7 (permalink)  
Old November 11th, 2003, 07:32 AM
Registered User
 
Join Date: Nov 2003
Location: pune, maharastra, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to satishb
Default

thank u very much peter
satish

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Posting Data to a Website using Winforms c# jay69 C# 1 December 2nd, 2006 06:33 AM
Posting data from Control to Page bmains ASP.NET 2.0 Basics 1 December 6th, 2005 08:08 PM
ASP.NET not posting form data sqzgnlib ASP.NET 1.0 and 1.1 Basics 2 May 10th, 2005 09:59 AM
posting back javascript data badgolfer ASP.NET 1.0 and 1.1 Basics 2 September 26th, 2004 09:05 PM
posting data from JAVA GUI eforce Java GUI 0 July 16th, 2003 12:00 PM



All times are GMT -4. The time now is 01:04 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.