Re: ASP Database Help

Thanks to all who responded. I have another problem.
Here is my new error:

----------
Microsoft VBScript compilation error '800a0400'

Expected statement

/guestbook.asp, line 28

End If
^
-----------

I do have a little experince with ASP, but not too much.

I have taken out some things from my last code posting, so here is my new
code:

------
<.%
 set conn = server.createobject("ADODB.connection")
 DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
 DSNtemp = dsntemp & "DBQ=" & server.mappath("guestbook.mdb") & "}"

 sqlstmt = "SELECT * from linksdata ORDER BY date DESC"
 set rs = Server.CreateObject("ADODB.Recordset")
rs.open sqlstmt, conn, 3, 3

             name = rs("name")
             date = rs("date")
             email = rs("email")
             email = "<a href='malto:" & email & "'>" & website & "</a>"
             website = rs("website")
             website = "<a href='" & website & "'>" & website & "</a>"
             comments = rs("comments")
             webname = rs("WebName")

 %.>
<.%
  rs.MoveNext

End If
  Next


 %.>
---------

Thanks for any help!

Matthew

HTML: hwg-basics mailing list archives, maintained by Webmasters @ IWA