Code Pages, Cookies & Character Sets
I'm a little perplexed. <%@Codepage="65001" %> changes how IIS/ASP will handle interpreting query string variables - i.e. it will read the querystring as being utf-8 encoded.
However, I'm finding that it *doesn't* change how Response.Cookies or
Request.Cookies get read/written.
I've been testing with a little jscript asp page with the lines
if (String (Request.QueryString ("abc")) != "undefined")
Response.Cookies("abc") = Request.QueryString ("abc");
Response.Write (Request.QueryString ("abc"));
to take a value from the query string and pass it back out as a cookie. The test value I was using was r%c3%a9sume (resume with an accented e). When the code page is set to utf-8, it will properly interpret the urlencoded query as a utf-8 string. It will output the right bytes with Response.Write.
But watching the headers produced by the request, it comes out encoded in latin-1.
Set-Cookie: abc=r%E9sume; path=/
I checked the cookie rfc on w3c.org, and oddly it doesn't say much about how to encode/interpret cookie NAME=VALUEs. The only comment on character set in the spec is that a cookie *comment* has to be utf-8 encoded.
I couldn't find anything on the MSDN documentation that addressed cookie character sets either.
View Replies
ADVERTISEMENT
I have an ASP page that displays data from a SQL database. It includes some Canadian names/address which contain the special accent characters...my ASP page doesn't display them properly. I have included the tag
<META HTTP-EQUIV="content-type" CONTENT="text/html; charset=ISO-8859-1">
but they don't show up correctly...what else do I need?
Update: Turns out the source of our data gave us the old IBM codes, not the newer codes...for example, they gave us 144 instead of 201, and using the charset of 8859-1 won't allow 144 to be displayed. When replaced with 201, the character displays just fine.
View Replies
View Related
What would be the most efficient way to check to see if a cookie matches a record in a DB table?
If the user's cookie matches a record in a table of executives, then I want to display a breadcrumb menu item just for that executive.
This does not have to be super-secure or anything, I just want to keep honest people honest.
If the information they submit in a cookie is also present in a table of executives, then I want them to see a comprehensive menu set. If they are not in the table, then I want them to see a reduced menu set.
How to go about comparing a cookie with multiple values or keys with a record in a table?
View Replies
View Related
In my Session_OnStart in Global.asa, I am setting some cookies. One
of them, I set as follows:
dim UserID
UserID = Request.ServerVariables("LOGON_USER")
Response.Cookies("User")("ID") = UCASE(UserID)
When I immediately log the cookie value retrieved from
Request.Cookies("User")("ID") into the Windows Event Log, I get the
correct value. However, when I try to retrieve the cookie on the home
page of my application using the same code,
Request.Cookies("User")("ID"), it either cannot find the cookie or
cannot read the value. I am retrieving the cookie before all HTML
headers are written. It is my first statement on the page after
Option Explicit. I have even compared the session IDs. The SessionID
created in the Session_OnStart is the same value as the SessionID on
the home page.
I have read that the Session_OnStart only has access to the
Application, Session and Request objects. It does not explicitly say
that it does not have access to the Response object. Also, I was even
able to use Response.Write's in Global.asa to print out the values
although it looked like it had also stopped the session after I did
so. Cookies are definitely enabled on my machine. I have even tried
setting the session cookie's expiration to be persistent for a few
days to see if it was perhaps expiring before I was able to read it
but this did not work either.
Is there something preventing cookies to be created in Global.asa in
the Session_OnStart sub? Is the Response object not available???
Please let me know if anyone else has had this problem or solution.
View Replies
View Related
I'm just trying to set up a testing server via Dreamweaver that is my local box. HTML works fine and ASP works fine IF there is no js code input. I can save a few images in a table as an ASP page and it works great, but if I try to pull a table from a database, the browser suddenly displays the code, rather than the page.
I've heard some people referring to articles that might address this, but so far I'm not seeing them.
I have .asp files being handled by asp.dll from the internet information services section.
What the heck am I missing? What else should I provide y'all so we can brainstorm this?
View Replies
View Related
I got this book for some time. I need to download the source code for this
book. However, Wrox, the publisher, does not have download code for this
book. Could anybody suggest any site from where I can get the download of
source code for this book?
View Replies
View Related
Is there a way for me to determing if a column exists in the table? ex. I
have RS("var"), where RS is a recordset. My code is dynamic but some tables
will have "var" while some won't.
View Replies
View Related
Is it possible to have an ASP form where there are 2 form fields, each mapped to a separate Access Table? Say for example
Dim rsOne
Dim rsTwo
rsOne mapped to tblOne in Access File Mydb.mdb
rsTwo mapped to tblTwo in Access File Mydb.mdb
View Replies
View Related
i want to left join result sets together coming from two different databases based on a common field storenumber. They are separate databases as per management design.
Basically it should match rows based on the store number, those who don't have matches should display only the storenumber and no other info like: Code:
Store Q1 Q2 Q3 Q4
1 x x x x
2 x x x x
3 <--No data in 3, just display storenumber
4 x x x x
View Replies
View Related
how can i compare 2 record sets. In one RS i have excel file and other RS i have SQL server and when i get the results from both i want to compare them as one of you guys suggested me to write a loop that cycles through the record sets Comparing any fields.
View Replies
View Related
im a passing 3 fields from a form to use a search criteria against an access database table, i have set the fields a numeric values, what should i use to allow all records to be shown for a invidual value rather than a selected value.
Ie the form would pass
Location_id as 22
so the result page would see Request.form("Location_id")
sql would then see
where location_id = var1
var = 22
but i want to get the sql to say
where location_id >=0
what do i need to do
View Replies
View Related
Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.
Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).
I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.
I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:
View Replies
View Related
How can I replace 1 set of double quotes (") with 2 sets ("")
I tried this but it didn't work: myText = replace(myText,""","""")
View Replies
View Related
I'm working on a project, trying to create an HR hiring intranet page. Basically, here is problem. I have a table in a database called "Title Access" that lists titles, and has software, email, and user rights associated with each title. For example, Network Administrator will get Office, Dreamweaver, be part of the IT and Admin groups.
Now, here is the issue: Whenever the user types in the name, pay rate, hire date, and title on the intranet page then clicks "submit", I want the database to create a new user in the "employee" table with that name, and populate the access rights in that table with the rights associated with the title. Thus, the "employee" table will now include "John Doe", and will have Office, Dreamweaver, IT, Admin checked off. Is there any way to do this????????????
View Replies
View Related
I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.
On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.
View Replies
View Related
Is it possible for a user to enable permanent cookies but disable session cookies.....this seems like a contradition yet this is what I appear to be
reading in online articles?
View Replies
View Related
I m creating a cookies in my application and it work properly but i can't see the cookies where it will sotred i checked the cookies folder but i didn't find that I want to create a cookies file as the other web site create and store where other cookies will stored in Cookies folder or Temprory Internet files folder eg:1. arvind@google.co[1].txt this stored in cookies folder 2. arvind@msn[2].txt ....
View Replies
View Related
I am fimliar with asp javascript and not asp VB.
i can display the results ok, but if i return 100 records from my table i would like it to display 5 records per page. i have looked at asp recordset paging on several sites, however cannot find any scripts that work with ASP JAVASCRIPT....
View Replies
View Related
Using IIS 5.0 and sometime some asp pages (absolutely
randomly) showing as blank white pages. So far only one
way of fixing it - restart whole server. Restarting IIS,
or specific web server not helping, only whole server.
I enable server side and client side debugging, but no
errors showing up...
In view source pages always look like this:
-----------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1251"></HEAD>
<BODY></BODY></HTML>
-----------------------
Any idea why it can happened and how to fix?
View Replies
View Related
I'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
View Replies
View Related
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 ?
View Replies
View Related
How do I delete the last character in a string?
View Replies
View Related
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
View Replies
View Related
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 '
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I am always getting cached pages even contents of the page changed on the server but I am getting old page (data).How to solve this.
View Replies
View Related
is it possible to create pages using other pages. Here is an example... Can I make a page that has a menu on it, but the menu is actually a seperate page that I call with ASP?
View Replies
View Related
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?
View Replies
View Related
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 Related
I wonder why my computer with UK settings returns '$' when I call the 'FormatCurrency' function?
View Replies
View Related
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.
View Replies
View Related
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??
View Replies
View Related