Fejl ved skrivning i Database..

????

Prøv at lad mig se noget kode....

//>Rune

Det er i databasen du bestemmer om en post må være tom eller ikke.
Så du skal ind i Access og rettet feltet..

<% 

Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../em.mdb") & ";UID=admin;PWD=;"

    Set rs = Server.CreateObject("ADODB.RecordSet")
    strSQL = "Select * From bruger"
    rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic
   
if Request.ServerVariables("REQUEST_METHOD") = "POST" then
   
Dim Error
Error = False
If Request.Form("username") = "" Then Error = True' and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet dit <B>Brugernavn</B></font><br>")
If Request.Form("password") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet dit <B>Password</B></font><br>")
If Request.Form("email") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet din <B>E-Mail</B></font><br>")
If Request.Form("navn") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet hvad du <B>Hedder</B></font><br>")
If Request.Form("by") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet hvilken <B>By</B> du kommer fra</font><br>")
If Request.Form("beskrivelse") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet en <B>Beskrivelse</B> af dig selv</font><br>")
If Request.Form("Alder") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet din <B>Alder</B></font><br>")
If Request.Form("CPU") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet hvilken <B>Processor/CPU</B> du har</font><br>")
If Request.Form("Moniter") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet hvilken <B>Skærm</B> du har</font><br>")
If Request.Form("Grafikkort") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet hvilket <B>Grafikkort</B> du har</font><br>")
If Request.Form("Gamernick") = "" Then Error = True 'and response.write ("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#FF0000'><br>Du har ikke angivet dit <B>Gamernick</B> <font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#000000'>(Gamernick er det du kalder dig når du spiller Online)</font></font><br>")

If Error Then
Response.Write("<font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#000000'>HUSK NU ALLE FELTER MED <font face='Verdana, Arial, Helvetica, sans-serif' size='3' color='#FF0000'<b>*</b><font face='Verdana, Arial, Helvetica, sans-serif' size='2' color='#000000'>UD FORAN SKAL UDFYLDES</font></font>")    
else

rs.AddNew
            rs("Username") = Request.Form("username")
            rs("Password") = Request.Form("password")
            rs("Email") = Request.Form("email")
            rs("Navn") = Request.Form("navn")
            rs("By") = Request.Form("by")
            rs("Beskrivelse") = Request.Form("beskrivelse")
            rs("Alder") = Request.Form("alder")
            rs("Cpu") = Request.Form("cpu")
            rs("Moniter") = Request.Form("moniter")
            rs("Grafikkort") = Request.Form("grafikkort")
            rs("Mus") = Request.Form("mus")
            rs("Musematte") = Request.Form("musematte")
            rs("Oplosning") = Request.Form("oplosning")
            rs("Sensitivity") = Request.Form("sensitivity")
            rs("gamernick") = Request.Form("gamernick")
            rs("access_level") = "user"
            rs.Update

    Response.Write("<font color=#000000 size=1 face=Verdana, Arial, Helvetica, sans-serif>Din Profil et oprettet</font>")
end if
end if
%>

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

