PDA

View Full Version : Where are the records?


mabi
09-08-2005, 09:24 PM
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


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">

<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>
<span style='color:red'>
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/first.asp" -->
<%
Dim first
Dim first_numRows

Set 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></span> </div>
</div></div>
</div>

<!--#include file="/inc/foot.txt" -->

</body>
</html>

<span style='color:red'><%
first.Close()
Set first = Nothing
%></span>

ranjan
09-08-2005, 10:57 PM
Is it blank or do you see ONE record?

Check the tuts for repeat region server behavior

mabi
09-09-2005, 03:14 AM
It is a blank page where the database results should be.