Inserting Character

%20 Character
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 ?

---

Last Character
How do I delete the last character in a string?

---

Character Set
I 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

---

' Character In SQL
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 '

---

/ 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?

---

First Four 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.

---

Character Encoding
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?

---

Special Character
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?

---

Currecy Character
I wonder why my computer with UK settings returns '$' when I call the 'FormatCurrency' function?

---

ESCAPE CHARACTER
I'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.

---

Escape Character??
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??

---

Unrecognised Character
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.

---

String Character
can 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 ?

---

After 80th Character
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.

---

Chinese Character
some 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?

---

Underscore Character
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.

---

Removing Last Character
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.

---

Character Conversion
I have a generic ASP page that creates MD5 hashkey, gets included in more
than 1 other ASP page. Other including ASP pages seem to be setting charset
meta tag to various non-ascii charsets. I found how to convert in ASP.NET,
but not ASP? The same string "fu@bar.com" generates different keys in
different charsets.I tried the "@CODEPAGE=1252" directive at the top
of the hash asp page

---

Invalid Character?
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.

---

Bad Character In URL QueryString
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:

---

Hebrew Character
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?

---

Unknown Character
I 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?

---

255 Character Limit
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.

---

Delete First Character
How 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.

---

Character Change
I 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.

---

Changing Character
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" ?

---

Character Limitation
Does anyone know the character limitation of an application variable ? How much can one hold ? Will it give an error if it gets too big ?

etc etc

I have a complex array that I store in them to rotate content quickly and how much data they can hold ? Well sort of an array... if ya know what I mean. I split it and parse it when I use it. Whether it's a good idea or not to fill one up what is the limit ?

---

Returning One Character
i have a string that will change and i just want to return the first charecter, how do i do this?

---

Printing Character
how to print apostrophe character ' and double quote " in asp using vbscript. my code using response.write replaces " character with inverted question mark.

---

Character Encoding
I have created ASP with database application over a PHP based software. My problem is I get data from Excel files with an encoding as SJIS (Shift-JIS) and save it to the database.

And the PHP software is the one that displays data in the web but using UTF-8 (unicode). I need an API in ASP that will convert charactrers from SJIS to UTF-8.

---

Invalid Character
the error that results from this snippet of code? Code:

if Session("message") <> "" Then Server.Transfer("palm-springs-guestbook.asp?action=sign") Else Server.Transfer("gb_entry.asp") End If

I am sure it is in the ?action=sign Can I escape those characters?

---

International Character With CDO And Asp
Is there a way to change encoding of a message created with CDO.Message, or
otherwise send international characters (unicode) in Textbody? The messages
I get now show question signs instead of international characters.

I'm taking the result of a form and send it by email.
The result is like this:résumé
Instead of that: résumé

---

Character Conversion
I need to input into an Access database a string. My problem occurs when the string that I grab from an HTML form has a 'in it. I understand why it is doing it. However I do not understand how to fix it.

how do you grab a string from an ASP page such as: "Hello what's up" and place it into an database through ADO. The problem is the single quote. I know how to insert values into a database.

---

Removing Last Character From Field
I have a form that seems to add a comma to the end of the email address, ive looked all over the form for this random comma which i cannot find, the comma is definately there before i perform any sort of email error checks, however ive pretty much given up trying to find where its added, but i was wondering, is there something you can add which removes the last character of a field, before it gets entered into the database, something like a comma?

---

Check Each Character Of A String?
What is the best way to check each character within a string?

For doing something like encryption, where you check character 1 and replace
it with a different character.. then check character 2 and replace it with a
different character.... etc.... until completing the string?

---

Chinese Character Conversion???
I've got an english site designed that I need to translate into Chinese.

I've got the Chinese wording to work with but I can't figure out how to get it into my code.

I thought I could simply paste the chinese characters from a Word document into my html editor between <P> tags using the PMingLiU or SimSun font but it just enters like this:
&#20844;&#21496;&#31616;&#20171;: turns into ????:

