01. oktober 2002 - 15:28Der er
28 kommentarer og 1 løsning
hjælp:
Fejltype: Der opstod en Microsoft VBScript-kompileringsfejl (0x800A03EA) Der er en syntaksfejl /ind/vare.asp, line 44 else if request.QueryString("punkt") = "2" Then
ok... først sagde den der var for lidt end if... og jeg lagde nogen ind if request.QueryString("punkt") = "1" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs = Conn.Execute(SQL) If rs.eof Then response.write "fejl!" Else if rs("regi") = True Then response.write "ordren er allerede været igen dette.." else strNavn = rs("brugernavn") SQL = "Select * from kassen where brugernavn ='"& strNavn & "'" Set rs = Conn.Execute(SQL) If rs.EOF Then response.write "ingen varer!:(" else strNavn = rs("brugernavn") strVareid = rs("vare_id") strAntal = rs("antal") Do SQL2 = "Select * from varer where ID = "& strVareid Set rs2 = Conn.Execute(SQL2) strPrisen = rs2("pris") strPris = rs2("pris") * strAntal strPrisSamlet = strPrisSamlet + strPris response.write "<form ACTION=""vare.asp?rediger=ja&id=" & rs("id") & """ name=""form1"" method=""POST"">" Response.Write rs2("varenavn") & " antal: <input type=text name=antal value=" & rs("antal") & "> <input type=""submit"" name=""Submit"" value=""ændre""> pris : " & strPris &"<a href=""vogn_i.asp?slet=ja&id=" & rs("ID") & """>slet..</a><br></form>" rs.MoveNext Loop While Not rs.EOF response.write "<p>pris:" & strPrisSamlet & "." response.write "<a href=""vare.asp?punkt=2&id=" & request.QueryString("id") & """>ok.. registrere.." end if end if end if end if end if elseif request.QueryString("punkt") = "2" Then
hjælp.. for en fejl hvis jeg fjerner de end if??
Synes godt om
Slettet bruger
01. oktober 2002 - 15:35#8
du har en mere af dem her:
response.write "fejl!" Else if rs("regi") = True Then response.write "ordren er allerede været igen dette.."
Du kan jo ikke bare sætte end if'er ind som det passer dig... Nu ved jeg ikke om det passer med antallet men kan da se at du har en Else if mere som stadig væk skal være elseif.
vil i havde hele koden??: i denne har jeg slette nogen end if som giver denne fejl: 'End' var ventet /ind/vare.asp, line 41 elseif request.QueryString("punkt") = "2" Then
koden: <!--#include file="1.asp"--> <% if session("admin") <> "ja" Then response.write "Dette er kun for admins!!!" ELSE Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("butik.mdb") Conn.Open DSN if request.QueryString("punkt") = "1" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs = Conn.Execute(SQL) If rs.eof Then response.write "fejl!" Else if rs("regi") = True Then response.write "ordren er allerede været igen dette.." else strNavn = rs("brugernavn") SQL = "Select * from kassen where brugernavn ='"& strNavn & "'" Set rs = Conn.Execute(SQL) If rs.EOF Then response.write "ingen varer!:(" else strNavn = rs("brugernavn") strVareid = rs("vare_id") strAntal = rs("antal") Do SQL2 = "Select * from varer where ID = "& strVareid Set rs2 = Conn.Execute(SQL2) strPrisen = rs2("pris") strPris = rs2("pris") * strAntal strPrisSamlet = strPrisSamlet + strPris response.write "<form ACTION=""vare.asp?rediger=ja&id=" & rs("id") & """ name=""form1"" method=""POST"">" Response.Write rs2("varenavn") & " antal: <input type=text name=antal value=" & rs("antal") & "> <input type=""submit"" name=""Submit"" value=""ændre""> pris : " & strPris &"<a href=""vogn_i.asp?slet=ja&id=" & rs("ID") & """>slet..</a><br></form>" rs.MoveNext Loop While Not rs.EOF response.write "<p>pris:" & strPrisSamlet & "." response.write "<a href=""vare.asp?punkt=2&id=" & request.QueryString("id") & """>ok.. registrere.." end if
elseif request.QueryString("punkt") = "2" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs2 = Conn.Execute(SQL) If rs.eof Then response.write "fejl!" Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else
sql = "Update kategorier Set regi = True Where ID = "& request.QueryString("id") set rs = Conn.Execute Response.write "det gik.... følende ting skal i pakken: <p>" Do response.write rs2("varenavn") & " antal = " & rs2("antal") & ".<br>" rs.MoveNext Loop While Not rs2.EOF end if else if request.QueryString("slet") = "ja" Then strSQL = "Delete from kassen where Id = " & request.QueryString("id") & "" Conn.Execute(strSQL) end if response.write "slettet" else if request.QueryString("rediger") = "ja" Then strSQL = "Update kassen set " strSQL = strSQL & "antal= '" & request.form("antal") & "' " strSQL = strSQL & " Where Id = " & request.QueryString("id") &" " Conn.Execute(strSQL) response.redirect("vare.asp?punkt=1&id=" & request.QueryString("id") & "") else response.write "dette er så bestillt listen..<br>" SQL = "Select * from kassen where regi = false" Set rs = Conn.Execute(SQL) If rs.EOF Then response.write "ingen bestillinger :(" Else Do response.write "brugernavn : " & rs("brugernavn") & "<a href=""vare.asp?punkt=1&id=" & rs("id") & """>Gør noget ved det...</a><br>" rs.MoveNext Loop While Not rs.EOF End if end if end if end if end if end if %> <!--#include file="2.asp"-->
<!--#include file="1.asp"--> <% if session("admin") <> "ja" Then response.write "Dette er kun for admins!!!" ELSE Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("butik.mdb") Conn.Open DSN
if request.QueryString("punkt") = "1" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!" Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else strNavn = rs("brugernavn") SQL = "Select * from kassen where brugernavn ='"& strNavn & "'" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen varer!:(" else strNavn = rs("brugernavn") strVareid = rs("vare_id") strAntal = rs("antal") Do SQL2 = "Select * from varer where ID = "& strVareid Set rs2 = Conn.Execute(SQL2) strPrisen = rs2("pris") strPris = rs2("pris") * strAntal strPrisSamlet = strPrisSamlet + strPris response.write "<form ACTION=""vare.asp?rediger=ja&id=" & rs("id") & """ name=""form1"" method=""POST"">" Response.Write rs2("varenavn") & " antal: <input type=text name=antal value=" & rs("antal") & "> <input type=""submit"" name=""Submit"" value=""ændre""> pris : " & strPris &"<a href=""vogn_i.asp?slet=ja&id=" & rs("ID") & """>slet..</a><br></form>" rs.MoveNext Loop While Not rs.EOF response.write "<p>pris:" & strPrisSamlet & "." response.write "<a href=""vare.asp?punkt=2&id=" & request.QueryString("id") & """>ok.. registrere.." end if
elseif request.QueryString("punkt") = "2" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs2 = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!"
Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else sql = "Update kategorier Set regi = True Where ID = "& request.QueryString("id") set rs = Conn.Execute Response.write "det gik.... følende ting skal i pakken: <p>" Do response.write rs2("varenavn") & " antal = " & rs2("antal") & ".<br>" rs.MoveNext Loop While Not rs2.EOF end if
elseif request.QueryString("slet") = "ja" Then strSQL = "Delete from kassen where Id = " & request.QueryString("id") & "" Conn.Execute(strSQL) end if
response.write "slettet"
elseif request.QueryString("rediger") = "ja" Then strSQL = "Update kassen set " strSQL = strSQL & "antal= '" & request.form("antal") & "' " strSQL = strSQL & " Where Id = " & request.QueryString("id") &" " Conn.Execute(strSQL) response.redirect("vare.asp?punkt=1&id=" & request.QueryString("id") & "") else response.write "dette er så bestillt listen..<br>" SQL = "Select * from kassen where regi = false" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen bestillinger :(" Else Do response.write "brugernavn : " & rs("brugernavn") & "<a href=""vare.asp?punkt=1&id=" & rs("id") & """>Gør noget ved det...</a><br>" rs.MoveNext Loop While Not rs.EOF End if end if end if end if %> <!--#include file="2.asp"-->
<!--#include file="1.asp"--> <% if session("admin") <> "ja" Then response.write "Dette er kun for admins!!!" ELSE Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("butik.mdb") Conn.Open DSN
if request.QueryString("punkt") = "1" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!" Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else strNavn = rs("brugernavn") SQL = "Select * from kassen where brugernavn ='"& strNavn & "'" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen varer!:(" else strNavn = rs("brugernavn") strVareid = rs("vare_id") strAntal = rs("antal") Do SQL2 = "Select * from varer where ID = "& strVareid Set rs2 = Conn.Execute(SQL2) strPrisen = rs2("pris") strPris = rs2("pris") * strAntal strPrisSamlet = strPrisSamlet + strPris response.write "<form ACTION=""vare.asp?rediger=ja&id=" & rs("id") & """ name=""form1"" method=""POST"">" Response.Write rs2("varenavn") & " antal: <input type=text name=antal value=" & rs("antal") & "> <input type=""submit"" name=""Submit"" value=""ændre""> pris : " & strPris &"<a href=""vogn_i.asp?slet=ja&id=" & rs("ID") & """>slet..</a><br></form>" rs.MoveNext Loop While Not rs.EOF response.write "<p>pris:" & strPrisSamlet & "." response.write "<a href=""vare.asp?punkt=2&id=" & request.QueryString("id") & """>ok.. registrere.." end if End if
elseif request.QueryString("punkt") = "2" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs2 = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!"
Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else sql = "Update kategorier Set regi = True Where ID = "& request.QueryString("id") set rs = Conn.Execute Response.write "det gik.... følende ting skal i pakken: <p>" Do response.write rs2("varenavn") & " antal = " & rs2("antal") & ".<br>" rs.MoveNext Loop While Not rs2.EOF end if
elseif request.QueryString("slet") = "ja" Then strSQL = "Delete from kassen where Id = " & request.QueryString("id") & "" Conn.Execute(strSQL) end if
response.write "slettet"
elseif request.QueryString("rediger") = "ja" Then strSQL = "Update kassen set " strSQL = strSQL & "antal= '" & request.form("antal") & "' " strSQL = strSQL & " Where Id = " & request.QueryString("id") &" " Conn.Execute(strSQL) response.redirect("vare.asp?punkt=1&id=" & request.QueryString("id") & "") else response.write "dette er så bestillt listen..<br>" SQL = "Select * from kassen where regi = false" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen bestillinger :(" Else Do response.write "brugernavn : " & rs("brugernavn") & "<a href=""vare.asp?punkt=1&id=" & rs("id") & """>Gør noget ved det...</a><br>" rs.MoveNext Loop While Not rs.EOF End if end if end if %> <!--#include file="2.asp"-->
Jeg lavede vist en fejl - prøv lige denne en gang:
<!--#include file="1.asp"--> <% if session("admin") <> "ja" Then response.write "Dette er kun for admins!!!" ELSE Set Conn = Server.CreateObject("ADODB.Connection") DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " DSN = DSN & "DBQ=" & Server.MapPath("butik.mdb") Conn.Open DSN
if request.QueryString("punkt") = "1" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!" Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else strNavn = rs("brugernavn") SQL = "Select * from kassen where brugernavn ='"& strNavn & "'" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen varer!:(" else strNavn = rs("brugernavn") strVareid = rs("vare_id") strAntal = rs("antal") Do SQL2 = "Select * from varer where ID = "& strVareid Set rs2 = Conn.Execute(SQL2) strPrisen = rs2("pris") strPris = rs2("pris") * strAntal strPrisSamlet = strPrisSamlet + strPris response.write "<form ACTION=""vare.asp?rediger=ja&id=" & rs("id") & """ name=""form1"" method=""POST"">" Response.Write rs2("varenavn") & " antal: <input type=text name=antal value=" & rs("antal") & "> <input type=""submit"" name=""Submit"" value=""ændre""> pris : " & strPris &"<a href=""vogn_i.asp?slet=ja&id=" & rs("ID") & """>slet..</a><br></form>" rs.MoveNext Loop While Not rs.EOF response.write "<p>pris:" & strPrisSamlet & "." response.write "<a href=""vare.asp?punkt=2&id=" & request.QueryString("id") & """>ok.. registrere.." end if End if
elseif request.QueryString("punkt") = "2" Then SQL = "Select * from kassen where Id = " & request.QueryString("id") Set rs2 = Conn.Execute(SQL)
If rs.eof Then response.write "fejl!" Elseif rs("regi") = True Then response.write "ordren er allerede været igen dette.." else sql = "Update kategorier Set regi = True Where ID = "& request.QueryString("id") set rs = Conn.Execute Response.write "det gik.... følende ting skal i pakken: <p>" Do response.write rs2("varenavn") & " antal = " & rs2("antal") & ".<br>" rs.MoveNext Loop While Not rs2.EOF end if
elseif request.QueryString("slet") = "ja" Then strSQL = "Delete from kassen where Id = " & request.QueryString("id") & "" Conn.Execute(strSQL)
response.write "slettet"
elseif request.QueryString("rediger") = "ja" Then strSQL = "Update kassen set " strSQL = strSQL & "antal= '" & request.form("antal") & "' " strSQL = strSQL & " Where Id = " & request.QueryString("id") &" " Conn.Execute(strSQL) response.redirect("vare.asp?punkt=1&id=" & request.QueryString("id") & "") else response.write "dette er så bestillt listen..<br>" SQL = "Select * from kassen where regi = false" Set rs = Conn.Execute(SQL)
If rs.EOF Then response.write "ingen bestillinger :(" Else Do response.write "brugernavn : " & rs("brugernavn") & "<a href=""vare.asp?punkt=1&id=" & rs("id") & """>Gør noget ved det...</a><br>" rs.MoveNext Loop While Not rs.EOF End if end if end if %> <!--#include file="2.asp"-->
Nej, der er vist noget du har misforstået :-)) Men selv tak :-)
Synes godt om
Ny brugerNybegynder
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.