NetKnave 's BLog

<script language="javascript">  
var conn = new ActiveXObject("ADODB.Connection");
//var sqlstr="Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa;Password=; Initial Catalog=pubs";
var sqlstr="Provider=SQLOLEDB;Data Source=localhost;UID=sa;PWD=;database=pubs";
conn.Open(sqlstr);
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from authors";
rs.open(sql,conn);
shtml = "<table width=\'100%\' border=1>";    
shtml +="<tr bgcolor=\'#f4f4f4\'><td>au_id</td><td>au_lname</td><td>au_fname</td><td>phone</td><td>address</td><td>city</td><td>state</td><td>zip</td></tr>";    
while(!rs.EOF)    
{
shtml +="<tr><td>" + rs("au_id") + "</td><td>" + rs("au_lname") + "</td><td>" + rs("au_fname") + "</td><td>" + rs("phone") + "</td><td>" + rs("address") + "</td><td>" + rs("city") + "</td><td>" + rs("state") + "</td><td>" + rs("zip") + "</td></tr>";    
rs.moveNext;
}
shtml +=   "</table>";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
</script>