21. april 2003 - 09:49
#17
Okay, det virker fint nok hvor scriptet står for sig selv der, men når jeg sætter det sammen med andre form's og text fields så funger det ikke helt rigtigt.. Når jeg klikker på billedet får jeg besked om at der skete en fejl, men billedet kommer godt nok derned hvor det skal stå, men den får bare ikke sat sin værdi til noget :/
Du kan lige se scriptet:
<%
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 Request.Form("billede") = "Ikon" Then Error = True
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("icon") = Request.Form("billede")
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
%>
<style>
.mitfelt {
font-family: verdana;
font-size: 10;
border: 1px solid #C4E1FF;
color:#0066CC;
background-color:#fffff;
}
</style>
<script type="text/JavaScript">
function setIcn(im) {
document.getElementById("icnHolder").innerHTML = "<img src=\""+im.src+"\">";
document.FORMNAVN.billede.value = im.src;
}
</script>
<form method=post name="formnavn" action=default.asp?page=opretbruger>
<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; " class="mitfelt">
</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; "class="mitfelt">
</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; "class="mitfelt">
</font></div>
</td>
<td width="44%">
<div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC" class="mitfelt">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; " class="mitfelt">
</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" class="mitfelt"></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" class="mitfelt">
</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; " class="mitfelt">
</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; " class="mitfelt">
</font></div>
</td>
<td width="44%" height="2">
<div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Skæ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; " class="mitfelt">
</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; " class="mitfelt">
</font></div>
</td>
<td width="44%" height="2">
<div align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">MuseMå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; " class="mitfelt">
</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; " class="mitfelt">
</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; " class="mitfelt">
</font></div>
</td>
</tr>
<tr>
<td width="33%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">Oplø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; " class="mitfelt">
</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; " class="mitfelt">
</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; " class="mitfelt">
</font></td>
<td width="44%" height="32"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC">
</font></td>
</tr>
</table>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<p> </p>
<table width="75%" border="0">
<tr>
<td height="20"><font color="#0066CC" face="Verdana, Arial, Helvetica, sans-serif" size="1">Vælg
Ikon<font color="#FF0000">*</font></font></td>
</tr>
<tr>
<td><font face="tahoma" size="1"><img src="Icons/baily.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/bluepowerpuff.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/cs1.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/cs2.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/greenpowerpuff.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/grisly.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/redpowerpuff.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
<img src="Icons/taz.jpg" onClick="setIcn(this)" width="50" height="50" border="1">
</font></td>
</tr>
<tr>
<td id="icnHolder"><font face="tahoma" size="1">
<input type="hidden" name="billede" value="Ikon">
<tr>
<td><font face="tahoma" size="1">
<input type="submit" value="Tilføj" name="Submit" style="border: 1px solid #000000; ; color:#000000; font-weight:bold; background-color:#E8F0FD" class="mitfelt">
</font><font face="Neuropol"> </font><font face="tahoma" size="1">
<input type="reset" value="Slet Alt" name="Action2" style="border: 1px solid #000000; ; color:#000000; font-weight:bold; background-color:#E8F0FD" class="mitfelt">
</font><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#0066CC"></font></td>
</tr>
</table>
<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><font face="tahoma" size="1">
<br>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<p> </p>
</form>
<p>
/Mjall0w-