Hjæææææællllp...... ACCESS DATABASE
Hvorfor virker dette ikke.den skriver
"Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/dwweb/opdater.asp, line 29"
Jeg kan ikke finde ud af hvad der er galt.
<%
Response.Buffer = True
FUNCTION fixQuotes( theString )
fixQuotes = Replace( theString, "'", "''" )
END FUNCTION
Navn = Request( "Navn" )
Nickname = Request( "Nickname" )
Email = Request( "Email" )
ICQ = Request( "ICQ" )
Hjemmeside = Request( "Hjemmeside" )
Set Con = Server.CreateObject( "ADODB.Connection" )
DBPath = "DBQ=" & server.mappath("homie.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
IF Request.Servervariables("Content_Length") > 0 THEN
Sql = "INSERT INTO nyheder (Navn, Nickname, Email, ICQ, Hjemmeside) VALUES('" & fixQuotes( Navn ) & "','" & fixQuotes( Nickname ) & "','" & fixQuotes( Email ) & "','" & fixQuotes( ICQ ) & "','" & fixQuotes( Hjemmeside ) & "')"
Con.Execute Sql
Response.Write "<strong>Databasen er nu opdateret</strong>"
END IF
%>
<html>
<head>
<title>Opdater Honmie database</title>
<link rel=stylesheet type="text/css" href="style.css">
</head>
<body>
<h1>Intast dine data</h1>
<br>
<br><br>
<form action="opdater.asp" method="POST" target="_self">
<table border="0" width="600">
<tr>
<td>Navn</td>
<td><input type="text" name="Navn"></td>
</tr>
<tr>
<td>Nickname</td>
<td><input type="text" name="Nickname"></td>
</tr>
<tr>
<td>E-mail</td>
<td><input type="text" name="Email"></td>
</tr>
<tr>
<td>ICQ nr.</td>
<td><input type="text" name="ICQ"></td>
</tr>
<tr>
<td>Hjemmeside</td>
<td><input type="text" name="Hjemmeside" value="http://"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Opdater"></td>
</tr>
</table>
</form>
</body>
</html>
