Redirecting - Help PLEASEEEEEEEE[:(]

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Redirecting - Help PLEASEEEEEEEE[:(]

Logged in as: Guest

arrSession:exec spGetSession 2,3,456

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Redirecting - Help PLEASEEEEEEEE[:(]
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Redirecting - Help PLEASEEEEEEEE[:(] - 10/29/2001 2:11:09 AM

punakutti

Posts: 2
Score: 0
Joined: 7/6/2001
From: India
Status: offline

I have a field by name yn in my access database.(Table name Admin)
Now my problem goes this way.
I have a link for my chat visitors to chat with me online. when they click it they are redirected to the chat page even when iam offline...
So I decided to add an yes/no field to the database which is stated above.
EG: I update the field yn to be no from the admin control then the user clicking the chat url should be redirected to the sendmail page automaticaly. and if my status in database says yes he should be redirected to the chat.asp page.
How do I do it?

meow

Post #: 1

Re: Redirecting - Help PLEASEEEEEEEE[:(] - 10/31/2001 3:16:29 PM

imav8n

Posts: 95
Score: 0
Joined: 7/3/2001
From: USA
Status: offline

something like this maybe:

<%
YesNo = Request.QueryString("yn")

If YesNo = "y" then
%>

<meta http-equiv=Refresh content="0;url=sendmail.asp">
<a href=sendmail.asp>If your screen does not automatically refresh, click here</a>

<%
else
%>
<meta http-equiv=Refresh content="0;url=chat.asp">
<a href=chat.asp>If your screen does not automatically refresh, click here</a>

<%
end if
%>

~imav8n
Failure is not an option.....it comes bundled with the software.

(in reply to punakutti)

Post #: 2

Re: Redirecting - Help PLEASEEEEEEEE[:(] - 11/3/2001 4:15:30 AM

punakutti

Posts: 2
Score: 0
Joined: 7/6/2001
From: India
Status: offline

I have sorted out the problem myself...
Any way thanks for taking tim to reply
Here is what I did...
<%
'I open my database here this is my file dsn
OpenDB con, "mydb"
'I select the status from the database I
'have used numbers here 1 = Available
'2 = not available
dup = "SELECT * FROM Admin WHERE status = '1'"
Set rs = con.Execute(dup)
If rs.EOF Then
response.redirect "mail.asp"
Else
response.redirect "../apcom_userchat.asp"
End If
%>

Thanks :)

meow

(in reply to punakutti)