ok. i’m a newb to asp, but here it goes
im making a news updater thinger.
heres the code i have so far.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("news/news.mdb")
set RS = Conn.Execute("SELECT TOP 3 * FROM updates ORDER BY date DESC;")
DO UNTIL RS.eof
id = RS("id")
date = RS("date")
title = RS("title")
body = RS("body")
user = RS("user")
response.write "<div class=""asset""><strong>"& title & "<br><br><strong>"& date & "- by </strong>"& user &"<br><br>"& body &"</div>"
RS.movenext
LOOP
%>
<%
RS.close
set RS = nothing
Conn.close
set Conn = nothing
%>
now, with my luck, the whole thing will be wrong.
it turns up the error…
[font=Arial] [/font]
Microsoft VBScript compilation error[font=Times New Roman][size=3]- [/size][/font][font=Arial][size=2]Error '800a040e'[/size][/font][font=Times New Roman][size=3] [/size][/font]
[font=Arial][size=2]'loop' without 'do'[/size][/font]
[font=Arial][size=2]/home.asp[/size][/font][font=Arial][size=2], line 72[/size][/font] LOOP^
thanks for any help.
-Naaman
