Avatar billede integra2ren Nybegynder
15. marts 2001 - 12:18 Der er 3 kommentarer og
1 løsning

Form validation, HELP-HELP

Hvorfor sender formvalidationen den samme fejlkode uanset om formen er udfyldt eller ej???

<!--#include file=\"protect.inc\"-->
<% response.buffer = true %>
<html>

<head>

<title>Tilføj nyt forum</title>


</head>
<body bgcolor=\"#FFFFFF\">

<h3 align=\"center\"><% if Request.QueryString(\"mode\")=\"\" then %><font face=\"verdana Black\" >Rediger forum</font></h3>
<div align=\"center\"><center>


<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
    <tr>
        <td width=\"100%\">
          <p align=\"center\"><font face=\"verdana Black\"><a href=\"tagwall.asp?mode=add\"><font size=\"3\" color=\"#1C261E\">Tilføj
          forum</font></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"admin.asp\"><font size=\"3\" color=\"#1C261E\">Slet/rediger
          forum</font></a><font
        size=\"1\" face=\"Arial Black\"><br>
          <%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"../../scripts/forum.mdb\")
strSQL = \"Select * From forums\"
set rs = Conn.execute(strSQL)

if rs.EOF then
Response.write \"<font face=\"\"Arial\"\" size=\"\"2\"\"><i>Der er ingen der har skrevet i tagwall`en...</i></font>\"
else
Do Until rs.EOF%>
          <br>
        </font></font></p>
        </td>
    </tr>
</table>
</center></div><div align=\"center\"><center>

<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
    <tr>
        <td width=\"100%\" align=\"center\"><font face=\"Arial\" size=\"2\"><b><%=RS(\"forum\")%></b></font><font face=\"Arial\"><br>
          <font size=\"2\" face=\"Arial\"><%=RS(\"description\")%></font></font></td>
    </tr>
</table>
</center></div>

<p><%RS.MoveNext
Loop
end if

Conn.Close
Set Conn = Nothing%></p>

<h3 align=\"center\"><% elseif Request.QueryString(\"mode\")=\"add\" then %><font face=\"verdana Black\" >Rediger
  forum</font></h3>
<TABLE border=0 width=500 >
<TR><TD>
<%
\'ON THE FIRST TIME THAT THIS PAGE LOADS, SESSION(\"ERRORS\") HAS NO VALUE AND SO
\'EQUALS 0.  ON SUBSEQUENT VISITS, SESSION(\"ERRORS WILL HAVE A VALUE OF 1 OR
\'MORE IF ERRORS WERE MADE 

