I am trying to publish a few of my tables and queries as active server pages so that I can view them via the internet no matter where I am. In order to proceed further with this project, I have to sell my management on the idea. I want to take a couple tables and queries and transform them into *.asp format and then view them through internet explorer on my computer.
I exported a table from my database and did all of the ODBC work so that it references my database. However, when I go to view it via iexplorer, it opens my dreamweaver program. I select "Preview in Browser" from the file menu and the headings to the table come up, however none of the data comes up. Any ideas how I get the data from the table as well? By the way, the table is entitled "Products" and lists products used within the landscaping industry. Below is the code I copied out of dreamweaver. Thanks!
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
If IsObject(Session("clark_conn")) Then
Set conn = Session("clark_conn")
Set conn = Server.CreateObject("ADODB.Connection")
Set Session("clark_conn") = conn
If IsObject(Session("Products_rs")) Then
Set rs = Session("Products_rs")
sql = "SELECT * FROM [Products]"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
If rs.eof Then
Set Session("Products_rs") = rs
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Arial" COLOR=#000000><CAPTION><B>Products</B></CAPTION></FONT>