Hi
I am using this in order to send data to asp page, and then the data is insert into MDB (access) database
the problem that if the data I send is not in english, I see in the table only "????"
this is the B4A code:
and this is the ASP code
Any idea what & where is the issue?
I am using this in order to send data to asp page, and then the data is insert into MDB (access) database
the problem that if the data I send is not in english, I see in the table only "????"
this is the B4A code:
B4X:
Dim Post As HttpJob
Post.Initialize ("Post" , Me)
Post.Download (MyServerAddress & "/MissingWords.asp?Name=" & name & "&FileName=" & fname)
and this is the ASP code
B4X:
<html>
<head>
<title>Update Entry Select</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1255">
</head>
<body bgcolor="white" text="black">
<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim MyRS 'Holds the recordset for the records in the database
Dim strSQL 'Holds the SQL query for the database
'Create an ADO connection object
Dim Name
Dim FileName
Name=Request.QueryString("name")
FileName=Request.QueryString("FileName")
Set adoCon = Server.CreateObject("ADODB.Connection")
'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("MissingWords.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO recordset object
Set MyRS = Server.CreateObject("ADODB.Recordset")
If Name <> "" then
strSQL = "INSERT INTO Words(Word, FileName) VALUES ('" & Name & "', '" & FileName & "')"
end if
MyRS.Open strSQL, adoCon
'Reset server objects
' if Name="CLOSEDB" then
MyRS.Close
Set MyRS = Nothing
Set adoCon = Nothing
' end if
%>
ok
</body>
</html>
Any idea what & where is the issue?