if  Session(\"Errors\")=0 then
  response.write \"Please fill out the form\"
else
  \'ERRORS WERE MADE SO LIST THEM IN THE REST OF THE TABLE
  \'reset our error counter
  Session(\"Errors\")=\"0\"
  response.write \"<BR>There are errors in your data.  \" & _
          \"Please make  the following  changes before \" & _
          \"clicking the submit button:<br>\"
  response.write\"<TABLE border=0 width=\' 400\' align=\'center\'>\"

  \'THESE SESSION VARIABLES ARE SET IN THE SECOND PAGE
  \' IF THERE WERE ERRORS \'VALUE IS \"F\" 
  If Session(\"badFirstName\") = \"T\" then
    Response.write \"<TR><TD><font color=\'red\'>The First \" & _
                    \"Name field must be completed.</font>\"
    Response.write \"</TD></TR>\"
    Session(\"badFirstName\")=\"F\"
  End If


  If Session(\"badLastName\") = \"T\" then
    Response.write \"<TR><TD><font color=\'red\'>The Last Name \" & _
                  \"field must be completed. </font>\"
    Response.write \"</TD></TR>\"
    Session(\"badLastName\")=\"F\"
  End If



  \'END THE ERRORS TABLE
  response.write \"</TD></TR></TABLE>\"
End If
%>   
<form action=\"test.asp\" NAME=\"frmUser\" method=\"POST\">
    <div align=\"center\"><center>
      <table border=\"0\" cellpadding=\"2\"
    cellspacing=\"0\">
        <tr>
          <td align=\"right\" width=\"207\"><font face=\"Arial\" size=\"2\">Forum titel:</font></td>
          <td colspan=\"2\" width=\"472\"><font size=\"2\"
            face=\"Arial\">
            <input type=\"text\" size=\"20\"
            name=\"forum\">
            </font></td>
        </tr>
        <tr>
          <td align=\"right\" width=\"207\"><font face=\"Arial\" size=\"2\"><b>Kort</b>
            beskrivelse:<br>
            </font></td>
          <td valign=\"top\" width=\"472\" colspan=\"2\"> <font size=\"2\"
            face=\"Arial\">
            <input type=\"text\" name=\"description\" size=\"75\" value=\"\" maxlength=\"75\">
            </font><font size=\"2\"
            face=\"Arial\"><font size=\"2\"
            face=\"Arial\"><font size=\"1\"> </font></font></font></td>
        </tr>
      </table>
      <font face=\"Arial\" size=\"2\"><font size=\"2\"
            face=\"Arial\"><font size=\"1\">-MAX </font></font><font size=\"1\">60 ANSLAG-</font></font>
    </center></div><p align=\"center\"><input type=\"submit\"
    name=\"B1\" value=\"Tilføj\"></p>
</form>

<p><% elseif Request.QueryString(\"mode\")=\"save\" then %> <%
response.buffer = true

Const adOpenKeyset = 1
Const adLockOptimistic = 3

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"../../scripts/forum.mdb\") & \";UID=admin;PWD=;\"

    Set rs = Server.CreateObject(\"ADODB.RecordSet\")
    strSQL = \"Select * From forums\"
    rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic

      rs.AddNew
      rs(\"description\") = Request.form(\"description\")
      rs(\"forum\") = Request.form(\"forum\")
   
      rs.Update

    rs.Close
    Set rs = Nothing

Conn.Close
set Conn = Nothing
response.redirect \"\"
%><%end if%></p>
</body>
</html>
Avatar billede integra2ren Nybegynder
15. marts 2001 - 12:19 #1
Den fil der hedder test.asp der således ud:

<%
Session(\"FName\")=Request(\"forum\")
Session(\"LName\")=Request(\"description\")


\'HERE IS ONE WAY OF CHECKING FOR AN EMPTY TEXT BOX
if not len(Request(\"FirstName\")) > 0 then
  Session(\"badFirstName\")=\"T\"
  Session(\"Errors\")=Session(\"Errors\") + 1
end if

\'AND HERE IS ANOTHER, BOTH SHOULD WORK
if Request(\"LastName\")= \"\" then
  Session(\"badLastName\")=\"T\"
  Session(\"Errors\")=Session(\"Errors\") + 1
end if



if Session(\"Errors\") > 0 then
  \'there were errors, so send back to form
  response.redirect \"form.asp\"
else
  \'there were no errors, so do the update to the database and redirect to a thank you page
  response.redirect \"admin.asp\"
end if
%>

Avatar billede tentakkel Nybegynder
15. marts 2001 - 12:20 #2
Er det ikke lidt fedtet kun at ville giv 30 point for at man skal kigge hele den kode igennem?
Avatar billede integra2ren Nybegynder
15. marts 2001 - 13:01 #3
100 ok?
Avatar billede dudal Nybegynder
15. marts 2001 - 14:05 #4
Prøv dette. Jeg har rettet Request(\"Firstname\") til Session(\"FName\") osv. :-)

Session(\"FName\")=Request(\"forum\")
Session(\"LName\")=Request(\"description\")


\'HERE IS ONE WAY OF CHECKING FOR AN EMPTY TEXT BOX
if not len(Session(\"FName\")) > 0 then
  Session(\"badFirstName\")=\"T\"
  Session(\"Errors\")=Session(\"Errors\") + 1
end if

\'AND HERE IS ANOTHER, BOTH SHOULD WORK
if Session(\"LName\") = \"\" then
  Session(\"badLastName\")=\"T\"
  Session(\"Errors\")=Session(\"Errors\") + 1
end if


/Jesper
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