Avatar billede freedom Nybegynder
24. december 2001 - 14:10 Der er 1 kommentar og
1 løsning

lille hejl arhhhhh hjælp !!!!:)

Hej jeg har roet med denne fejl i flere dage arhhh. Kan nogen finde den. Fejlen er:
fejl \'80020009\'
Undtagelse opstod.

/totalmobil/nyheder.asp, linje 81
Mit script er:
<head><link rel=\"stylesheet\" type=\"text/css\" href=\"stylesheet.css\">
<%


    Set Conn = Server.CreateObject(\"ADODB.Connection\")
    DSN = \"DRIVER={Microsoft Access Driver (*.mdb)};\"
    DSN = DSN & \"DBQ=\" & Server.MapPath (\"databaser/menu.mdb\")
    Conn.Open DSN


If request.Querystring(\"mode\") = \"lang\" Then
strSQL = \"Select * from nyheder where id=\" & request.querystring(\"id\")
    Set rs = Conn.Execute(strSQL)
If rs.EOF Then
Response.write \"fejl. Jeg beklarer! ;(\"
Else
Response.write \"<fieldset><legend>Nyheder:</legend>\"
response.Write \"<table cellpadding=0 cellspacing=0 class=menu width=300 \"
response.Write \"<tr><td class=nyhed><div class= underskrift>\" & rs(\"over\") & \"</div></tr></td><td class=nyhed><div class= underskrift1><right>\" & rs(\"skrevet\") & \"</right></div></td></tr>\"
Response.write \"<tr><td class = menu2>Skrevet af: <td class = menu2>\" & rs(\"af\") & \".</tr>\"
Response.write \"<tr><td class = menu2>\" & rs(\"af\") & \" Har skrevet: <td class = menu2>\" & rs(\"lang\") & \"</td></tr>\"
Response.write \"<p><br></table><p>\"
End if
Else
    strSQL = \"Select * from nyheder\"
    Set rs = Conn.Execute(strSQL)

    If rs.EOF Then
Response.write \"fejl. Jeg beklarer! ;(\"
Else
Response.write \"<fieldset><legend>Nyheder:</legend>\"
Do
response.Write \"<table cellpadding=0 cellspacing=0 class=menu width=300 \"
response.Write \"<tr><td class=nyhed><div class= underskrift><a href = \"\"nyheder.asp?mode=lang&Id=\"
response.Write rs(\"Id\")
response.Write \"\"\">\"
response.Write \"\" & rs(\"over\") & \"</a>\"
response.write \"</div></tr></td><td class=nyhed><div class= underskrift1><right>\" & rs(\"skrevet\") & \"      </right>\"
If session(\"admin\") = \"ja\" Then
Response.write \"<a href =\"\"nyheder.asp?mode=opdater&id=\"
Response.write rs(\"id\")
Response.write \"\"\">(Rediger)</a>\"
Else
End if
response.write \"</div></td></tr>\"
Response.write \"<tr><td class = menu2>Skrevet af: <td class = menu2>\" & rs(\"af\") & \".</tr>\"
Response.write \"<tr><td class = menu2>\" & rs(\"af\") & \" Har skrevet: <td class = menu2>\" & rs(\"kort\") & \"</td></tr>\"
Response.write \"<p><br></table><p>\"
rs.MoveNext
Loop While Not rs.EOF
Response.write \"</fieldset>\"
End if End if
If session(\"admin\") = \"ja\" and request.querystring(\"mode\") = \"ny\" Then
Response.write \"<p><fieldset><legend>Indsæt Nyhed:</legend>\"
response.Write \"<FORM method=\"\"post\"\" action = \"\"nyheder.asp?mode=opret\"\">\"
Response.write \"Kort:<input type=\"\"text\"\" value=\"\"\"\" name=\"\"kort\"\"><br>\"
Response.write \"Lang:<input type=\"\"text\"\" value=\"\"\"\" name=\"\"lang\"\"><br>\"
Response.write \"Skrevet den (23-20-20):<input type=\"\"text\"\" value=\"\"\" & FormatDateTime(Now, vbShortDate) & \"\"\" name=\"\"skrevet\"\"><br>\"
Response.write \"Af:<input type=\"\"text\"\" value=\"\"Admin\"\" name=\"\"af\"\"><br>\"
Response.write \"overskrift:<input type=\"\"text\"\" value=\"\"\"\" name=\"\"over\"\"><br>\"
Response.write \"<input type=\"\"submit\"\" value=\"\"Gem\"\" id=\"\"submit\"\"><br>\"
Response.write \"</fieldset>\"
Response.write \"</form>\"
Else if session(\"admin\") = \"ja\" and request.querystring(\"mode\") = \"opret\" Then
strKort = Request.Form(\"kort\")
strLang = Request.Form(\"lang\")
strSkrevet = Request.Form(\"skrevet\")
strAf = Request.Form(\"af\")
strOver = Request.Form(\"over\")

sql = \"INSERT INTO nyheder (kort, lang, skrevet, af, over) values (\"
sql = sql & \"\'\" & strKort & \"\',\"
sql = sql & \"\'\" & strLang & \"\',\"
sql = sql & \"\'\" & strSkrevet & \"\',\"
sql = sql & \"\'\" & strAf & \"\',\"
sql = sql & \"\'\" & strOver & \"\')\"
Set rs = Conn.ExeCute(sql)
response.write sql
Else if session(\"admin\") = \"ja\" and request.querystring(\"mode\") = \"opdater\" Then
strSQL = \"Select * from nyheder where Id = \'\" & request.querystring(\"id\") & \"\'\"
Response.write \"<p><fieldset><legend>Rediger \" & rs(\"over\") & \"</legend>\"
response.Write \"<FORM method=\"\"post\"\" action = \"\"nyheder.asp?mode=ny_opret\"\">\"
Response.write \"Kort:<input type=\"\"text\"\" value=\"\"\" & rs(\"kort\") & \"\"\" name=\"\"kort\"\"><br>\"
Response.write \"Lang:<input type=\"\"text\"\" value=\"\"\" & rs(\"lang\") & \"\"\" name=\"\"lang\"\"><br>\"
Response.write \"Skrevet den (23-20-20):<input type=\"\"text\"\" value=\"\"\" & rs(\"skrevet\") & \"\"\" name=\"\"skrevet\"\"><br>\"
Response.write \"Af:<input type=\"\"text\"\" value=\"\"\" & rs(\"af\") & \"\"\" name=\"\"af\"\"><br>\"
Response.write \"overskrift:<input type=\"\"text\"\" value=\"\"\" & rs(\"over\") & \"\"\" name=\"\"over\"\"><br>\"
Response.write \"<input type=\"\"submit\"\" value=\"\"Gem\"\" id=\"\"submit\"\"><br>\"
Response.write \"</fieldset>\"
Response.write \"</form>\"
Else if session(\"admin\") = \"ja\" and request.querystring(\"mode\") = \"ny_opret\" Then
strKort = request.Form(\"kort\")
strLang = request.Form(\"lang\")
strSkrevet = request.Form(\"skrevet\")
strAf = request.Form(\"af\")
strOver = request.Form(\"over\")
strId = request.querystring(\"id\")
sql = \"Update nyheder set \"
sql = sql & \"kort=\'\" & strKort & \"\',\"
sql = sql & \"lang=\'\" & strLang & \"\',\"
sql = sql & \"skrevet=\'\" & strSkrevet & \"\',\"
sql = sql & \"af=\'\" & strAf & \"\',\"
sql = sql & \"over=\'\" & strOver & \"\'\"
sql = sql & \"Where Id = \'\" & strId & \"\'\"
Set rs = Conn.ExeCute(sql)
Else
End if end if end if
Conn.Close
Set Conn = Nothing
End if
%>

linje 81 er
Response.write \"<p><fieldset><legend>Rediger \" & rs(\"over\") & \"</legend>\"

Arhhh det er sikkert bare en stave fejl!!! :( hjælp!!!

Avatar billede somaliomar Praktikant
24. december 2001 - 15:43 #1
Har du prøvet at omskrive linjen til:

%><p><fieldset><legend>Rediger <% Response.Write rs(\"over\") %></legend><%
Avatar billede freedom Nybegynder
22. januar 2002 - 17:28 #2
FANDT DEN SELV
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester