Fejl i forespørgsel?
HejJeg får flg. fejl på min update-side:
String: select * from Forhandlere where telefon = '86558360'
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/forhandlermodul/oprettet.asp, line 28
Min kode ser sådan ud:
if request.form("navn") = "" or request.form("land") = "" or request.form("postnr") = "" or request.form("city") = "" or request.form("adresse") = "" or request.form("telefon") = "" or request.form("ftype") = "" then
else
if rs.EOF then
strSQL = "Insert into Forhandlere ("
strSQL = strSQL & "navn, "
strSQL = strSQL & "land, "
strSQL = strSQL & "postnr, "
strSQL = strSQL & "city, "
strSQL = strSQL & "adresse, "
strSQL = strSQL & "telefon, "
strSQL = strSQL & "ftype) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & request.form("navn") & "', "
strSQL = strSQL & "'" & request.form("land") & "', "
strSQL = strSQL & "'" & request.form("postnr") & "', "
strSQL = strSQL & "'" & request.form("city") & "', "
strSQL = strSQL & "'" & request.form("adresse") & "', "
strSQL = strSQL & "'" & request.form("telefon") & "', "
strSQL = strSQL & "'" & request.form("ftype") & "')"
conn.execute(strSQL)
end if
end if
%>
<html>
<head>
<title>Forhandlerdatabase</title>
</head>
<body>
<h2 align="center">
<%
if request.form("navn") = "" or request.form("land") = "" or request.form("postnr") = "" or request.form("city") = "" or request.form("adresse") = "" or request.form("telefon") = "" or request.form("ftype") = "" then
response.write "Kunden kunne ikke oprettes da du ikke har udfyldt alle felter!"
else
if not rs.EOF then
response.write "Der er allerede en kunde med det telefonnummer!"
else
response.write "Kunden er oprettet"
end if
end if
%>
</h2>
<div align="center"><a href="side1.asp" align="center"><font face="Arial, Helvetica, sans-serif">Link
til forsiden</font></a> </div>
</body>
</html>
<%
conn.close
set conn = nothing
%>
Kan nogen hjælpe?
:) Shanne
