Problems with my ASP

nvillare · July 9th, 2003, 02:39 PM

I created my first ASP and followed the directions. I am familiar with VBScript but have not written ASP. I have the page hosted by Brinkster.com and whenever I attempt to launch it an error reads. Can somone please help me?

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Guest Book</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<%
set MyConn=Server.CreateObject("ADODB.Connection")

MyConn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("\nvillare\db\nidia.mdb"))

  mySQL = "SELECT theName, Email, Location, Comments FROM SignIn WHERE Post = "yes" ORDER BY ID DESC"

  set RS = MyConn.Execute(mySQL)

While RS.Eof = false
%>
<table align=center width="80%" border="1" bordercolor="#00CCCC" cellspacing="0" cellpadding="5">
  <tr>
    <td align="center"><%=RS("theName").Value%></td>
  </tr>

  <tr>
        <td align="center"><a href="mailto:<%=RS("Email").Value%>"><%=RS("Email" ).Value%></a></td>
  </tr>

  <tr>
        <td align="center"><%=RS("Location").Value%></td>
  </tr>

  <tr>
        <td align="center"><%=RS("Comments").Value%></td>
  </tr>
</table><p>
<%
   RS.MoveNext
   count = count + 1
   wend

  RS.Close
  RS = null
  MyConn.Close
  MyConn = null
%>
<center>Number of Entries = <%=count%></center>
</body>
</html>

Thanks for your help!

Nidia

NotNowJohn · July 9th, 2003, 03:02 PM

It would be nice if you can provide us an error line, but I guess that mySQL statement could have an error if "Post" field is the type of boolean. In that case you have to use WHERE Post =yes instead of WHERE Post = "yes"...

HTH

...but the Soon is eclipsed by the Moon

nvillare · July 9th, 2003, 03:11 PM

Thanks so much. That did it, know it works!

Nidia