<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<script language=javascript src="SoftXMLLib.js"></script>
<script language=javascript src="json.js"></script>
<script language=javascript src="SoftXMLDB.js"></script>
<script language=javascript>
<!--
var XMLLib = new SoftXMLLib();
var ajaxObj = XMLLib.createAjaxObject();
var content = new SoftXMLDB;
content.ConnectionString="provider=SQLOLEDB;data source=server name;initial catalog=database name;user id=username;password=password;";
content.SQL="SELECT organization_name,organization_url from Organizations";
content.contentID="mycontent2";
function execute(){
content.Open();
}
//-->
</script>
</head>
<body onload="execute();">
<form id="myform"></form>
<div style="color:white;background-color:red;display:none;border:1px solid black;width:135px;height:30px;font-family:arial;font-size:12px" id="s"></div><br>
<table cellpadding="0" cellspacing="0" border="0" ID="Table1">
<tr>
<td id="mycontent2"></td>
</tr>
</table>
</body>
</html>
In this example we use onload event to query database and place results in td with id="mycontent2"