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. [bold]Test.asp[/bold]<%@ CodePage=65001 Language="VBScript"%>
<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>
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Database Code Articles More By Chris_Schneider developerWorks - FREE Tools! | Join this Rational Talks to You teleconference, featuring Paul Boustany and Mark Krasovich, to speak to the experts about becoming a Rational ClearCase power user. Get a chance to ask your questions and learn tips and tricks for using Rational ClearCase in Agile development FREE! Go There Now!
| | | | Learn to enable users to both rate existing animations and to combine existing animations into new snippets. This is the third in a series of three tutorials that chronicle the building of a site that enables collaborative discussion and animation building using Domino and OpenLaszlo. FREE! Go There Now!
| | | | Download the Rational Application Developer (RAD) v7.5 open beta code and start developing applications for the JEE5 standard which features EJB3.0, JPA, JSF 1.2, JSP 2.1 and Servlet 2.5 standards. When you use this beta you will see how you can increase developer productivity for already existing applications with improved support for refactoring, as well as adding new features to existing applications. In addition, the beta provides tooling for JD Edwards, Oracle, SAP, Siebel and PeopleSoft to improve the developer productivity with these enterprise systems. FREE! Go There Now!
| | | | Visit IBM developerWorks to download IBM DB2 Express-C 9.5, a no-charge version of DB2 Express 9 database server. DB2 Express-C offers the same core data server base features as other DB2 Express editions and provides a solid base to build and deploy applications developed using C/C++, Java, .NET, PHP, and other programming languages. FREE! Go There Now!
| | | | Download a free trial version of IBM Rational Developer for System z, software that can help you deliver core development capabilities; the power of Java Platform, Enterprise Edition (Java EE); and rapid application development support to diverse enterprise application development teams. With comprehensive development tools to help create, deploy and maintain traditional enterprise and composite applications, Rational Developer for System z enables developers with different technical backgrounds to easily participate in important technology projects. FREE! Go There Now!
| | | | Visit IBM developerWorks to download a free trial version of IBM Rational Business Developer V7.1. Rational Business Developer offers rapid and simplified development of business applications and services through Enterprise Generation Language (EGL) tools, generating Java or mainframe solutions while shielding developers from technical complexities. FREE! Go There Now!
| | | | Visit IBM developerWorks to download a free trial version of WebSphere Extended Deployment Compute Grid, which lets you schedule, execute, and monitor batch jobs. Because online transaction processing and batch jobs execute simultaneously on the same server resources, you can avoid costly duplication of resources. Compute Grid supports job types of Java transactional batch, compute-intensive and a new type called "native execution", which enables non-Java workloads to run on distributed end points. FREE! Go There Now!
| | | | Join this Rational Talks to You teleconference on December 6 at 1:00 pm ET to participate in an agile application development discussion and get your questions answered on using IBM Rational Method Composer in a distributed environment.Get your questions answered! FREE! Go There Now!
| | | | Because access to government information continues to be an area of concern for many U.S. citizens with disabilities, the U.S. government enacted Section 508 of the Rehabilitation Act in 2001 to ensure that government agencies create accessible Web content, enabling all citizens to access the information they need. A fully accessible Web site makes Web content accessible to all individuals, including those with disabilities, who may be accessing Web content via a variety of user agents. Common user agents include standard Web browsers, text-only browsers, assistive devices and mobile devices such as cell phones or personal digital assistants (PDAs). FREE! Go There Now!
| | | | Join this webcast to discover the key requirements for successful change and release management. Learn how to extend your .NET environment to improve productivity and collaboration, and address core problems afflicting team development. In this webcast, we’ll review typical challenges faced by customers and how to resolve them with the IBM Rational Change and Release Management solution, including Rational ClearCase, Rational ClearQuest and Rational Build Forge. Replay is available for 9 months. FREE! Go There Now!
| | | | All FREE IBM® developerWorks Tools! | |