PASSING A QUERYSTRING PARAMETER
I am new to ASP.NET 2.0 and I am developing a small application which
originally consists of 2 pages. The first page displays a GridView Control
loaded with data from a sqlDataSouce. Such a GridView has a field that is a
hyperlink to the second page which is supposed to display the detail of the
record.
What I want to do is to send a QueryString Parameter to the second
page with the key to retrieve the record selected and show the information in
detail (a long description, a picture of a product, comments, price, etc.).
I have not written a single line of code (code-behind) for the first page.
How can I get the second page and send the querystring parameter?
View Replies
ADVERTISEMENT
A MS-Access database table has 2 columns - UserID (unique) of number data type & UserName (text) along with some other columns.When users come to a particular page, say, AllUsers.asp, all the UserNames are displayed to him as hyperlinks. Based on the UserName
clicked by a user, the next page (to which the user will be taken to when he clicks any of the UserNames) will display more information about that particular UserName (which the user had clicked).Assume that the page where more info is displayed is named UserInfo.asp.
(Note that the info will also be retrieved from the DB table).
UserInfo.asp will also display the UserName the user had just clciked in AllUsers.asp.
Now for UserInfo.asp to retrieve data about the UserName the user has just clicked, I can make the links in AllUsers.asp pass the UserID as well as the UserName as a querystring value. Now whcih one will be more efficient - sending the UserID as the querystrinng value or sending the UserName as the querystring value?
View Replies
View Related
I am passing a text parameter with querystring like
..asp?parameter
How do I pass a parameter which itself contains the "=" character?Eg if parameter ="a=b" then the code will interpret is as a parameter named "a" with a value "b", where as I need "a=b" being the value.
View Replies
View Related
I am using Ultradev to develop asp pages with Access database. With the help of some online friends & tutorials i am studying this. I need some help for the following. I am having 2 tables,
Table 1 with Company Name & Country Code
Table 2 with Country Code & Country Name.
When some one searches for a company, it should display me the Company Name along with the Country it belongs. Someone told me that it can be done by passing a parameter value from one recordset to another on the same page, but i dont know how to do this.
View Replies
View Related
If a com is being used at two diff places and it requires same number of inputs how can we pass inputs if number of inputs are not same on every page.
View Replies
View Related
The subject sounds confusing but here is what i want to do. I have a
button on my page which says
OnClick="javascript:window.open('reportsContainer.asp?pag eURL=Report1.asp?intCurrentPage=1&blnRetrieveFlag=1&Show=1',TasksRPT');"
Now on the Conatiner.asp what i do is
if Request.QueryString("Show") = 1 then
pageURL = Request.QueryString("pageURL")
end if
And then i set the pageURL along with intCurrentPage and
blnRetrieveFlag parameters to my fram src as
<frame height=500 scrolling=auto name="pageFrame" id="pageFrame"
border=0 src="<%=pageURL%>">
Code:
View Replies
View Related
From ASP I run a query using MIN(some_field/parameter) Now I need to pass this parameter to the query from ASP code. How do I do that?
Syntax like
MIN([some_field] / [])
does not work
View Replies
View Related
I have a web site in which 7 pages repeat once and again in thousands of folders. Why? because I want to keep, to the user view, the pretty url www.myweb.com/username/pageX.asp.
As you can imagine, this makes maintenance hard, because when I make some update, I have to run a program to spread the change to the xthousands directories.
A solution would be to change the url to www.myweb.com/pageX.asp?u=username but the url wont be so easy to remember, and probably it will not like our users.
My question is, in which way can I simulate this last behaviour, but maintaining the "pretty" url, not only for accessing, but during the navigation. The trick would be to catch the inexisting directory name and pass it to the desired page as a parameter.
View Replies
View Related
I am attempting to pass null as the input value from a series of
textboxes if the user does not input a value prior to submit. To try and do
this, I am using a vbscript function on this asp as follows:
CommentsAdd = IIf(Request.Form("Comments")="",NULL,Request.Form("Comments"))
I was hoping this would convert those emptystring textboxes to null.
Then, these variables are input in an update stored procedure called from
the same asp upon submit. This handles ntext and like fields in the table I
am updating, but a null value passed in this way for a numeric field chokes.
The error on the asp is something like, "unable to convert value of type
text to numeric". Can't null be passed as a parameter value when the field
type is numeric?
How does one pass null for a parameter's value in a stored procedure on an
asp? Am I missing something here?
View Replies
View Related
I'm trying to pass parameters from an ASP (VBScript) web page to a Stored Procedure in SQL Server. I know how to do the Stored procedure but it's passing the parameter from the web page that is stumping me.
View Replies
View Related
I'm trying to create a link (SEE LINK BELOW) to a pop-up window. My problem is my sTargetPage variable is a url containing a querystring variable. When myPopUp.asp opens and I get my sPage query string value, it returns myTargetpage.asp?qs=1 and clips the 2nd querystring value pair.
Can someone help me construct a link so myPopUp.asp preserves the entire query string? I tried using the Server.HtmlEncode comand in "FAILED ATTEMPT" below, but I'm still losing any querystring pairs after the 1st qs pair.
PAGE VARIABLE: sTargetPage="myTargetpage.asp?qs=1&qs=2"
LINK: http://www.cnn.com/myPopUp.asp?sPage=" & sTargetPage
FAILED ATTEMPT: myPopUp.asp?sPage=" & Server.HtmlEncode(sTargetPage)
View Replies
View Related
I am passing
a value held in a session variable on a url. It works fine locally
testing but when I put it on the main web server the value disappears.
Nothing fancy here, real simple...what I am missing ?
<a href="http://ServerName/ReportServer?/SomeRpts/rpt1&urid=<%=
Session("txtURID") %>"
target="blank">Contracts - Client Listing</a>
View Replies
View Related
My problem is I'm paginating database results into a table, and each page takes the sql statement from the querystring, however because i use LIKE %...% the '%' get ignored and I get an error. For example the sql in the querystring is..
SELECT * FROM posters WHERE poster_name LIKE '%a%' AND poster_file IS NOT NULL ORDER BY poster_name ASC;
But when it's extracted from the querystring it is this:
SELECT * FROM posters WHERE poster_name LIKE 'a' AND poster_file IS NOT NULL ORDER BY poster_name ASC;
So i get an error because the wildcards have been removed. Any way around this?
View Replies
View Related
I,am passing form variable monthsenrolled as a query string It does not work as i get a error what is wrong here
function previous(){
window.open("http://localhost/college/basic.asp?status=2&test=<%Request.form("MonthsEnrolled")%>");
}
View Replies
View Related
Is this possible? I have a 2-dimensional dynamic array that I want to pass to a page. If so, what is the syntax?
View Replies
View Related
I am passing a sql string thru my querystring for the next page to
capture.
example: www.xxxxxxxx.com/index.asp?str=select * from table where name
like '%doe%'
Passing a basic string works fine. But, when I use the LIKE statement it
does not work. I know it's because of the % sign, so how do I translate
this thru, so that the following page picks up the percent sign?
View Replies
View Related
I am passing a value to a form through the URL as follows:
<A href="http://www.xxxxxx.com/orderone.asp?text="radius">http://www.xxxxxx.com/orderone.asp?text="radius"
On the orderone.asp page, I am reading the value into a text box as follows:
<input name="Template" type="text" id="Template" size="25" maxlength="255" class="body" value=<% = request.querystring("Text") %>
so far it works fine. It shows the value in the text box on the page. I am trying to post this page with all the form fields to a new page that emails all the variables that are on this page. The form tag looks like
<form action="Orderform3.asp" method="post" name="order">
In orderform3.asp, i am requesting the values for all the form fields as follows before emailing all the fields to myself:
strBody = strBody & Request.Form("Account_Name") 'strbody is the variable that adds all the form fields to the body of the email
strBody = strBody & vbCrLf
strBody = strBody & Request.Form("Contact_Name")
strBody = strBody & vbCrLf
strBody = strBody & Request.Form("Template")
Here is the problem...I am getting the email with the values filled in except for "Template" and I cannot figure out why. Is there something that I am doing wrong? i have to mention that there is no DB behind this site...it is just a static web site with an email script in it.
View Replies
View Related
i have a table 'Accounts' in my database, which contains a bunch of
users. From the main menu i choose "edit user" and all users in the db
are presented in a table. The first column 'Pnr' is a unique ID for
each user that i made appear as a link. clicking on one userID should
present a form where the picked users userdata is already filled in so
i can easily edit it and then move on to submit the form to update the
db. i get to the part where all users are listed nicely in a table,
but clicking on one, i get this error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.
/VS_Files/updateUserForm.asp, line 19
I think i'm doing something wrong with passing a value with the
querystring...? Code:
View Replies
View Related
How can i pass parameter in ASP with hide
ex : default.asp?id=9
i wanna be : default.asp but the id still follow the page
View Replies
View Related
I would like to get parameter of ASP script in URL. example : /localhost/example.asp?parameter1 . How can i to get this parameter ?
View Replies
View Related
I am trying to pass three parameters using this code in an asp page to an
xsl page. I keep getting the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/account.asp, line 114
Any ideas what I am missing? Code:
View Replies
View Related
I can call a user document with a paramer in the IE Address bar eg:
C:Program FilesMicrosoft Visual StudioVB98docMyDocument.vbd?Parameter
I can call the Userdocument using these lines of code in ASP:
Sub Window_OnLoad
Navigate "docMyDocument.VBD"
End Sub
I have beed trying to pass it a parameter with the following syntax :
Navigate "docMyDocument.VBD?Parameter"
This does not seem to work. How do I call the userdocument in ASP with a parameter ?
View Replies
View Related
I am using Crystal v7. Main report and subreport are both based on the same stored procedure. How do I pass parameters to display the report and subreport in the Crystal viewer. I can display regular (non-sub) reports fine.
View Replies
View Related
I got a problem returning parameter. I am storing date using datepicker to choose my date. But when i want to delete it from the table because date is one of the primary key. it has problem when i retrieved it because it is recognized as datetime but when it display it's a text. i need 2 convert from text to date. how would declare my parameter then?
View Replies
View Related
myGetImage.asp is suppose to create a temporary file in the client side, and display in on the client web browser. myGetImage.asp needs to know the clients web browser temporary system path, in order to create the temp file. How do I get the parameter and value of clients web browser temporary system path?
View Replies
View Related
My website sends automatic emails from many (25) different places. I want to
send a second email by reading the parameters of the first one. I don't want
to have to repeat and maintain the assignment of the second email
From,To,Subject fields so I am just using an include at each point in the
code where I send an email: Code:
View Replies
View Related
Is it possible to do a quick check to see if you were refered to the page with URL parameters and if so perform an action?
View Replies
View Related
I 'd like to print out all posted parameter names and values. I'm able to print all the posted request values, but not the parameter names.
View Replies
View Related
I am trying to pass some paramters from a VBScript function to a script that writes the parameters to a text file. I have not been able to do it. Code:
View Replies
View Related
I've taken over the development of a web app written in ASP. It's not
very well coded. In the live environment it's fine, but on my local
machine it falls over whenever it tries to pass a date to a SQL Server
sproc. No idea why the person before me's been doing all this string
formatting with his dates, but anyway, the error is:
Application uses a value of the wrong type for the current operation.
The dates throughout are in mmddyyyy format, and presumably ADO
running on my local machine wants ddmmyyyy. I'm rebuilding the whole
app in C#.Net anyway so I don't think it's worth me running through
and making this jumble of code international date friendly, so my
question is, where exactly is the date format for ADO defined?
Windows? SQL Server?
View Replies
View Related
This works:
Server.Transfer("testimonials.asp")
This does not
Server.Transfer("testimonials.asp?somevar=yes")
View Replies
View Related
I read somewhere that server.transfer had a 2nd parameter so control and input values were 'passed' to the transferred to page, but it's giving me an error of wrong number of parameters. I have IIS5, is that the problem? or is it that it's an ASP page (not ASPX)
View Replies
View Related
I have a problem that I wasn't thinking of when I did this snapshot reporting in asp. Ok here it goes. I have a Access database that has my queries and reports.
I have some queries in access that have a parameter in them, like enter first date and enter second date to give me the range of record and total for the reports. Well, this asp that I have for doing the reporting does it server side. Code:
View Replies
View Related
