Synes ikke jeg kan se nogen forskel. Skal lige nævnes at jeg næsten intet ved noget om asp. Poster lige hele koden: ved ikke om du kan genkende den??
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("db1.mdb;")
mode = Request.QueryString("mode")
scriptname = Request.ServerVariables("SCRIPT_NAME")
if mode = "save" then
temp1 = request.form("vareNR")
temp2 = request.form("kundenummer")
temp3 = replace(request.form("describe"),"'","''")
temp4 = request.form("amountDumped")
temp5 = replace(request.form("solution"),"'","''")
temp6 = replace(request.form("responsible"),"'","''")
strSQL = "Insert into fejl (dato) values ( & date & )"
sql = "insert into fejl(varenummer, kundenummer, beskrivelse, antal_kasserede, loesning, ansvarlig, dato) "&_
"values("& temp1 &",'"& temp2 &"','"& temp3 &"',"& temp4 &",'"& temp5 &"','"& temp6 &"','"& date &"' )"
conn.execute(sql)
set rs = conn.execute("select @@identity")
response.redirect(scriptname&"?id="& rs(0))
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script src="3common.js" type="text/javascript"></script>
<title>Untitled</title>
</head>
<body bgcolor="black">
<table width="100%" style="height: 85%" borders="0" bgcolor="black">
<tr>
<td bgcolor="black" fontcolor="white">
<center><h3><font face="verdana" color="white">Fejl</font></h3>
</td>
</tr>
<tr>
<td width="100%" height="50%" bgcolor="#013763">
<table border="0" width="100%" style="height: 100%">
<tr>
<td>
<form name="myForm" method="post" action="<%= scriptname %>?mode=save">
<P style="margin-left:100px;">
<br>
<select name="vareNR" style="width:343px">
<%
set rs = conn.execute("select * from varenummer order by varenr")
do while not rs.eof
response.write "<option value='"& rs("varenr") &"'>"& rs("varenr") & "-" & rs("varenavn")
rs.MoveNext
loop
%>
</select></p>
<P style="margin-left:100px;">
<input type="Text" name="kundenummer" onFocus="clearForm(this)" value="kundenummer"><br>
<P style="margin-left:100px;">
<textarea name="describe" cols="40" rows="4" onFocus="clearForm(this)">beskrivelse</textarea><br>
</p>
<P style="margin-left:100px;">
<input type="Text" name="amountDumped" onFocus="clearForm(this)" value="antal kasserede"><br>
<P style="margin-left:100px;">
<textarea name="solution" cols="40" rows="4" onFocus="clearForm(this)">Løsning</textarea><br>
</p>
<P style="margin-left:100px;">
<input type="Text" name="responsible" value="ansvarlig" onFocus="clearForm(this)"><br>
<P style="margin-left:100px;">
<input type="Submit" value="Gem">
</p>
</form>
<br><br>
</td>
</tr>
<tr>
<td valign="bottom"><img src="logo.bmp" align="right"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="black" fontcolor="white">&nsb
</td>
</tr>
</table>
</body>
</html>
