Fejl i script...
Jeg har ingen erfaring med ASP, men jeg prøvede aligevel...Hvorfor får jeg denne fejl :
---------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/test/subopdater.asp, line 10
-------------------------------
I dette script :
--------------------------------
<%
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("sub.mdb")
strSQL = "UPDATE seb SET seb=" & request("seb")
strSQL = strSQL & ", pwd=" & request("pwd")
strSQL = strSQL & ", email=" & request("email")
strSQL = strSQL & " WHERE Id=" & request("id")
Set rs = myConn.Execute(strSQL)
%>
<form method="POST" action="subopdater.asp">
<p>Brugernavn : <input type="text" name="brugernavn" size="20"> password : <input type="text" name="password" size="20"></p>
<p><input type="submit" value="Send" name="login"><input type="reset" value="Nulstil" name="B2"></p>
</form>
<% if request.Form("password") = "pwd" And request.Form("username") = "seb" then %>
<form method="POST" action="subopdater.asp">
<p align="center"> </p>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<p align="center"><font face="Tahoma">Brugernavn : </font></td>
<td>
<p align="center"><font face="Tahoma"><input type="text" name="seb" size="20" value=<% Request("seb")%> ></font></td>
</tr>
<tr>
<td align="center">
<p align="center"><font face="Tahoma">Adgangskode : </font></td>
<td>
<p align="center"><font face="Tahoma"><input type="text" name="pwd" value=<% request("pwd") %> size="20"></font></td>
</tr>
<tr>
<td>
<p align="center"><font face="Tahoma">Email : </font></td>
<td>
<p align="center"><font face="Tahoma"><input type="text" name="email" value=<% Request("email") %> size="20"></font></td>
</tr>
</table>
</center>
</div>
<p align="center"> </p>
<p align="center"><input type="submit" value="Opdater Oplysninger" name="opdater"></p>
</form>
<% end if %>
------------------------------------
Håber nogen kan hjælpe mig færdig...
