fejl i DB upload
Jeg får en fejl meddelelse når jeg prøver på at uploade ...-------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/opretNWS.asp, line 37
-------------------
Koden til siden ser sådan ud:
-----------
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Salgsliste</title>
</head>
<body>
<%
mode=request.querystring("m")
if mode="gem" then
sti = "billeder_c/"
Set Upload = Server.CreateObject("Persits.Upload")
set conn = server.createobject("ADODB.connection")
path = Server.MapPath("db/fpdb/sha.mdb")
conn.Open "DBQ="& path &";DefaultDir="& path & ";Driver={Microsoft Access Driver (*.mdb)}"
Upload.OverwriteFiles = False
Upload.Save (Server.Mappath(sti))
fil1 = ""
fil2 = ""
fil3 = ""
If Not Upload.Files("FILE1") Is Nothing Then fil1 = sti & Upload.Files("FILE1").FileName
If Not Upload.Files("FILE2") Is Nothing Then fil2 = sti & Upload.Files("FILE2").FileName
If Not Upload.Files("FILE3") Is Nothing Then fil3 = sti & Upload.Files("FILE3").FileName
SQL="insert into tblNWS ("
SQL = SQL & "oprettet, [overskrift], [nyhed], DATO)"
SQL = SQL & " values ("
SQL = SQL & "'" & Upload.form("oprettet") & "', "
SQL = SQL & "'" & Upload.form("overskrift") & "', "
SQL = SQL & "'" & Upload.form("nyhed") & "', "
SQL = SQL & "'" & Upload.form("dato") & "' "
SQL = SQL & ")"
Conn.Execute(SQL)
%> <meta http-equiv="refresh" content="2;URL=default_safe.asp?path=1s">
<font color="#FF0000">Dine ændringer er nu gemt.</font><b>
<% else %>
</b>
<div align="center">
<table border="0" width="85%" id="table1">
<tr>
<td><b>
<form method="POST" action="opretNWS.asp?m=gem" enctype="multipart/form-data">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" height="44" id="table2">
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Oprettet:</font></td>
<td height="22">
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="oprettet" size="20" value="<%=date()%>"></span></font></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Overskrift:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Overskrift" size="35"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Nyhed:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Nyhed" size="35"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Dato:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Dato" size="35"></span></font></b></td>
</tr>
</table>
</center>
</div>
<p align="center">
<font face="Verdana"><span style="font-size: 9pt">
<br>
<input type="submit" value="Gem" name="gem">
</span></font>
</p>
</form>
</b>
<font face="Verdana" style="font-size: 9pt">
<% end if %>
</font>
<p> </td>
</tr>
</table>
</div>
</body>
</html>
--------------
Er der nogen der kan hjælpe med at finde fejlen...
Toke