---

Unicode Character Problem
I am having a problem with a forms entry using Unicode characters, specifically "smart-quotes". Under Microsoft PWS and MS-SQL 7.0 it works fine and I get the Unicode characters, such as smart-quotes, being written and read form the database. However, if I use the same code using Apache, Linux and SunONE ASP the Unicode characters don't
work! Code:

---

Reading Single Character
is it possible to read single characters from text files with ASP i have seen codes which read entire lines or entire text....but i couldnt find any function which reads single characters as the text file is read...

---

Invalid Path Character
I am getting an error message that reads:

Server.MapPath()error 'ASP 0173 : 80004005'

Invalid Path Character

/createnewfile.asp, line 81 An invalid character was specified in the Path parameter for the MapPath method.

set fso = createobject("scripting.filesystemobject")

' create the text (html) file to the server adding the -mmddyyyy after the g_title value

Set act = fso.CreateTextFile(server.mappath("vendors/" & g_filename & "_" & month(date())& day(date())& year(date()) &".asp"), true)

---

Converting Unicode To Character
How do you convert Unicode into a character?

The first two examples result in a syntax error. The third example prints out the characters in the string.

ASPACE = Chr(u00A0)
ASPACE = ChrW(u00A0)
ASPACE = "u00A0"

I do realize

ASPACE = Chr(160)

works but I’d also like to be able to work with Unicode.

---

Split() Ascii Character
I'm familiar with using the split function, but i've never had to do it on an ascii character before.

I am given a datastring that looks something like this:

Code: ....

---

Way To Replace Each Occurence Of Each Character
I'm looking for a way to replace each occurence of each character in a
string to different characters.

i.e - the pattern is a=d, b=e, c=f

so that the string "back" would be "edfk"

How can I do that?

---

The ' Character Gives Me An 80040e14 Error?
"INSERT INTO WR_NEWS(WRN_Title, WRN_Content) VALUES ('" & Headline & "', '" & Article & "')

When I try to type something to go into the WRN_Content field it works fine unless I use the ' character then I get a 80040e14 error and it breaks the query. Is there anyway that I can get around this other than not using the ' character...

---

Wildcard Character/syntax
I have a little script that is supposed to check for a certain value in a db column, and then do something if that particular calue is present:Code:

...<%ElseIf rsIDK.Fields.Item("my_column").Value = "/default.asp" then ...

The problem is that my_column can contain up to 300 characters, so the code above doesn't work. What I really need is a wildcard at the end of "/default.asp" but I don't really know the correct way of doing this.

---

Validate Character Length
I have a text box within a form that allows for Codes to be inputted.What i want is for an error message to be displayed and the form to be prevented from being submitted, if the code length inputted is less than 14 characters.I'm using dreamweaver and i have already set the text box to restrict the maximum character length to 14 characters, but there does not appear to be a mimumum character delimiter option available.

---

Special Character Search
Retrieve a list of all records starting with special characters.Does anybody know of solution?

---

Posting ASP Null Character
i'm trying to post a section of XML code to an XMLSocket Server via ASP I can successfully connect to the server, but it won't disconnect because the string needs a null character inserted at the end in order for the socket server to terminate the connection. how would i do this? i've tried chr(32), chr(0).

newdoc="<USER> +19024894124</USER><MESSAGE>test
</MESSAGE><USERID>+19024894124 </USERID>"

---

Decimal 160 Character In Browser
I have a input string I display. In the string, I have a character that's a part of ASCII chart 2 which doesn't display correctly. It displays as a ?. I tried different encoding to no avail.

---

Storing Special Character
I am using ASP as front End and My SQL as back end. I have a text box which inputs the comments but my sql gives error while inserting that text into field(I have tried this with both VARCHAR and LONGTEXT).

these characters are not very special like ' ( ) it is not storing these also any body have any idea what should i do to resolve this issue.

---