Using MS Access with Dreamweaver MX

Computing.Net > Forums > Web Development > Using MS Access with Dreamweaver MX

Using MS Access with Dreamweaver MX

Original Message

Name: mabi
Date: September 8, 2005 at 13:50:36 Pacific
Subject: Using MS Access with Dreamweaver MX
OS: Win XP
CPU/Ram: P4, 512

Comment:

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

Report Offensive Message For Removal

Response Number 1

Name: suspect52732
Date: September 9, 2005 at 21:10:41 Pacific
Subject: Using MS Access with Dreamweaver MX

Reply: (edit)

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 Offensive Follow Up For Removal


Dreamweaver MX Updates validate form with rollover button Can I disable mouse wheel scrolling Split a table in Dreamweaver MX MS Access to SQL	how to zoom web page w/ mouse over PHP/MySQL include dreamweaver login creating embedding webpage Buttons in Dreamweaver and Flash mx

My links don't work!

PHP Nuke be messin with m...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Using MS Access with Dreamweaver MX

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How often do you use Computing.Net?

Poll Finishes In 3 Days.
Discuss in The Lounge

Xbox Wireless 360 help

Running windows 98 game on xp

Games for Windows disc problem

Google Redirect

Your computer has been infected

All Posts Awaiting Replies