I am looking for an ASP script that....

[JoeM6]

I have seen on many sites that have tons of links that instead of links, they just use an Id number. Example. Lets say i wanted to link to

http://www.somesite.com.

Instead of the url being

http://www.somesite.com,

i want it to be

http://www.mysite.com/redirect.asp?ID=123

Do you get what i mean? If not i can try and find a site with an example. Please reply a.s.a.p
Thanks

JoeM6
JPMJR11@aol.com

http://gamecentral.20m.com

 

[vasah20]

create a database table containing all the links to all the pages that you are linking to, then do a response.redirect.

ex:

tblLinks
id sitename
1

http://www.yahoo.com

2

http://www.google.com

3

http://www.mywebsite.com

4

http://www.othersite.com

this assumes c is an open connection
dim id, goto, r
id = Request.QueryString("ID&quot
r.Open "SELECT sitename FROM tblLinks WHERE id = " & id, c
goto = r("sitename&quot
r.close
set r = nothing

Response.redirect (goto)

that's the bare bones of it all, if you want you can increment a counter before redirecting, etc.

good luck
leo

 

[JoeM6]

Is that all ill need? Do i just place that in an asp page and make the database and im set or do i need more?

JoeM6
JPMJR11@aol.com

http://gamecentral.20m.com

 

[JoeM6]

Basically, all i need is what to put in the redir.asp page. I am really new at this

JoeM6
JPMJR11@aol.com

http://gamecentral.20m.com

 

[vasah20]

that's basically all you need.

you still need to set up the DB connection, though... check out faq333-178 for more info.

Something to note -
if Response.redirect doesn't work, you will need to add
Response.buffer = true

to the top of your ASP redirect page

good luck
leo

 

[JoeM6]

Ok, this isn't working for me at all. Can you make up the page for me or just tell me all the code here? If you do, I can place a link to your site in return. The database would be through Microsoft Access named links.mdb. Also, when i have the links with the id and everything, can that be on a html page or does it have to be an asp page?

JoeM6
JPMJR11@aol.com

http://gamecentral.20m.com

 

[krkX]

Or do something like this (a multi dim variable)

dim a(5)
a(0) = "

http://www.ibm.com"

a(1) = "

http://www.yahoo.com"

a(2) ......

response.redirect a(request("id&quot)


Thats all no database or whatever..

krkX

 

[JoeM6]

I wanted to use a databse though, IT would come in handy because i have many links...

JoeM6
JPMJR11@aol.com

http://gamecentral.20m.com