I have a URL that passes on information for a database and looks like this www.domain.com/lead.asp?FirstName=test&LastName=test
I submit this to the domain and page listed above which then uses a 301 redirect to the page below. That page is www.secretdomain.com/nowprocesslead.asp.
My database entry pulls up blank using the the redirect page. Now if I submit the same url to the secret domain, everything passes just fine to the database.
Is there a way to pass the URL info through a redirect? I don't want people to see the second domain, just the first. Code:
I'm trying to retain a value that I pass to a processing page. When the page is done processing, I use the response.redirect to forward to the page I started on, and i want that page to hold the same category id that it started out on. I'm trying to pass with response.redirect using response.redirect "mypage.asp?number=" & number But it dons't seem to work. Why?
On this page, I have a form with a Select box for DistrictName. I would like to pass the selected value to the above query and use it as part of the WHERE clause. I know that is not a problem. I can do the following:
Select * from tblEmployee where DistrictName = '" & Request.Form("DistrictName") & '"
Here is the problem. One of the values in the Select box is "All Districts". How or what do i send to the query to pull employees for all districts?
I am running into an issue when I try to write more than 1024 characters to a memo field. Apparantly the odbc connection I am using does not permit literals to be larger that 1024 characters. This Memo filed can take virtually infinate data, so the solution seems to be use parameters. My problem is I have never heard of this and need this to work ASAP Does anyone have a simple example of how Parameters work using ASP
I am trying to pass a SQL query to the crystal report. The user typically selects some data from a form, and those values will make up the query through a request.form statement. The problem is the report is displaying all records. Code:
I am looking for some method to capture, into a variable, the entire URL of an http request and redirect to SSL. For example, if a user opens a browser and typed in
how do i pass form values through a redirect statement to another page. I have a redirect stt. Response.Redirect "exist.asp" and i want to pass form values to be displayed from exist.asp.
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?
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
In Access you use "*" + [passed variable] + "*", + can be replaced with & Calling a parameterized query in Access requires % be used in place of *, however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get matches at the end, not throughout the column. Code:
I need to click on a button and pass through a variable with a number associated to it to other form
That is. I know I can do something like this: <FORM action="http://somesite.com/prog/adduser" method="post"> <INPUT type="submit" value="Send"> <INPUT type="reset"> </FORM>but.. can I do something like this?<FORM action=http://somesite.com/prog/adduser?data=14 method="post"> <INPUT type="submit" value="Send"> <INPUT type="reset"> </FORM>
I have some code which I use server.Execute. In the included code for the server.execute, if I use a Request variable I get an error stating that I cannot use request after UPL but If I change all the variable names from request to upl, it tells me that UPL is not defined. It seems that the page is passing the form values for request but not UPL
I have got a news section which i am working on i can get all the news items to display the short description and title with the link to the full item but when i click on any of them it takes me to the very first record in the database. i have been told that the problem is with the ids not being passed through properly but im not sure.
I have a small problem.How can I pass value from form thru a few pages. I try with hidden field but my second page just validate and redirect to other one and when I use Request.Form("field") it's nothing coming back.
I am creating a simple news WAP site which uses a database. The database consists of three columns, storyid, storyheadline and story. The first page outputs the storyheadlines. When the user clicks on the headlines, they are taken to another page. The storyid is passed through the url (stored as storyno) and the next page loads the story which matches the headline. So basically, I need to know how to correct this:
SQL = "SELECT * FROM gmscwapstories WHERE storyid = <% Request.QueryString("storyno") %>"
I have a members only section of my site, which is protected and works fine, but i want to be able to alow the user to update their profile. Problem is, i don't have anything to pass in the url.
In the member record update section of the admin, i have the url, as it leads on from the chosen members id....eg...www.xxxx.com?id=2.......like that. But where the user updates their profile, it has nothing to send data from...eg...a form/recordset. Could this be done by storing it in a cookie or something?
I'm trying to display data from three tables. The main table has a Record number and the other table contain the same number. I need to pass the parameter value (record number) from the main table to the other tables (table2 and table3) and display there data on the same web page.
i can get the three recordsets open, but I can't select table2 and table3 by the record number from the main table. I also need to be able to move through the recordset one record at a time backward and forward.
I am trying to pass a value in a way that after a user has successfully logged in to an ASP app through a form, their login id would be passed to a welcome page.
for e.g. after their login they get to a page saying "Welcome User what would you like to do? " This is probably simple but I am new to ASP,so how can this be done ?
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.
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..... ......
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.
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.
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
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?
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.
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.
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.
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.
