The basics are
1) Create an ActiveX ODBC connection object to the sql server
2) Create an ActiveX ODBC recordset object to store the data into
3) Write an SQL query int a string variable
4) Excute the query with the connection object and recieve the records into the recordset object
5) Loop through the recordset object and using document.write send the data to the user in a standard html table.
Thats the basics, for more detail you will need to provide more detail.
Or search google with some of the above terms
Regards and good luck. Its tough but possible. I taught myself with the help of google and websites such as this one. You just need to be more specific with your questions. ;)
|