Using MS Access with Dreamweaver MX

September 8, 2005 at 13:50:36
Specs: Win XP, P4, 512

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_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> </div>
</div></div>
</div>

</body>
</html>

<%
first.Close()
Set first = Nothing
%>


See More: Using MS Access with Dreamweaver MX

Report •


#1
September 9, 2005 at 21:10:41

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_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
%>

<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
%>


Report •
Related Solutions


Ask Question