2
Hi All,
I was not sure which forum to post the message to since the problem related to ASP/AJAX, but decided to post it here.
I have a simple routine which utilizes an Ajax to query database for keywords presence in database and returns matched records count. Below is the code for 2 pages. First page would take an input, post to the second via ajax and displays the returned message.
Everything works fine when I use keywords contained Latin characters. The problem is, that when I try Cyrillic strings, no match is found via ajax although it would work by directly posting to the page2 from page1 via “Submit” button. Cyrillic data in db is encoded as Windows-1251.
I have not worked much with multilingual support in the past. Now I wonder how to make this to work. The data posted via xmlHttp is converted to Unicode. What should I do to properly decode posted data at second page before issuing an sql query?
page1.asp
[HTML]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body>
<form method="post" action="page2.asp">
<input type="text" id="T1" name="T1" size="20">
<input type="submit" value="Submit" name="B1">
<input type="button" value="Ajax" name="B2" onclick="ajaxOptions('T1='+document.getElementById ('T1').value,'ret','page2.asp');">
<div id="ret"> </div>
</form>
<script language="javascript">
<!--
var xmlHttpObj, LayerID
function ajaxOptions(strArgs,divID,page){
LayerID=divID;
xmlHttpObj=BindXmlHttp();
if (xmlHttpObj==null){
document.getElementById(LayerID).innerHTML="Ajax is not supported";
return;
}
var asURL=page;
asURL=asURL+"?rnd="+Math.random();
xmlHttpObj.onreadystatechange=checkState;
xmlHttpObj.open("POST",asURL,true);
xmlHttpObj.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
//xmlHttpObj.setRequestHeader("Content-type", "application/x-www-form-urlencoded;charset=Windows-1251");
xmlHttpObj.send(strArgs);
}
function checkState() {
if (xmlHttpObj.readyState==4){
document.getElementById(LayerID).innerHTML=xmlHttp Obj.responseText;
xmlHttpObj=null;
}
}
function BindXmlHttp(){
var xmlHttpObj=null;
try{
xmlHttpObj=new XMLHttpRequest();
}
catch (err)
{
try{
xmlHttpObj=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (err)
{
xmlHttpObj=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttpObj;
}
//-->
</script>
</body>
</html>
[/HTML]
page2.asp
[HTML]
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<%
testKey = Request.Form("T1")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strConn = strConn & Server.MapPath("test.mdb") & ";"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strConn
str_sql = "SELECT Count(*) FROM tblkey WHERE testkey = '" & testKey & "';"
result_count = objConn.Execute(str_sql)(0)
Response.Clear
Response.Write "Found " & result_count & " records"
objConn.Close
Set objConn = Nothing
%>
[/HTML]
