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?
is there anyway of separating a string by either a space or + sign,I have an sms.asp page that receives a string in this format below
http://acompany.co.uk/online/intern...text=19%2Bdavid
the last part text=I need to split into 2 parts I need to read the first part 19 and match that to the db and then deal with the name David,I have tried everything, is there anyway of doing this even if the string read text=19+david if there was a way of separating the two.
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:
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)
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")%>");
}
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 RelatedI 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:
when sending my search criteria with a percent sign to a page that opens an excel sheet, it doesn't recognize the percent sign
ex. i enter %ABC but the value sent to the next page is just ABC
here is my excel button that sends the info to the next page. how do i handle cases where a percent sign is entered? is it handled in this page or would it be handled in the page that handles the excel? ....
when sending my search criteria with a percent sign to a page that opens an excel sheet, it doesn't recognize the percent sign
ex. i enter %ABC but the value sent to the next page is just ABC
here is my excel button that sends the info to the next page. how do i handle cases where a percent sign is entered? is it handled in this page or would it be handled in the page that handles the excel? Code:
Where in the following line of code would i place format percent so that the output is like this
6% (no decimal places just a number and a % sign.
<%
If (lngVotesCast>0) Then
%>
<%=CLng(objRs1("num"))/lngVotesCast%>
<%Else%>
<%End If%>
I have tried it in various places but i can't get it to work
I have written an asp funciton to write a 301 redirect. It gets the file name and the new desitination as arguments. I am doing this for hundreds of files so a script is more accurate than doing it manually and much faster, I thought. Problem is it chokes on the line: Code:
View Replies View RelatedI need to display the results of a query as a Percent. The data can be null, so in the query i have isnull(comns,0) Comns. When i use the ASP function FormatPercent i get an error that says type mismatch, is there any way around that error? Code:
View Replies View RelatedI have some values that I want to display as percent, such as the
retail price/wholesale price. In some instances, the wholesale price
is zero, so I get a division by zero error.
What can I do to avoid this?
Also, how can I get this to only show two decimals, instead of it
going .##### the way it does. I want it to look like .45%
I am creating a little signup script and tus far i have run into problems with this line. This line inserts the users information that they entered from the form into the SQL database. Does anyone know what is wrong with this line?
myconn.execute("INSERT regfreeup set signup = '" & Now() & "' , firstname = '" & first & "' , lastname = '" & last & "' , email = '" & email & "' , ordernum = '" & order & "', username = '" & user & "' , pass = '" & pass & "' , site = '" & site & "';")
i need to know how signing up works, the kind where you will fill in a form and then receive your password and username by email.
How do you generate the password and username, if you cant help please refer me to another site that i can check on.
In some searches on our web site the items will come back with a different dollar sign than the US $ symbol why is that?
View Replies View RelatedI am concatenating the firstname and lastname in the SQL query in the ASP page. I get the error:
Syntax error near =
This query works in Access.
<input type=hidden value="<%=strNetworkID%>" name=""networkid">
"SELECT" EmpID, FirstName + ' ' + LastName as Employee_Name, NetworkID FROM Employee WHERE networkID = " & Request.form("networkid")
I am developing a simple ASP that requires a user, after verfiying a checklist, to be able to actually sign the form using a PDA pen (The device is a PDA). My problem is that I do not have idea as to how to do this. Is there any API or any other method (say canvas?) that I can incorporate into the ASP so that the user can sign?
View Replies View RelatedI'm linking from one page to another like so: page.asp?modelName=#1 Common Ash Wood.
On the next page I store that value in a variable so I can use it however I like. The problem is that if that # is there the value doesn't pass and is left blank. If I have something like 2.25 #2 Common Birch then only the 2.25 comes through.
I had a similar problem in the past with quotes and was told to use ASCII ” and that solved the problem. Now, though, I'm doing a search for ASCII values and I'm finding a lot...but none of them seem to match up and work.
All the tables I'm finding say to use " for quotes and then says to use # for the # sign. When I try that for #, it does indeed switch and display a # in Dreamweaver, but still leaves the value blank when trying to use it in my application.
Where did you guys get the ” from and why can't I find any charts that have that to use for quotes? Whatever chart that is, is probably the chart I need for #.
Hope I haven't confused you too much. Basically, I just need to know how to be able to use the # in a querystring without it blanking out everything after it.
I am using ("Microsoft.XMLHTTP") to grab content from a site and display it
on my site, the issue I have and have had for weeks now is that on the
original page the sign "£" exists and when I get it to my site it is
displayed as a "?".
If I find the ASC code for the ? and replace on that it still does not work
:-(((
I have tryed all the usual method of fixing this with no success...
anybody had this issue or know where I might start to look to fix it ???
Anyone know how I can delete files from an asp page using filesystem and joker sign
I know how to delete one singel file, but I want to delete more than one file, only by
knowing the end of the filename, is there a joker sign I can use like "%" og "*"
I have tried something like this:
varFilename = * & "thefilename.txt"
fs.DeleteFile (server.mappath("files emp"& varFilename))
I am looking to implement a single-sign on solution for my company's website which has many partner websites scattered around the globe.
I want the members to be inconvenienced as much as possible, so if they log into one website, they are logged into all of them. As each website exists on seperate web servers in different locations, this makes my options a little tricky.
Has anyone had any experiences of single-sign on? I only know a little of XML, but I understand that this kind of thing can be achieved using XML over SOAP.
point me to resources that will tell me more about enabling a web application to tegrate with windows security for single sign on
View Replies View RelatedI had successfully programed a running Update ASP Page. While troubleshooting the pages, I discovered a error when I input something with ' For example: (john) is okay, (john') will give me error message. How can I do so the applicant can input ' in the update page?
The following is SQL code in my update page: .....
I have a problem with an ASP page pulling data from a SQL2000 server. Expected behaviour is that when prices are displayed they are displayed in pounds as this is the default locale of the server. However they are displayed in dollars.
I've checked the default locale and the user locale of the (windows 2000) server and these are both British english. The language for the SQL user is also British english. Are there any other setting that could affect this?
I have a sign up form where a person is signing up for several events,names and signup info goes into an access database.
I need to have it cut off when the events get full and prevent futher signups. Different events have different capacities, so some events could close and others still be open for sign up.
I'm building a few web sites that will use distinct domain names but will reside on the same server, at the same IP address, in the same application space, and will share a database. They will each provide different content depending on the domain name, but will share some core functionality behind the scenes.
What I'd like to be able to do is have one site serve as the primary site. If a visitor comes to one of the secondary sites and wishes to perform a function that requires them to be logged in, I'd like them to be able to log in only once and then be able to visit any of the sites without having to login again. Does anyone know of a pure ASP script-based single sign-on system?
I have the following:
<%=rs1("Address")%>
which would show something like:
555 Home Rd
What can I add that will put a + sign where the spaces are so that it looks like:
555+Home+Rd
I want to make sign out option in my website as like yahoo and hotmail.
View Replies View Related