CWS (haripriya)
asked on
Displaying links from table
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%>">im ages</a><s pan> </span><a href="showlink.asp?cat=<%= mRs("id")% >&tp=1" style="color:<%=sVid%>">vi deos</a><b r>
now I want to achieve this without using 'Quesrysting'.
any help is appreciated.
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=<%=
now I want to achieve this without using 'Quesrysting'.
any help is appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
exactly...
ASKER
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.
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.
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...
Your best bet may be to check out those other links above. They will work you through setting up a custom error page...
ASKER
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 :)
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 :)
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
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
ASKER
yeah... Rouchie, I forgot the website link, anyway I will just google and send it.
ASKER
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.
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.
ASKER