Multilingual entries into a DB and to be displayed on IIS

Allows for multilingual entries into a DB and to be displayed on IIS. The interface is not multi but could be pulled from the DB if you knew what language they wanted before hand....only a proof of concept...This article includes two files.

Contributed by Chris_Schneider
Rating:

/ 11
June 17, 2003

Rate this Article:
MEH MEH++

SEARCH ASP FREE


<HTML>
<BODY>

<%
Response.CharSet = "utf-8"

Set Conn_test = Server.CreateObject("ADODB.Connection")
Conn_test.Open "Provider=SQLOLEDB;SERVER=AUSADSNTSTDB1;UID=;PWD=;Database=Test"

Set rstest = Conn_test.Execute("select * from test")

Do While NOT rstest.EOF

response.write "ID:" & rstest("TestID") & "
"
response.write "Data:" & rstest("data") & "
"

rstest.MoveNext 
Loop

Set Conn_test = nothing
%>

<form name="frmSvcTag" method=post action="testprocess.asp">

<INPUT type="text" title='Enter the string to be placed in the DB' name=Data>
<INPUT type="submit" value="Go" name="submit">

</form>


</BODY>
</HTML>

[bold]TestProcess.asp[/bold]

<%@ CodePage=65001 Language="VBScript"%>

You gave this...
<%
Response.CharSet = "utf-8"

Response.Write Request.Form("Data")

Set Conn_test = Server.CreateObject("ADODB.Connection")
Conn_test.Open "Provider=SQLOLEDB;SERVER=AUSADSNTSTDB1;UID=;PWD=;Database=Test"

Set rstest = Conn_test.Execute("INSERT Test Values(N'" & Request.Form("Data") & "')")

Set rsTest = nothing
Set Conn_test = nothing

%>

<form name="frmSvcTag" method=post action="test.asp">
<INPUT type="submit" value="See From DB?" name="submit">
</form>