Querystring Prob
does any one know if you can send more than one variable via a querystring.
View Replies
ADVERTISEMENT
Date Prob
In Sa the date format is dd/mm/yy. in sql server the format the format
is mm/dd/yy.
What code can be used to chnge the format to the SA date format
eithout chnging sql servers regional settings?
Pdf Link Prob
(1)I posted this in general but didnt get anywhere. Then I recalled seeing something recently on the web on an ASP site but cannot recall where.
(2)I have a list of pdf files avaiable for the user to view. When they click the pdf link, the pdf file opens. How can I make the link be a 'save' link? ie, when they click the link, windows treats it as a file to 'save as' etc...
What I vaguely recall on the ASP site was: 'How to hide the path of a download file by using an ASP redirect page'. I was wondering if anyone knows this method, and if they do, would it solve my problem in (2)
Login Prob
when the user enters his userid and password i want to
check the password from the table..
if any user with the userID that is entered exists i want
to find the correspoding password for him else i want to
throw an error saying no such user exists..
i know how to access the MS Access table and stuff..but
now what i want to do is to take the userid and see if
there is any userid such as the one existing, and if there
is i want to take out the password for that user ID..
what i am trying to do is as below.
The prob is, once i get the data in the dataset, how do i
take out the password?? Code:
MailScript Prob
i'm making a script that will mail all contacts within a database, basically it just loops through all the mail addys. but i'm getting this error: Code:
View Replies View RelatedASP Date Prob;
How can I fix the date and time of the next coming Monday in this format (8/28/2007 10:10:00 AM).
View Replies View RelatedAuthentication Prob.
I have a folder on my website that has 'anonymous access' and 'basic authentication' disabled, and requires 'intergrated Windows authentication'. This used to work fine, but all of a sudden it won't let me in! .
The login box appears, I have checked the username, password and domain are fine (I can still log directly in to the server with them) but I can't get access.and after I've tried 3 times I just get redirected to the: 'You are not authorized to view this page' page. Same thing happens even if I try usingbasic authentication.Does anyone know why this is happening?
Url Length Prob
I have a webpage with a form and i am saving the webpage using name value pairs. So i can give the users a link which they can click on and the form will open up prepopulated.
The problem i am having is that these forms can get exteremely long (hence the prepopulation facility) e.g test.asp?name=value?name1=value1?name2=value2
is there any way to increase the url in a browser or if you know of any other way i can accomplish this id appreciate ure feedback more detail regarding the above: I am allowing useers to save their forms with the data, also save multiple versions of the form (same form with diff data).
Drop Down List Prob~
Im having a form for user to enter fields. One of the requirements is to enter the school name. To overcome a difficult and long drop down list. How would like to let the user select from a "state" drop down list first, and it automatically will change the drop down list of the "school" under the selected state. How do I do that?
View Replies View RelatedMysql In Asp Syntax Prob
i got this line before:
mySQLde="UPDATE crmagents SET online=NULL WHERE online < DATE_ADD(LOCALTIME(),INTERVAL -20 MINUTE)"
connasa.execute(mySQLde)
it working perfectly! it was nulling all the records older than 20min
but i needed to add the nulling opration of the fields on the second table than i wrote this Code:
Shopping Cart Prob
I am creating a very simple cart kind of thing but have encountered an error and don't know what to do about it. This is the error I get
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: ""]'
/pinsys/Goods_receive/cart.asp, line 167
This is the line Code:
FOR i = 0 TO UBOUND( localCart, 2 )
IF localCart( CARTPID, i ) <> "" THEN
orderTotal = orderTotal + ( localCart( CARTPPRICE, i ) * localCart( CARTPQUANTITY, i ) )
Passing QueryString URL As A Paremeter In QueryString
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:
Querystring
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 RelatedQueryString
i 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.
Querystring
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?
QueryString
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:
Querystring
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?
QueryString
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")???
QueryString
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?
QueryString
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.
Querystring
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 RelatedQuerystring
I 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.
Querystring From URL
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.
Querystring Within Querystring
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?
Add A 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?
Querystring
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?
ASP/querystring
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
(QueryString)
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
ASP Querystring
I just started working for this company. They have an online form that takes the user information and then it sends it to an asp page so it can be appended to a microsoft access database. They want to have a the functionality of tracking down their web advertising campaigns through the use of their promotion field in the database.
Basically they want to track down the seach engine the user came from when he filled out the form. I don't have that much of experience in this kind of scenario although i read an article on request.querystring(key) which i believe is what i need to do although i'm not sure how to plug it in so it can start working.
The promotion code has already been inserted in the database and now the functionality is through an radio button called 'search engine' everytime it gets selected it will send a value of "internet" to the database promotion field. Does anyone have some suggestion of how to go about this?
Request.querystring
Trying to test if Querystring is empty. then display content based on that. Currently trying: Code:
<% if Request.QueryString("variable")="" then
response.write ("hello") End If %>
Basically I'm looking for a way to display certain content only on the main page when no variable has been set.
Request.QueryString's
slight problem (for newbie) giving error:
0x800A01B6: Object doesn't support this property or method: 'Request.QueryString.ID'
source of problem is line 6 (the bold one):
<%
Dim players__idd
players__idd = "1"
If (Request.QueryString.ID <> "") Then
players__idd = Request.QueryString.ID
End If
%>
i call the page using profile.asp?ID=1
Querystring / Cookies
I have this code that builds the querystring and cookies. What I want to do is remove the query string and cookies in like an onfocus of a drop down list box or even by pressing a button Code:
View Replies View RelatedRequest.querystring()
i m trying to pass a string valuewith a link:
like .............
response.write("<a href==teamemployee.asp?team=" & team & ">" & team & ">")
at the run time the value of team is "Admin & facilities" .
but when i read the value of team by using request.querystring("team")
. it returns only the value "Admin" .
but if the value of team is "Finance "
it returns the "Finance " .
Now , i think you can understand my problem that , request.querystring("team") is returing the value
before space . how to solve this problem .