<form method=post action=opretbruger.asp>
  <table width="26%" border="0" align="left">
    <tr>
      <td width="33%" height="10">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          BrugerNavn<font color="#FF0000">*</font> <br>
          <input type="text" name="username" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; " >
          </font></div>
      </td>
      <td width="44%" height="10">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Password
          <font color="#FF0000">*</font><br>
          <input type="password" name="password" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
    </tr>
    <tr>
      <td width="33%">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Navn<font color="#FF0000">*</font><br>
          <input type="text" name="navn" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
      <td width="44%">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Email
          <font color="#FF0000">*</font><br>
          <input type="text" name="email" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
    </tr>
    <tr>
      <td width="33%">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          Beskrivelse af dig selv <font color="#FF0000">*</font>
          <textarea name="beskrivelse" cols="20" font="font" face="Verdana, Arial, Helvetica, sans-serif" ;=";" style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; " rows="7"></textarea>
          </font></div>
      </td>
      <td width="44%">
        <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          </font></div>
      </td>
    </tr>
    <tr>
      <td width="33%">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Alder<font color="#FF0000">*</font><br>
          <input type="text" name="alder" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; " value="Feks 2003">
          </font></div>
      </td>
      <td width="44%">
        <p align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Gamer
          Nick<font color="#FF0000">*</font><br>
          </font><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          <input type="text" name="gamernick" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></p>
      </td>
    </tr>
    <tr>
      <td width="33%" height="2">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Processer/CPU<font color="#FF0000">*</font><br>
          <input type="text" name="cpu" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
      <td width="44%" height="2">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Sk&aelig;rm<font color="#FF0000">*</font><br>
          <input type="text" name="moniter" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
    </tr>
 
    <tr>
      <td width="33%" height="2">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Mus<font color="#FF0000">*</font><br>
          <input type="text" name="mus" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
      <td width="44%" height="2">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">MuseM&aring;tte<br>
          <input type="text" name="musematte" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
    </tr>
    <tr>
      <td width="33%" height="32">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          By <font color="#FF0000">*</font><br>
          <input type="text" name="by" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
      <td width="44%" height="32">
        <div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
          Hjemmeside
          <input type="text" name="hjemmeside" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
          </font></div>
      </td>
    </tr>
    <tr>
      <td width="33%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Opl&oslash;sning
        i CS<br>
        <input type="text" name="oplosning" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
        </font></td>
      <td width="44%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Grafikkort<font color="#FF0000">*</font><br>
        <input type="text" name="grafikkort" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
        </font></td>
    </tr>
    <tr>
      <td width="33%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Sensitivity
        i CS<br>
        <input type="text" name="sensitivity" size="20" font face="Verdana, Arial, Helvetica, sans-serif"; style="border: 1px solid #C4E1FF; ; color:#0066CC; background-color:#fffff; ">
        </font></td>
      <td width="44%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
        </font></td>
    </tr>
  </table>
  <p>&nbsp; </p>
  <center>
    <div align="center"> <font size="2"><b><font face="Neuropol"><font color="#000000"><br>
      </font> <br>
      </font> </b> </font> <font size="2"><b><font face="Neuropol"><br>
      </font></b></font></div>
  </center>
  <p><font size="2"><b><font face="Neuropol"><br>
    </font> </b> </font> </p>
  <p> <font face="Verdana, Arial, Helvetica, sans-serif" color="#FF0000"> </font>
  </p>
  <p>&nbsp; </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <br>
  <br>
  <br>
  <br>
  <p><font face="tahoma" size="1"> </font></p>
  <p><font face="tahoma" size="1"><br>
    <input type="submit" value="Tilf&oslash;j" name="Submit" style="border: 1px solid #000000; ; color:#000000; font-weight:bold; background-color:#E8F0FD">
    </font><font face="Neuropol"> </font><font face="tahoma" size="1">
    <input type="reset" value="Slet Alt" name="Action" style="border: 1px solid #000000; ; color:#000000; font-weight:bold; background-color:#E8F0FD" onClick="java script:document.form1.username.focus();>
                </font></b></font><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
    </font></p>
  <p>
 
  </p>
</form>
<p><br>
  <font color="#FFFFFF" face="tahoma"></font></p>
        </body>
</html>

Det var vidst koden :)

/Mjall0w-

Men du snakkede noget om at man skulle ændre det i databasen.. Hvordan det ? ?

/Mjall0w-

Du skal ind i det post som ikke behøver at være udfyldt, og rette "Allow Zero Length" til Yes/ja

Hmm, kan ikke lige finde det, kan du ikke lave en mere nøjagtiv beskrivelse ?

/Mjall0w-

Åben Databasen.
Dobbelt klik på tabellen.
klik på view, og vælg "Design view"
Placer curseren i "Data Type" på det felt som ikke behøver at være udfyldt.
Nede i bunden er der en liste (fanabladet General)
Skift til "Allow Zero Length" til Yes

>Dette er en engelsk udgave så hvis du har en dansk må du lige prøve og oversætte punkterne selv.

Hvis du ikke kan få det til at virke kan du sende filerne til mig, så skal jeg rettet det til for dig.

jakob@flash-it.dk

Mange gange gange tusinde tak du.. :D

/Mjall0w-^