Nä, nu blir jag lack, det funkar ÄNDÅ inte:
<html>
<head>
<title>Poll</title>
<link rel="stylesheet" href="../style.css" type="text/css">
<script type="text/javascript" src="../nosecondmouse.js"></script>
<font face='verdana' size='1' color='#000000'>
<%
Response.Expires = -1000
Dim action
action = Request.Querystring("action")
If action = "skicka" Then
If Session("username") = namn AND Session("password") = passw Then
'________________________________________________
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../script/db/db.mdb"))
'________________________________________________
strSQL = "UPDATE Poll_data SET Aktiv = 'Nej' WHERE Aktiv = 'Ja'"
Set oRec = oConn.Execute(strSQL)
'________________________________________________
fraga = Request.Form("fraga")
svar1 = Request.Form("svar1")
svar2 = Request.Form("svar2")
svar3 = Request.Form("svar3")
svar4 = Request.Form("svar4")
svar5 = Request.Form("svar5")
res1 = "1"
res2 = "1"
res3 = "1"
res4 = "1"
res5 = "1"
initDate = Date()
aktiv = "Ja"
'________________________________________________
strSQL = "INSERT INTO Poll_data (Fraga, Svar1, Svar2, Svar3, Svar4, Svar5, Res1, Res2, Res3, Res4, Res5, initDate, Aktiv) VALUES ('" &_
fraga & "','" & Replace(svar1, "'", "''") & "','" & Replace(svar2, "'", "''") & "','" & Replace(svar3, "'", "''") & "','" & Replace(svar4, "'", "''") & "','" & Replace(svar5, "'", "''") &_
"','" & Replace(res1, "'", "''") & "','" & Replace(res2, "'", "''") & "','" & Replace(res3, "'", "''") & "','" & Replace(res4, "'", "''") & "','" & Replace(res5, "'", "''") &_
"','" & Replace(initDate, "'", "''") & "','" & aktiv & "');"
'________________________________________________
Set oRec = oConn.Execute(strSQL)
'________________________________________________
strSQL = "DELETE * FROM Ipadress_data"
'________________________________________________
Set oRec = oConn.Execute(strSQL)
Session.Abandon
'Response.reDirect "visa_poll.asp"
Set strSQL = NOTHING
Set oRec = NOTHING
Set oConn = NOTHING
Else
Response.Write("<font face='verdana' size='1' color='#000000'><b>Felektigt Namn Eller Passw.</b></font>" & "<br><br>")
Response.Write("<font face='verdana' size='1' color='#000000'><a href='javascript:history.go(-1);'><== Tillbaks</a></font>")
End If
End If
If action = "form" Then
If Session("username") = namn AND Session("password") = passw Then
%>
<script type="text/javascript">
/* Detta script finns att hämta på [url]http://www.jojoxx.net[/url] och
får användas fritt så länge som dessa rader står kvar. */
function checkLength(obj,dispobj,mlength){
if(obj.value.length>mlength){
obj.value = obj.value.substr(0,mlength);
alert('Detta fält maximalt innehålla '+mlength+' tecken.');
obj.focus();
}
dispobj.value=mlength-obj.value.length;
}
</script>
</head>
<body topmargin="2" leftmargin="2" rightmargin="0" bottommargin="0">
<div align="left" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<form action="ny_fraga.asp?action=skicka" method="post" target ="_self">
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Fråga:</b><br><input type="text" name="fraga" size="30" maxlength="35" onKeyUp="checkLength(this,this.form.text1,35);" onKeyPress="checkLength(this,this.form.text1,35);"> <input type="text" name="text1" size="2" value="35" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='5'></td></tr>
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Svar 1:</b><br><input type="text" name="svar1" size="30" maxlength="25" onKeyUp="checkLength(this,this.form.text2,25);" onKeyPress="checkLength(this,this.form.text2,25);"> <input type="text" name="text2" size="2" value="25" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='5'></td></tr>
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Svar 2:</b><br><input type="text" name="svar2" size="30" maxlength="25" onKeyUp="checkLength(this,this.form.text3,25);" onKeyPress="checkLength(this,this.form.text3,25);"> <input type="text" name="text3" size="2" value="25" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='5'></td></tr>
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Svar 3:</b><br><input type="text" name="svar3" size="30" maxlength="25" onKeyUp="checkLength(this,this.form.text4,25);" onKeyPress="checkLength(this,this.form.text4,25);"> <input type="text" name="text4" size="2" value="25" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='5'></td></tr>
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Svar 4:</b><br><input type="text" name="svar4" size="30" maxlength="25" onKeyUp="checkLength(this,this.form.text5,25);" onKeyPress="checkLength(this,this.form.text5,25);"> <input type="text" name="text5" size="2" value="25" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='5'></td></tr>
<tr>
<td height="10" width="100%" align='left' valign="top"><font face="verdana" size="1" color="#000000"><b>Svar 5:</b><br><input type="text" name="svar5" size="30" maxlength="25" onKeyUp="checkLength(this,this.form.text6,25);" onKeyPress="checkLength(this,this.form.text6,25);"> <input type="text" name="text6" size="2" value="25" disabled onFocus="this.blur();"></td>
</tr>
<tr><td width='100%' height='10'></td></tr>
<tr>
<td height="10" width="50%" align='left' valign="top"><input type="submit" name="knapp" value="Lägg Till"> <input type="reset" name="knapp" value="Rensa"></td>
</tr>
</form>
</table>
</div>
<%
Session.Abandon
Else
Response.Write("<font face='verdana' size='1' color='#000000'><b>Felektigt Namn Eller Passw.</b></font>" & "<br><br>")
Response.Write("<font face='verdana' size='1' color='#000000'><a href='javascript:history.go(-1);'><== Tillbaks</a></font>")
End If
End If
%>
Faan va jag lackar på det här snart...
Ngn som hittar NGT fel?!