Using DMX on IIS 5.0 in ASPVBScript to create dynamic pages. Here's what I want to do...my site is company intranet reporting site. I want users to be able to log in and then direct them to a dynamic page that would list the reports they have access to as hyperlinks. Security is not a big issue, more of a convenience thing and I don't want to have to create umpteen pages for each user. My thought was to store the username and pw in an access database on the server in one table and then have another table that lists the hyperlinks they have access to based on their user id. My question is, how would I go about doing this (or is their a better way)? One caveat...I would like to do this, or as much as possible, using DMX's built in tools or extensions as I am not up to speed on ASP code yet.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
sorry bloody IE just submitted
ok
INFOTABLE
id will be a Primary key
level from access
info1
info2
info3....... etc
the level accesss will be containedom in a session/cookie up 2 u
HOW IT WORKS
each usr has an level ie 4 level = company blah in level table
this user then can only access info from the info table where level = 4
simple.....
hope this helps
G
gabss - thanks for the reply. I think my question was vague...the part I'm struggling with is how to display the links to the reports dynamically based on the users login info (id or name). I've set up a login page connected to the db that works until I try to direct a sucessful login to an asp page that is looking for their user id (filtering the recordset by form function based on user id). I've added a dynamic table to the asp page to display their links but it is not working. The error code I'm getting is 80040e14, "The LEVEL clause includes a reserved word or argument that is misspelleed or missing, or the punctuation is incorrect".
You need a SQL statement. You get the user ID (if the user doesn't have an ID you should create an autonumber field) and use that to get the links.
Your database needs to be set up like this...
users table:
Username
UserID (autonumber)
Password
Links table:
UserID (so you can find the right links)
LinksID
LinkText
The SQL statement would be
Select * from Links WHERE UserID=" & userID you passed from the previous page.
Then you would only get the links that belonged to that user, and from there, it's just putting them all on the page using a loop.
There aren't going to be any canned DW helps to design the database, and without the right database design, you can't get what you need. ;-)
hello MilburnDrysdale ,
first modify the links table to be:
Link ID
UserID
Link Name
Link URL
u should use either sql or stored procedures to retrieve the links of every user id as what was mentioned above.
u have an option to store the links in the database as hyperlinks, or generate the links in the asp page.
then u output the <a tag with a href property and concatenate the returned links from the stored procedure like this:
loop no of links retrieved
for each link output the image tag like this:
response.write "<a href=http://"& linkURL & ">" & LinkName & "</a"
end loop.
hope this helps,
Regards,
kanary
Sorry for the delay in responding...today was first day I've had to work on this. Since the crux of my issue was trying to get the results to display as hyperlinks (as I commented above), I've split the points between kanary and SimonWGoldsmith since they addressed that issue which ultimately led to a solution.
Business Accounts
Answer for Membership
by: gabssPosted on 2003-07-10 at 09:03:09ID: 8894196
first you'll need a table in the DB of username PW ID and level
USERTABLE
id will be a Primary key
level is a FK = foreign key (from another table see below)
ACCESS TABLE
id will be a Primary key
level this is the same a level in user
info table