I have a quiz that writes the results to an Access db. When the user logs in, I want it to redirect them based on their score.
I want them to login and get directed to page 2. Page 2 queries the db based on the user/pass. If the quizcompleted=0, they get directed to the quiz.
If the quizcompleted=1, they get directed to a page that says "You've taken the quiz and your score was _________ ."
I have a search form that display result based on the user search criteria.
the result displayed through paging when the user select a specific product description to look at then go back
to the search result the user will lose it's place.
my question is:
How can I let the user search the database for all the products that I have then select a specific product to read the description of it
then be able to go back to the original search. I have the first part working fine but to be able to go back to the original search that I need your help. Code:
In my search application, user can type a number to search. I use LIKE in my
query.
If a query result generates over 10,000 recordsets, it may several minutes
to run.
Is there a way to only query certain recordset at a time?
I found in SQL you can use "TOP". Like select TOP 100.... it will return
only top 100 records.
Is there a way to query may be from 101 to 200 then from 201 to 300...
My query is like: Select * from Product where PartNumber like '%" PartNumber
"%'
Any idea is welcome.
I want to add two buttons to my page, which direct to and send query information to different result pages.
View Replies View RelatedI have a MS SQL database on a server which is [ublished on the web (ASP pages) I need to give the user a button to click on it and print a stored procedure based report. I dont know how to generate the report in ASP ?
View Replies View RelatedI am diong a query based on a username that is being passed over. here is what i have:
sqltext = "select from sage where username = request.form(username)"
i've tried variations of it and i keep getting error message. i have written so that it will pull everything the db, and that works. so i know that it has to be w/ this one portion. but i'm getting an error message.
I have a SQL DB with a number of tables and queries (views) in.
In front of this is my ASP app I am designing.
When my users log in, their User ID is stored in a session variable.
One of the views determines which User ID can access which records, and
obviously then I want to base all my app around this so that a user can only
ever be working on data relevant to them.
Is there any way of using a variable in my SQL View outside of DWMX so that
once my users log in, the SQL View is automatically filtered based on their
User ID in the session variable?
Is there a way of inserting a variable/parameter into SQL so this happens?
I want to do something which must be very simple. If I open default.asp, it creates my frameset and opens my home page. This is what I want to happen.
However, if I create an URL along the lines of
http://www.domain.com/default.asp?r..._page=page2.asp, then I want it to open
page2.asp, but still within the frameset.
Is this possible?
it is possible to compare the result of 2 recordset and
filter those similiar results,and display only the remaining results
I have a question on page redirection
A user login from a asp page (p1), it calls another asp page(p2) to do the validation, after successful. validation, it's forwarded to a welcom page(p3). How can I redirect back to the orginal page(p1) after certain time?
I used <meta http-equiv="refresh"; Content="3;
URL="<%=Request.ServerVariables("HTTP_REFERRER")%>">
but it seems redirect back to itself again and again.
I need a redirection help. I have a login page, upon validation, i need to redirect the page to a welcome page on another server. How would i do that.
Iam given to believe Response.Redirect or Server.Transfer shall work only across the same web server. How do i transfer to another server ?
I have a web page (let's call it main.aspx) that must only be accessible
thru another web page in my web application. Users should not be able to
browse directly to 'main.aspx'...they can only be redirected their from
another page on my site. How does one go about doing this?
the code below is from a results page. When clicking onto it, you are diverted to the description.asp page. Can it be changed so that any result which listed under a "Basic" AccessLEvel is redirected to the basic-description.asp?
<a href="description.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "SupplierName=" & rsSearchResults.Fields.Item("SupplierName").Value %>">More Details</a>
In basic terms, "If AccessLevel is "Basic" then redirect to basic-description.asp.
Keeping in mind that it needs to pass all the values that the code above passes.
I have also included some code for a previouse project.
<%If trim(rsSearchResults("AccessLevel")) <> "Basic" Then%>
<a href="description.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "SupplierName=" & rsSearchResults("SupplierName") %>">More Details</a>
<% end if %>
I am trying to redirect to another page by supplying a recordset data in the url...
I have tried this code but it doesnt work...
response.redirect("order.asp?OrderValue=" & myRS("orderNumber"))...
I need asp.net code for conditioned-redirection:
I have multiple domains pointing to one page , let's call it page0.aspx
I want to put a code in page0.aspx so
when domain1 opens page0.aspx it redirects it to page1.aspx
when domain2 opens page0.aspx it redirects it to page2.aspx
.... etc
Is there a code for that?
I have a page (located at mywebsite/a.asp) that redirects to another page
(theirwebsite/b.asp) located in other server. This other page probably will
redirect to another link again (othersite/c.asp) and finally display the web
page I want the user to see (finalwebsite/d.asp)
What I want to do is, once they click the link (b.asp) located in the a.asp
webpage, to load a "please wait" type of page, like Expedia does while
looking for information; and that "please wait" page should appear until the
redirection process gets to the final page (d.asp)
Since all the pages (after a.asp) are located outside our server (and we
can't access the code in those pages), how can I do that?!? Please be as
detailed as possible or point me where I can find info about how to do this.
I have created a repository for training and reference files. The management would like to see reports regarding who is using what files. To do that I am sending the user to a page (OpenDocument.asp) with the URL in the querystring (?URL=blabla.asp). A database is then opened so the rep is logged and then they are redirected to the URL in the querystring.
The problem- When the browser redirects through a querystring it substitutes / with %5C. Once that happens the relative links we have created for the images do not appear because they are looking for the last /.
I have a script which uses a custom 404 page to extract data from a database
and show users the correct content.
On our local development server the URL in the address bar shows as wanted:
http://www.domain.co.uk/aboutus.asp
Whereas on the remote live server the address bar shows:
http://www.domain.co.uk/error_pages...uk/about_us.asp
Why is this? Can anyone help?
So far I have the code below (and a little bit more) to redirect a user to a different page, that works well for just going to one page, but as you can see by choice number 4 , I wish to allow the user to go to two pages, one after the other.
All of the pages that it redirects to have forms on them so the user can enter there information into it. obvoiusly I only want the user going to pages that are appropriate for them. Code:
i have a website about searching products and get its information and online ordering, and for ordering products user must be registered and must give his/her ID PW to continue, the problem is that when user browse the products and then want to order this for ordering he give id pw but he redirect to his/her account page i want to redirect on the order page or page the user last left.
View Replies View RelatedI have ASP page redirect from a HTML page which is password protected by IIS auth.I would like to check whether the redirection is REALLY taken from the HTML page. Since the ASP page is located at second server, would there is a chance that ASP programming such as server object can check the original URL. Or any other method.
View Replies View Relatedis there any reason why i can view a page at work (which is on our server) yet when i view it online from the domain name (some pages are hosted, some are running off our server) i get the message: "Redirection limit for this URL exceeded. Unable to load the requested page. This may be caused by cookies that are blocked."
View Replies View RelatedWe have a web site running on our Windows 2003 server with IIS 6. We have installed a digital certificate for the web site and want all users to access the site using
https. Because of the diverse nature of our user base it would be difficult to advise users of the requirement to use https as opposed to http.
Is there an asp script we can use to automatically redirect all http: url requests to our https: url address. We tried an old .asp script we had from an older verison of IIS and it didn't work.
I made a lil program to where if a certain server is down i can redirect all the traffic to another server. I can goto this secure page, type in some info and it changes this one field
My thought is that this page (below) reads where the "place" is. If the thing it calls is a "1" than it will goto this page, and any other character will goto the other pages. The problem with this is for some reason the code isnt workign below.
I think i have all the logic. When i put all this info in the page and upload it just sits there. Am i missing something. All i want this page to do is look at database, check which value is in the page, and than it will redirect the people to the appriopate page Code:
i have been doing this asp page....but the page doesnt seem to work....it doesnt redirect as i wanted it to be...i dont get any erro message....so idont know wats wrong witht his code:
View Replies View Relatedi want to go to another page on button click is there any method other than form submission
View Replies View Relatedi have a search form and wanted to know if I can direct a user to another page when they click onto a radio button.Example:
I have the following two buttons. If a user clicks onto the "trade" button, it does nothing.If the user clicks onto the "wholesale" radio button, I would like it to direct the user to the "login.asp page.
<input type="radio" name="wholesale" value="wholesale">
<input type="radio" name="trade" value="trade">
Is this posible?
I try to use:
qs = Server.URLEncode(Request.Querystring)
session("fromURL") = request.ServerVariables("HTTP_REFERER")&
Server.HTMLEncode(qs)
on the login page
then on the next page
I use response.redirect session("fromURL")
the following extra characters got appended at the end of the URL
"auto%3Dtrue"
Does any one know what's wrong?
Problem: I'm using a Form and when Submitted, will display
a confirmation page. The confirmation page is simply a
Form with an OK button. I want the browser to display
either [1] the first form OR [2] to another page and I
couldn't do either. Code:
I have a bunch of old pages on my windows server that are still being occasionally visited (from bookmarks). I would like to clean up the web server and delete these pages/folders, but do not want people to get a 404.
With Apache, I would use an .htaccess redirect, but as this server is an IIS server (running asp/html pages), I'm at a loss. Code:
I have a database setup and the results come out as
Product 1: Shorts
Size: M
Price: £2.99
Product 2: T-Shirt
Size: XL
Price: £3.99
Total: "TOTAL HERE"
What I need to do is total these up
The Cells are called:
Product
Size
Price
I want to do some checking for my table for eg:
I want to check if the table for which year then if same year then do something.....
Does anyone know how i can make
[code]
Dim excl
excl = rs("price") / 1.175
[code]
return only a 2 decimal place number