Solved

Displaying links from table

Posted on 2007-03-20
11
136 Views
Last Modified: 2010-04-25
I have the following tables:
Category:
------------
ID              Cat
--------------------
1               cat1
2               cat2


Links:
---------
ID              Linkname                Url                        Cat                               Type
------------------------------------------------------------------------------------------------------------
1               L1                           http://u1               cat1                               images
2               L2                           http://u2               cat2                               videos
3               L3                           http://u3               cat1                               videos
4               L4                           http://u4               cat1                               images
5               L5                           http://u5               cat2                               images
.........................................................................................................................................

Now I want to display all the categories cat1, cat2 etc....like this:
cat1: images - videos
cat2: images - videos

if I click on 'images' in 'cat1: images - videos' it should list out all the urls from the 'links' table satisfying the condition cat='cat1' and type='images'. so far I had something like this:

<%=mRs("cat") & ":  " %><a href="showlink.asp?cat=<%=mRs("id")%>&tp=0" style="color:<%=sImg%>">images</a><span>&nbsp;</span><a href="showlink.asp?cat=<%=mRs("id")%>&tp=1" style="color:<%=sVid%>">videos</a><br>

now I want to achieve this without using 'Quesrysting'.

any help is appreciated.


0
Comment
Question by:CWS (haripriya)
  • 5
  • 4
  • 2
11 Comments
 
LVL 25

Accepted Solution

by:
kevp75 earned 250 total points
ID: 18756014
You can't unless you get something like:http://www.isapirewrite.com/

or you could make a custom error page, that will end up doing a redirect...however, you will still need to pass a querystring.  I am afraid a session variable/cookie is an even worse way to do it...

May I ask why you wouldn't want to pass a querystring?
0
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 18756050
the client feels, QuestionMark '?' results lower search rank and fails in search engines strategies. He is strictly against using querystring.
0
 
LVL 25

Expert Comment

by:kevp75
ID: 18756282
the best thing I can suggest to you then is to use the isapirewrite (link above)

all it does though is mask the URL that is displayed in the address bar of your browser.  Otherwise, you will need to keep your links the way they are...

and just for the record....your client is mistaken.  The QuestionMark would have effected search rankings a few years ago, but it is not that way anymore...
0
 
LVL 25

Assisted Solution

by:Rouchie
Rouchie earned 250 total points
ID: 18762613
Hi cyberwebservice

The technique you seek is called URL ReWriting.  Googling this term returns a lot of ways to potentially achieve what you need.  Apparently if you create a custom 404 page, you can access the page that the user attempted to access, I think by using Request.ServerVariables("HTTP_REFERER")

So you could output

   www.myserver.com/showlink.asp/7

The use the HTTP_REFERER in the 404 page to split the address into an array.  The ID parameter could then be accessed using the last member in the array.

There's some other approaches here...
http://forums.aspfree.com/code-bank-54/url-rewriting-with-asp-iis-102550.html
http://www.seoconsultants.com/articles/1000/urls.asp
http://www.motobit.com/help/url-replacer-rewriter/iis-mod-rewrite.asp
0
 
LVL 25

Expert Comment

by:kevp75
ID: 18763229
exactly...
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 18784599
hmm....thanx Rouchie and kevp75

I am still working on it....i don't know the head and tail of this...should I download some tools for ISAPI?

I don't know where to start this.
0
 
LVL 25

Expert Comment

by:kevp75
ID: 18785245
you could try that IsapiRewrite that I posted above, however I don't know what the limitations are of the trial version.

Your best bet may be to check out those other links above.  They will work you through setting up a custom error page...
0
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 18806224
Hi kevp75 and Rouchie,

I saw someother method in someother site for urlrewriting and I have adpted it, it works perfectly. Anyway without your help I would not have done this.
thanks and much appreciated :)
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 18806531
Hi cyberwebservice

Can you please post a link to the site you found the solution?  It will come in useful in the future for other people who stumble upon this post!

Thanks for the points.
-- R
0
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 18806594
yeah... Rouchie, I forgot the website link, anyway I will just google and send it.
0
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 18806633
here is the link:
http://blog.netnerds.net/2006/04/asp-mod_redirect-or-urlrewrite-with-classic-asp-sorta/

I just used the rewrite.asp part alone after setting the custom 404 error page.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stupid git question 2 62
Microsoft SQL ADO Conn Issue 6 40
Questions about INCLUDE FILES 2 20
CDO.Message not able to send attachement 5 14
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now