I am new to DW MX. Trying to get a simple database to display records. I do the steps detailed in the tutorials and the query tests good (displays the desired records). However, when I upload the web page and view in a browser the page is blank. Any help would be appreciated ...Thanks <head>
<title>Title here</title>
<link href="../css/style.css" rel="stylesheet" type="text/css" media="all" />
</head><body>
<div id="contain">
<div id="content">
<div id="js"> <script type="text/javascript" src="../js/1.js"></script></div>
<div id="arc">
<h2>Here</h2><%@LANGUAGE="VBSCRIPT"%>
<%
Dim first
Dim first_numRowsSet first = Server.CreateObject("ADODB.Recordset")
first.ActiveConnection = MM_first_STRING
first.Source = "SELECT Time, Date, Town, State first ORDER BY Time DESC"
first.CursorType = 0
first.CursorLocation = 2
first.LockType = 1
first.Open()first_numRows = 0
%>
<table width="450px" border="1" cellpadding="2" cellspacing="2">
<tr>
<td>Time</td>
<td>Date</td>
<td>Town</td>
<td>State</td>
</tr>
<tr>
<td><%=(first.Fields.Item("Time").Value)%></td>
<td><%=(first.Fields.Item("Date").Value)%></td>
<td><%=(first.Fields.Item("Town").Value)%></td>
<td><%=(first.Fields.Item("State").Value)%></td>
</tr>
</table> </div>
</div></div>
</div></body>
</html><%
first.Close()
Set first = Nothing
%>
Well, you probably havnt had a response because this is a little difficult to troubleshoot. I just took a class on Dreamweaver and Access, ASP.NET. I think you would have a much easier time using FrontPage and asp, although alittle different, it is driven by simple to follow wizards. If its a must to use dreamweaver, I would check that you are uploading the local file to the remote site, then switch to remote view and open that uploaded file, then view it. Also look at this:
------<%@LANGUAGE="VBSCRIPT"%>
<%
Dim first
Dim first_numRowsSet first = Server.CreateObject("ADODB.Recordset")
first.ActiveConnection = MM_first_STRING
first.Source = "SELECT Time, Date, Town, State first ORDER BY Time DESC"
first.CursorType = 0
first.CursorLocation = 2
first.LockType = 1
first.Open()first_numRows = 0
%><head>
<title>Title here</title>
<link href="../css/style.css" rel="stylesheet" type="text/css" media="all" />
</head><body>
<div id="contain">
<div id="content">
<div id="js"> <script type="text/javascript" src="../js/1.js"></script></div>
<div id="arc">
<h2>Here</h2>
<table width="450px" border="1" cellpadding="2" cellspacing="2">
<tr>
<td>Time</td>
<td>Date</td>
<td>Town</td>
<td>State</td>
</tr>
<tr>
<td><%=(first.Fields.Item("Time").Value)%></td>
<td><%=(first.Fields.Item("Date").Value)%></td>
<td><%=(first.Fields.Item("Town").Value)%></td>
<td><%=(first.Fields.Item("State").Value)%></td>
</tr>
</table> </div>
</div></div>
</div></body>
</html><%
first.Close()
Set first = Nothing
%>
