Passing Array In QueryString
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 RepliesIs this possible? I have a 2-dimensional dynamic array that I want to pass to a page. If so, what is the syntax?
View RepliesThe 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:
i get true for the is array function on a querystring variable, anyone have ideas?
Let's say I pass in "george michaels" or "george" both return true on the is array, yet the A(1) will error if you try and access it on a "george" split on space. Code:
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)
Here's what I have:
quiz.asp?done=6|3|2
my asp code:
done = request.querystring("done")
Now, if I response.write done
I get 6|3|2
However, I want to create an array of 6|3|2 ???
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>
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?
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?
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")%>");
}
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?
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.
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:
Does anyone know how I can accomplish this? The only tech I saw from
textbook or other help is to run a loop through the record one at a time
to SQL/plus procedure call. In general, We use the IIS 4 and ODBC as
interface from web server ( where ASP resides ) to an Oracle Server
(8.1.7) both on NT 4.
Following is a vbscript code extract triggered by a combobox OnChange event. arrVendorA and arrdefpack are server side arrays and i need the intCounter parameter to be the array index. Code:
<script>
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(intCounter)%>" then
if "<%=arrdefpack(intCounter)%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(intCounter)%>")
end if
end if
end sub
</script>
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
is it possible to check if a variable is present in the querystring, or is that unneccesary? will it assume the variable is empty if it is not present in the querystring?
View Replies View Relatedi have a hyperlink from a results page:Code:
Response.Write "<TD>" &"<a href = JobDetails.asp?id=" & rs("JobID") &" >" & "Click Here" & "</a></TD>"
the sql statement in JobDetails.asp =
Code:
sqlstr = "select * from Jobs where JobID = '" & Request.QueryString("ID") & "'"
rs.Open sqlstr, conn
im getting this error when i click the hyper link
line 20 is the rs.Open sqlstr, conn line
this error seems to happen with dates but i dont have any dates at all.
I want to write a page which will
load a default page for me with some links and all. lets say someone
clicks on the link, which not only points to the same page but also
passes a querystring. Looking at the querystring I will then display
data from a database.
So my question in short is... Is it possible to have a single asp page
which can return either a default page where no querystring is passed
or a result from the database when a querystring is passed?
If the answer is yes, then is it a good idea to do this or have 2
seperate pages?
I've got a request form for samples of our product that we send out. The form is being linked from our ebay auction pages. In the link from the auction page I'd like to include the model number of the sample that they're requesting. (ie. /sampleRequest.asp?AS240)
Then, on my sampleRequest.asp page which contains the input form I'd like to include a hidden field which holds the value of that querystring. Finally, upon submitting this form I'd like that value to be placed into the sampleModel field in my Requests table in my database.
The problem I'm having is how to populate the hidden form field with the querystring form the ebay auction page. Code:
I have a querystring like this:
checkbox1=2&checkbox2=1&checkbox3=2checkbox1=5&checkbox9=1&checkbox3=1
I would like to insert each set of checkbox1, checkbox2, checkbox3 into a table like field1(checkbox1), field2(checkbox2), field3(checkbox3). Remember each set of 3 checkboxes are 1 unit inserting into a table. Is this possible?
I am trying to maintain some ASP code that I did not generate and the programmer who did has a very different style than I do so I am having some problems. Hopefully someone out there can help me by answering my question.
I have the following line of code:
If (isEmpty(Request("dir"))) Then.....
Now my question:
Could the Request("dir") used above be the same thing as using Request.QueryString("dir")???
I just noticed though that when I include the file name to the folder it worked.
ie unitingrhythms.co.uk/?size=4 - no output
& unitingrhythms.co.uk/index.asp?size=4 - outputs 4
can the querystring be read when the file isn't shown?
i have a querystring on one page where the url looks like:
delete.asp?name=test2.pdf&type=file
on delete.asp i have:
Dim name, type
name = Request.QueryString("name")
type = Request.QueryString("type")
It gives me an error for some reason.
i am working on ASP.net in c# and i want to pass " +" in querystring but "+" is converted to space.Is thereany encoding method to show "+" in querystring.
View Replies View RelatedI have a querystring that contains the + sign as a separator, I need to read these values individually in a select statement, for example.
&text=Single+205
where single is the type of room somebody wants and 205 is the user ID in the Customer table.
I have a banner that is clicked and the people are takin to a general information page. From the banner they are given the URL and a querystring of ?AdID=X. On that page they click and are taken to our signup page where i have a form for them to fill out.
The mentioned querystring is the referering company. How can I get the querstring information into a hidden value on my form before submitting to the database. I have tried <%=request("HTTP_REFERER")%> and it writes the whole URL into the database. I need just the querystring. Have also tried. <%=request.querystring("AdID")%> and that does not work either.
I am using querystrings to pass URLs to be able to tell what page to go back to when an action is done on my inventory site. For example, if an order status is updated, the page that does the update knows to go back to a page to display the page that the person was looking at before the update was done.
One of the pages that displays orders filtered by search criteria uses querystrings. If I try to send that URL as a querystring, it all gets combined together. For example, I have one page that redirects to something like "emailUpdate.php?Send=True&OrderID=342&LastPage=results.asp?Item=Computer&Method=Brand&Criteria=Dell" where "results.asp?Item=Computer&Method=Brand&Criteria=Dell" is the page I want to return to.
The "Item=Computer" gets set just fine, but the rest of the URL is concidered part of the first URL. Is there some special characters that I can use to show that I want the one URL to be its own querystring?
how do I add a querystring, with ASP? You're probably thinking, "just add it to the url"...but that's not what I want to do. Here's an example of what I do want to do,
[vbs] Dim someString
'// Here a querystring gets added, through headers or something
'// Here my code uses the newly added querystring
someString = Request.QueryString("MyAddedQueryString")
[/vbs]
this is just a simplified example. Does anyone know how to do that?
I have a this piece of code...
<
dim ur
url="http://www.test.com?var1=1&var2=2
%
And this is a part of a flash movie..
<param name="movie" value=testez.swf?clickTAG=<%=url%>
when i click in the movie the page goes to..
http://www.test.com?var1=
But the another variable var2 doesnt appear in the url. How its possible pass all the parameters when you click in a flash movie?
I wish to build the following statement from a table that has been dynamically built using an query against an Access database. The number of rows in the resulting table can be 0 to any number. How would I dynamically build the string of params to pass to another web page?
During the creation of the table? or after the table is built? The number of params will be equivalent to the number of rows and the values are variables containing the data stored during the table creation during thr recordset loop.
file.asp?param1=value1¶m2=value2¶m3=value3
iam send a sending a value in URL to asp page
html page
<A href="IndustriesDetails.asp?IndustryName=Houseware & Kitchenware" target=_main>
Houseware & Kitchenware</a>
ASP page
strIndustry = Request.QueryString("IndustryName")
The problem is it is only getting "Houseware" if i remove '&' then it works fine ..can any one please tell me how can i solve this problem ... i want to get "Houseware & Kitchenware" in asp page