fejl i nyhedsscript, øv!
Hej,hvad er fejlen i dette script?
<%
sub getnewsheadlines(byval noofnews ,byval noofchar)
nonews = noofnews
chars = noofchar
response.write ("<h1>Nyhedsoversigt</h1>")
sql="select * from news order by dato desc"
Set news = conn.execute(sql)
'Vi henter det antal nyheder du har ønsket på forsiden sorteret, så de nyeste komemr først
i=1
do while not i > nonews
if not news.eof then
response.write("<a href='")
response.write("default.asp?mode=show&id=" & news("id"))
response.write("'>")
response.write(news("overskrift"))
response.write("</a> Tilføjet d. ")
response.write(news("dato"))
response.write("<br>")
response.write(left(news("tekst"), chars) & "...")
response.write("<br><br>")
news.movenext
end if
i=i+1
loop
response.write("<a href='default.asp?mode=arkiv'>Læs arkiverede nyheder</a>")
end sub
sub printarticle(byval id)
sql="select * from news where id=" & id
set article = conn.execute(sql)
response.write("<h1>" & article("overskrift") & "</h1>")
response.write(article("tekst"))
response.write("<br><br>" & "<a href=""default.asp"">Tilbage til oversigten</a>")
end sub
sub printarchive(byval noofnews ,byval noofchar)
nonews = noofnews
chars = noofchar
response.write ("<h1>Nyhedsarkiv</h1>")
sql="select * from news order by dato desc"
Set news = conn.execute(sql)
' hopper 5 poster frem
for count=0 to 5
news.movenext
next
do while not news.eof
if not news.eof then
response.write("<a href='")
response.write("default.asp?mode=show&id=" & news("id"))
response.write("'>")
response.write(news("overskrift"))
response.write("</a> Tilføjet d. ")
response.write(news("dato"))
response.write("<br>")
response.write(left(news("tekst"), chars) & "...")
response.write("<br><br>")
news.movenext
end if
loop
response.write("<br><br>" & "<a href=""default.asp"">Tilbage til oversigten</a>")
end sub
%>
Fejlmeldingen kan ses på http://nof.dk/nyheder/default.asp?mode=arkiv
/nof
