Redirect According To IP In Database
I am looking for script that redirects the user to another page if their IP address is in the database. I'm not sure how to deal with the extra quote marks in the server variable and I get "expected end of statement."
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/STEM/Social/survey/survey.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT ipinput FROM soctable where " & " request.servervariable("remote_addr") = ipinput"
if rs.eof =false then
close rs
close conn
Response.Redirect ("results.asp")
else
close rs
close conn
end if
%>
View Replies
ADVERTISEMENT
I have a login pages right now that prompts the user for login and password and redirect the authenticated user to a URL (see code sample below).
Now instead of this I would like it to pick a URL (different for each user) listed in my access database (URLredirect) and redirect them to their personalized homepage. How can I solve this problem? Can anyone guide me in the right direction? Code:
View Replies
View Related
i got an error saying file not found 404 when redirect to html page
and i ensure that the file is found in the same directory and in the database :
response.redirect results("Url")
where Url is the column name in the database that contain the page name.
View Replies
View Related
I have a page where students can choose activities in a day... this then directs them to their timetable for that day.
However, if they go back to the choose.asp page and they have already registered, I redirect them to timetable.asp - because I don't want them to change their options.
I have their username stored as a session variable and it works fine for most students - however for the example student O'SMITH-JONESMark the page falls over.
I am using Dreamweaver's 'redirect if username exists' server behaviour. Code below... Can anyone tell me how to fix this so the code is not tripping up over the odd characters? Code:
View Replies
View Related
I am trying to use the following in an ASP page to redirect a user to a
non-anonymous FTP site:
response.redirect("ftp://myusername:mypassword@ftp.mysite.com")
but I keep getting a "permission denied" error. If I just put the same
address string in IE6's Address box and go to it, IE opens myusername's FTP
home page just fine, so I know the FTP site is working as expected. Also,
if I put in an anonymous ftp site, without the username and password (e.g.
"ftp://ftp.microsoft.com"), the redirect works fine, too.
I don't want the user to be prompted by IE for the username and password at
the FTP site, so I am providing them from within the web site.
What can be preventing the response.redirect from handling non-anonymous FTP
access? Is there a better way to do this?
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
When i call logout.asp, it deletes the session etc etc and then redirects to main.asp.
main.asp is the main content, which opens in the main frame of the frameset, which is named index.html.
How can i change the redirect....
Code:
Response.Redirect("main.asp")
...so that it loads the full index.html file once again, and not load the index.html frameset into the window.
would it be like this?....
Code:
Response.Redirect("index.html" target="_self")
?
View Replies
View Related
I was wondering if it is possible to redirect the user to a specific page he/she request without the use of hyperlinks. Im suppose to list all the options in a drop down list and upon selection, say the page is Modified PBT, the user will be able to view that particular page.
is it something like
If Request("Submit")="Submit" then
materialType = request.form("MaterialType")
if materialType = "ModifiedPBT" then
Response.redirect.....
......
View Replies
View Related
How do I redirect a page back to the orginal sending page. I have a script that checks to see if a user is logged in and if he. she isn't then it redirects them to a loging page, one login has been checked and process, how do I redirect them to the original page.
--
To reply, remove "TRASH" from email address
View Replies
View Related
I am working on a form that needs to be submitted to a different server. Apparently some firewalls alert the user that the system is sending data to a different server and this may not be wise. To avoid confusing users I though I could have a simple ASP script on the same server as the html form and it's only purpose would be to send the data to the other server and return a "success" message if it completed properly.
I have a deacent understanding of scripting, but using PHP, this will be my first real go with ASP.
View Replies
View Related
how can i redirect to a page, wait on that page for 5 seconds, then redirect
somewhere else
View Replies
View Related
I have written an Two ASP pages one is login.asp Another verify.asp
login.asp redirects the page to verify.asp .
The verify.asp has the following code
<%
Set objCom = Server.CreateObject("AgileAPI.Server")
objCom.SetLicenseKey "AFDGHDJLFLFMTTIGMVFK"
b = objCom.Connect("agility", 9017, -1)
b = objCom.Login(Request.Form("username"), Request.Form("password"), "agility", "D:COM", 9010, 16384)
Response.Write ("Connected to ADV 2006" & b)
%>
I have registered that dll using regsvr32.
But it status bar is see http:localhost estverify.asp and stops there
why its not redirecting or displaying the Response.write
View Replies
View Related
i'm trying to make an asp page to log out from a restricted part of the site, and i'd like it to say "you have been logged out" then redirect back to the login page after a 3 second delay. how can i do this with either java or vbscript?
View Replies
View Related
I have a friend who has a form that is submitted..
<form action="http://intranet/action.exe"....>
the problem is, that the server 'intranet' is server2003 and the .exe doesn't like that so much. so we would like to redirect http://intranet2/action.exe
is there a way anyone can think of , that won't require to much web tweaking. preferably a setting in iis that will redirect for just that one script.
View Replies
View Related
How do you redirect users to a page if their search criteria results in too
many records? I'm trying to speed up the searching process a bit. From what
I gather, you need to produce the recordset so you can assess if it's too
much or not. But if the recordset is there, why not show it? The work is
already done isn't it?I just ran a recordset of 80,000 results. I'd like to redirect at about
1,000 results.
View Replies
View Related
we use an ecommerce system who's webpage module template (which I'm customizing) is made in .asp extensions.
I have certain dead links that I want to 301 redirect. I do not want a global redirect.
The only code I find is this:
<%@ Language=VBScript %>
<%
Response.Status="301 Moved Permanently"
Response.AddHeader "Location", "http://www.new-url.com/"
%>
View Replies
View Related
How do I make a when a user does like a form like say register.aspx => complete.aspx
I tired countless amount of times like when I go to visit complete.aspx just incase someone happens to do it. I get errors about objects not there or something.
But i'd get it working and it redirects back to the page but the form won't submit doing CrossPage. But then i'd get the form working and not the redirection. I wish
I knew how to get it working. Sorry I don't have my code cause I got pissed and deleted it. Wasn't much to really save cause it was a sample to see if i can do it.
View Replies
View Related
I am wanting to create a redirector on my server so that if I type in
something like 'mysite.com/redirect/target' it would look into my database
and see entry for 'target' and forward to that url.
How do I do this? I put a default.asp file in my redirect url, however,
trying to hit redirect/target tries process that url rather than read the
default.asp and the first off to my target.
One way to do this would be to put redirect?target but from a mailshot this
isn't very nice.
View Replies
View Related
I would like to be able to redirect the customer to another page right after this 'Insert Statement'. Code:
View Replies
View Related
Was wondering if there's an ASP equivalent of the CFML CFLOCATION?
At present I'm using this :
<% Response.Write ("<HTML><head>")%>
<% Response.Write ("<META HTTP-EQUIV='Refresh' CONTENT='0';URL='prizes.asp'>")%>
<% Response.Write ("</head></html>")%>
But it's not working - browser isn't redirecting to prizes.asp (which is in the same directory as the script with the code above).
What am I doing wrong? Is there another way I can take the user to prizes.asp?
View Replies
View Related
I also have a redirect piece at the end of the code that is not doing like I want it to do. If the refresh button is clicked or if someone is coming straight to my submission page, it automatically redirects to the confirmation page, which is not what I want. I only want the redirect to happen after a successful submission....
View Replies
View Related
The database I'm working with has these 2 fields:
- "CD", which stands for "Consolidated Design Number" (not Compact DISC)
and
- "URL", which is the full URL (http://...)
Users need to be able to type a CD number into a form text box and, upon submission, be redirected to a non-database-driven html index (home page) for all the info associated with that paricular CD. A drop-down might be simpler, but it would be way too long since there are many, many numbers.
Here's what I have. Can't seem to get it to work ....
View Replies
View Related
I have a log in system where each username has its own unique password.The site checks with my database that contains all usernames and passwords and if successful,takes the logged in user to a page called client.asp
The problem is,I want each user to be taken to their own page,not all to the same page. How do I "assign" a page to each username,so when that user logs in,it takes them to their specific page and not other peoples pages.I think the code that needs to be changed is:
Response.Redirect "client.asp"
But I do not know what to put in place of the "client.asp" that would make this work.
View Replies
View Related
This is an odd request but we need to redirect a dynamic url to another dynamic url: for example in need to redirect:
/display.asp?hs=n82black
to
/displaytest.asp?man=Nokia&hs=n82black
So as you can see it adds the man= function to the url .this is so i can then link Nokia and N82 black to the static url. PS I have helicon isapi if that will help.
View Replies
View Related
I thought I was doing this right but apparently I'm not as I keep getting an error " object required ". I am trying to redirect someone if a record set value is not equal to
something; here is what i have:
<%
If rsSec.Fields.Item("program").Value <"Employee" Then
Response.Redirect "accessdenied.asp"
End If
%>
What am I doing wrong here? I the query returns a result when I tested it out but the " object required " error keeps displaying.
View Replies
View Related
does anyone know how to redirect asp pages? on my first page, I have 2 radio buttons, depends on which button they click it takes the users to the appropriate page.
So, I am thinking to create a invisible page where it checks which button the user clicks and redirect to other page
View Replies
View Related
I have a asp script that takes a forms input and converts it to and html page, then sends the html page to me through email.
when the people click submit it just takes them to the script (formattedemail.asp) and its a blank page. how do i make it redirect them to like a thanks page after submitting?
View Replies
View Related
I have a page that has a submit button.
<form action="move.asp" method="GET">
<input type="submit" value="Query">
The form is sending values to the move.asp page. Which will in turn be inserted into a database. My questions is can I do the insert without having to go/see the another page.
For example. I click on the submit button, it adds the record and then goes back to the
original page.
View Replies
View Related
is it possable to redirect an ASP to a frame other then the main one. eg on login i want the links bar to change.
View Replies
View Related
I have a form (page1.asp) which will be submit to page2.asp for processing (insert statement). However, during the insert if the name and passport no exist, I want to redirect to error.asp. But in the error.asp, how can I say the name and passport no you are trying to enter exist? How can I send the name field and passport no field to error.asp ?
View Replies
View Related
I've looked all over and can't find a way to have someone go to the page they were trying to go to after they logged in. I have several pages that if they are not logged in direct them to a login page. After they login I want them to continue on to the page they were trying to go to.
View Replies
View Related
I have two parts of code in my page both surrounded with an IF irs possible to redirect another section within the same page e.g.
If dd = "" then
redirect to A
else
...............
end if
A
............
View Replies
View Related
