Problems With Redirection And Sql Queries...
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
ADVERTISEMENT
URL Redirection
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.
Redirection
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 ?
Redirection Question...
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?
Redirection ASP Code
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 %>
Page Redirection
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"))...
Conditioned-redirection
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?
Redirection Question
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.
Browser Redirection
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 /.
404 Page Redirection
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?
Annoying Redirection
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:
Page Redirection
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 RelatedGet Original URL In Redirection
I 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 RelatedRedirection Limit
is 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 RelatedIIS Page Redirection For SSL
We 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.
Redirection Not Working
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:
Redirection On Button Click
i want to go to another page on button click is there any method other than form submission
View Replies View RelatedRadio Button Redirection
i 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?
VBscript Response Redirection
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 With Redirection In A Form...
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:
IIS Redirection - Like Ht.access For Apache?
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:
Redirection Based On Query Result...?
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 _________ ."
Queries
Normally I use Access database with ASP, and I create queries using the wizard which Access has. Then, I copy and paste the code in the ASP page and create my SQL.
I was wondering if it is easier to call the query directly with its name from Access, or else continue using the old procedure.
SQL Queries
I'm trying to build sql queries that will search through my DB. I am currently seperating my queries through multiple indexes in an array depending on whether or not the strings are wrapped in quotations.
I also want
Fluffy
Teddy
Bear
(three different LIKE statements)
3 Queries Or 1
I have the following page which I am using to select 3 diffrent queries but i was wondering if i could just use one SQL statement instead of 3? Code:
View Replies View RelatedOn The Fly Queries?
Say I have 5 fields in a form. I have figured out how to query a database using all 5 fields and display the records that match at least one of the fields.
I'm trying to figure out a way to, if say the user only fills in two fields, to only search the database for matching records based on just the two fields. As I have it now, the database is searched for the two fields they entered as well as three fields of "", which I would rather not have. Is this possible?
Sum() In SQL-queries
I have a DB. With 1 table called "products" and 3 product records. The 2 fields present in the table are called product_name and product_price. The names of the products are Product1, Product2 and Product3. They cost 13, 8 and 24. Which code (SQL and AP) would generate an output similar to this?
Total is: 45.
Product1 costs 13
Product2 costs 8
Product3 costs 24.
<%
SQL = "Select * FROM products" (plus some kind of sum function to calculate the total (to be able to display the sum before the various products) of the recordset without having to loop through the recordset first)
%>
Multiple Queries
I need to connect to 2 different databases in ASP and execute two different queries. Please let me know how to proceed. I understand that ADODB.Command option can connect to only one database at a time.
View Replies View RelatedStored Queries
I am running the following code to an access database
' Recordset Object
Dim rs
' connecting to database
con.Open connStr
' executing stored procedure
Set rs = con.Execute ("exec SpotDesc")
' showing all records
While Not rs.EOF
Response.Write rs(0) & " " & rs(1) & "<br>"
rs.MoveNext
Wend
' closing connection and freeing resources
con.Close
Set rs = Nothing
This works and runs the stored procedure SpotDesc.
One question I have is that this line brings back the results
Response.Write rs(0) & " " & rs(1) & "<br>"
but requires me to know how many colums are being returned, ie rs(0) is column 1 and rs(1) is column 2
Is there a way of writing this line and it places all the columns there wheter it be 1, 2, or 3?
Ie a way of know how many columns are returned...
Is there also a way to show the column heading?
Can ASP Use Access Queries?
I never ever thought about this, but recently I made a query in access so I
can make a customer mailing list based on relational information and it was
so easy to make the query and join tables and assign criterea using access.
And I haven't tried or thought about this cause in my own small asp projects
I've never used a dbase with queries in it, but after seeing how easy it
was, it would save a lot of time from manually writting queries in asp.
So, what I'm asking is if I can use a query from an mdb in asp just like I
can access tables?
Sql Problem With Sub Queries
This "query2" is used in an MS Access environment.
SELECT T_Perso.*, query1.*
FROM T_Perso LEFT JOIN query1 ON T_Perso.IdPerso = query1.IdPerso;
In SQL, "query1" is :
SELECT T_Items.*, T_Items.IdTypeItem
FROM T_Items
WHERE (((T_Items.IdTypeItem)="Inscription"));
I would like to translate "query2" in full SQL language in order to use it
in ASP but I have some problems with syntax and sub-queries.
I suppose it's quite easy but.I'm a newbie in SQL.
2 Queries And Then Compare Them?
Can I have one recordset execute a Select and then have another recordset execute a different Select, and then check if a field from the first recordset is different from the field in the 2nd recordset and if so write out that row on my displaying table?
View Replies View RelatedDynamic SQL Queries
I want to define search based on diffrent conditions.The user has the option to select any number of choices.i.e
Condition1.Age
Condituon2.Age & marks
Cindition3.Marks
How do I construct dynamis sql query?