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 Replieswhen 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 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 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 have a login form in which i have logins for company as 'National City"
But when i capture the login name to give it in my query on some other form as Request.Querystring(username)
Its recognises it as National%20City...
i dont want to chhange my login names and keep it as NationalCity as one full word.How can i tell ASP to recoginze this as a space in the query ?
How do I delete the last character in a string?
View Replies View RelatedI am using mySQL with ASP. I have a trouble with Turkish characters as I am
tring to get and display data from mySQL database. However, I can see whole
Turkish characters exactly when I use phpMyAdmin.I used the following tags on HTML but I couldn't achieve to display Turkish characters in any way.
mySQL database lang: latin5_turkish_ci
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
and
<% @Language = "VBScript" Codepage="1254"%>
Session.LCID = 1055
Session.CodePage = 1254
We have an application which uses surname and the date of birth to allow people to login.
The SQL gives an error if the user's surname contains the character '
I'm trying to set a session variable where two variables are seperated by a backslash:
Dim a
Dim b
a = Request.QueryString("Class")
b = Request.QueryString("Group")
Session("FTEClassGroup" & y) = a + "/" + b
I can't get this to work? I'm not sure, but is the backslash being seen as a string instead of the actual backslash character?
i m declare one variable and it hold the name of a person
eg: strName = "Arvind Singh"
and i want to put first four character in an other variable please tell me the way to do this.
I have a partner sending me by post method to an asp page some text (xml
string).
It arrives to my page encoded as follows
%9a%2f%Purchaseorder%3....f
The < and > and spaces are replaced by nu霉mbers and percentage sign
I am using Request.BinaryRead(BytesTotal) and then doing response write and
I am getting exactly the same string with the encoding
How can tell my asp page to translate the encoded text to normal text?
How do I remove those special characters in a variable? I think there are a dozen special character and so I use a dozen replace object. Is there an object that call this in one call instead of a dozen?
View Replies View RelatedI wonder why my computer with UK settings returns '$' when I call the 'FormatCurrency' function?
View Replies View RelatedI'm having a problem finding/using an escape character with this ASP/JScript application I'm creating. Basically I have text sometimes that has apostrophes or double quotations in them, but they won't be INSERTED unless I manually take them out.
Ex: INSERT INTO tbl1 (vendor,reason) VALUES (81,"This is only a test, but there is an apostrophe and it's only going to make things worse.")
That apostrophe in "it's" is kiling everything. I've used the replace method to change it to " ' ", but that STILL doesn't work. I can't find MS SQL's ESCAPE CHARACTER. I've tried several directions of the backslash, but no luck.
I am trying to only have a link show if there is a certin value in the DB. This is what I am trying:
<% if (rsWelcome.Fields.Item("access_level").Value) = "admin" then
response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-")
end if %>
BUT... this is the error I get:
Expected ')'
/sta/topnav_test.asp, line 9 response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-") How do I use quotes in a "response" and have the app server ignore them??
The application should have a way of alerting the user if it does not recognize a character used by the website and give the user the ability to make adjustments to the unrecognized characters. The system should then remember the characters that have been adjusted by the user.
View Replies View Relatedcan someone please tell me how to add the " character to a string
i've already tried:
<%
dim string
string = "something"
string = string & """
%>
string should equal something" but doesn't work ?
how can I add "vbCrLf" after every 80th character of a string. Suppose there is a string containg 600 characters and I want to pass on the string value to some variable, adding "vbCrLf" code after every 80th character.
View Replies View Relatedsome one cuts and pastes the chinese charcters.
they are saved in DB as
---- case1 : ----
& # 6 5 3 9 6 ; & # 6 5 4 2 7 ; & # 6 5 4 1 9 ;
----
i used the space above as it is converting the characters while posting..
but i noticed some few records which are saved as
-- case 2 --
永乐大典戏文三种校
---
if values are stored as case1 then i have no problem.
but with the case2 .the chinese characters are shown good in few pages and at few pages they are shown as it like symbols.
when i cheked the its the same.what shd i do to see that in a html page these character codes display correctly?
Is there a way to make the underscore Character display in a browser? I've
tried several different fonts but the "_" character will not display.
ive got a string where i woulld like to remove the last character it probably seems simple 2 u but i cant work it out
can anyone tell me how to remove it.
IF trim(request(location))="" AND trim(request(FileType))="" AND trim(request(DateMonth)) = "" AND trim(request(DateYear))="" THEN
Response.Redirect plmsearch.asp?ac=error
END IF
why is the "?" causing the invalid character? everything is coded correctly on the plmsearch.asp page.
I have a ASP/SQL 7 application that displays data from various SQL7 Views
onto a ASP page.
A column of this data is displayed in ASP as hyperlinks and the relevent
data is put into a URL query string - so that the linked page is based on
this data ( a kind of "drill-down" effect) - Code:
I have some text that I recieve from a DB, (it can variable or A text field doesnt metter)No i need to recognize if this text is english or a hebrew.how can i do it?
View Replies View RelatedI have an asp application running with the charset set to windows-1252.Recently, my customer complained about some unknown characters(rectangulars) appeared on the screen.
Later I found out from database that the unknown characters are supposed to be coma (,). I then tried to set the charset in all pages to UTF-8 but it did not solve the problem. I have a problem debuging since my testing machine does not have this problem.Is there a possibility that font selection such as sans-serif can cause this problem?
its there anyway via asp i can get around the 255 character limit for url strings.. its for use in a cms/eshot system. on a mailto: link i want to create a string of email address for the client and then send from there own inbox.
View Replies View RelatedHow do I insert a space after every 4th character in a string?I'm presuming I somehow use the replace function?
View Replies View RelatedHow can i delete the first letter of an asp string.I know i can add up the charactors of a string and then take away one from the ammount of charactors in a string,and then using the right syntax with the ammount of a charactors.
View Replies View RelatedI have a site with a simple admin tool (cut and paste text into a form field etc)henever someone copies in text with quotation marks, dollar/pound signs and then submits it to the database, the text shown on the front end contains ? marks instead.I have read this may be due to special characters or something, is there anyway to stop this
happening or filter it out as the admin is for general use by registered people.
I want to convert the first character to Upper case, while the rest remain lower case.
variable = lcase(left(blablabla,9))
let say now the "variable = abcdefghi"
How can I convert ONLY the first character to uppercase?so that the variable will be holding "Abcdefghi" ?