Hello I am connecting to a Database and displaying the contents in an ASP page the page loads fine but as soon as I refresh the page i get an error and it says the error is this line of code
I am not sure what the problem is..
Here is the whole page code
Code:
recordSet1.Open("select * from Message;" , "DSN=wedding");Here is the whole page code
Code:
<%@ LANGUAGE="JScript"%>
<html>
<head>
<link href="style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="script.js"></script>
<title>Guest Book</title>
</HEAD>
<%
var recordSet1 = Server.CreateObject("ADODB.RecordSet");
recordSet1.Open("select * from Message;" , "DSN=wedding");
%>
</head>
<body topmargin="0" bgcolor="#FFFFFF">
<img src="Images/mainbanner.jpg"><br>
<div class="leftDIV" style="background:url(Images/leftBG.jpg)">
<br>
<div>
<a href="index.html" onMouseOver="changeImages('image2', 'image2on')" onMouseOut="changeImages('image2', 'image2off')"><img src="images/HomeButton1.jpg" name="image2" style="border:none"></a>
</A><br>
<a href="Venu.html" onMouseOver="changeImages('image1', 'image1on')" onMouseOut="changeImages('image1', 'image1off')"><img src="images/Venu1.jpg" name="image1" style="border:none"></a>
</A>
<br>
<a href="Pics.html" onMouseOver="changeImages('image3', 'image3on')" onMouseOut="changeImages('image3', 'image3off')"><img src="images/Pics1.jpg" name="image3" style="border:none"></a>
</A>
<br>
<a href="Slang.html" onMouseOver="changeImages('image4', 'image4on')" onMouseOut="changeImages('image4', 'image4off')"><img src="images/Slang1.jpg" name="image4" style="border:none"></a>
</A>
<br>
<a href="Registery.html" onMouseOver="changeImages('image5', 'image5on')" onMouseOut="changeImages('image5', 'image5off')"><img src="images/Registry1.jpg" name="image5" style="border:none"></a>
</A>
<br>
<a href="Blog.html" onMouseOver="changeImages('image6', 'image6on')" onMouseOut="changeImages('image6', 'image6off')"><img src="images/Blog1.jpg" name="image6" style="border:none"></a>
</A>
<br>
<a href="Contact.html" onMouseOver="changeImages('image7', 'image7on')" onMouseOut="changeImages('image7', 'image7off')"><img src="images/Contact1.jpg" name="image7" style="border:none"></a>
</A>
<br>
</div>
</div>
<div class="Blog">
This is Where you can 'Sign' the guest book and leave messages if you want.
<input type="button" onClick="parent.location='addGuest.asp'" value="Add Message"><br>
<%
while(!recordSet1.EOF)
{
%>
<tr>
<td><%=recordSet1("Date")%></td><br>
<td><%=recordSet1("Message")%></td><br>
<td><%=recordSet1("Name")%></td><br><hr>
<%
recordSet1.MoveNext();
}
recordSet1.Close();
%>
</script>
</div>
</div>
</body>
</html>