Ditemi cosa c'è di sbagliato in questo inserimento, io nn lo so proprio!!!
Stò uscendo pazzo!!!
<%@ Language=Vbscript %>
<% option explicit %>
<!--#include virtual file="adovbs.inc"-->
<html>
<head>
<title>:: Kaidos :: Work Control</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="menu.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="file/back.gif">
<table border="0" cellspacing="0" cellpadding="0" width="533" height="577" align="center">
<tr valign="bottom">
<td height="94" colspan="3"><img src="file/img_sopra.gif" width="709" height="92"></td>
</tr>
<tr>
<td height="8" width="164" background="file/back_barra.gif"><img src="transparent.gif" width="." height="1"><img src="file/work_control.gif" width="144" height="24"></td>
<td height="8" colspan="2" background="file/back_barra.gif">
<div align="right"><span class="link"><a href="inslavoro.asp" class="link">Inserisci
un lavoro</a></span> <b><span class="unnamed1">::</span></b> <span class="link"><a href="personal.asp" class="link">Lavori
personali</a></span> <b><span class="unnamed1">::</span></b> <span class="link"><a href="stato.asp" class="link">Stato
lavori</a> <img src="transparent.gif" width="10" height="1"></span></div>
</td>
</tr>
<tr>
<td width="164" height="273" bgcolor="#FFFFFF"> </td>
<td width="1" height="273" background="file/back_barra.gif"> </td>
<td width="544" height="273" background="file/back_central.gif" valign="top">
<div align="center"><br>
<br>
<% Dim objRS
dim objCon
dim azienda, tipo, affidatario, note
azienda = request.Form ("azienda")
tipo = request.Form ("tipo")
affidatario = request.form("affidatario")
note = request.form("note")
set objCon = Server.CreateObject("ADODB.Connection")
objCon.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ= " + Server.MapPath ("Dbkai.mdb")
objCon.open
set objRS = Server.CreateObject("ADODB.Recordset")
ObjRS.Open "tablavori", ObjCon, , adlockOptimistic, adcmdtable
If azienda = "" or tipo = "" or affidatario = "" or note ="" then %>
<center>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2" class="testo"><span class="testo">Tutti
i campi sono obbligatori</span>.</font><br>
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="javascript:history.back('')")"><br>
<span class="link">Torna indietro</span></a></font>
</center>
<br>
<% else
objRs.addnew
objRS("azienda") = azienda
objRS("tipo") = tipo
objRS("affidatario") = affidatario
objrs("note") = note
objrs ("data") = date()
objRs.Update
ObjRS.close
Set objrs = Nothing
objcon.close
set objcon= Nothing
%>
<center>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2"><span class="testo">News
inserita con successo</span></font><span class="testo"><br>
</span><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href="reserved.asp")"><br>
<span class="link"> Torna indietro</span></a></font>
</center>
<br>
<% end if %>
</div>
</td>
</tr>
<tr>
<td width="164" height="25" background="file/back_central.gif">
<div align="center"><img src="file/kaidos.gif" width="144" height="40"></div>
</td>
<td width="1" background="file/back_barra.gif" height="25"> </td>
<td width="544" height="25" background="file/back_central.gif"> </td>
</tr>
</table>
</body>
</html>
mi da questo errore:
Tipo di errore:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][Driver ODBC Microsoft Access] Errore di sintassi nell'istruzione INSERT INTO.
/work/mettilav.asp, line 65
AIUTOOOOOOOOOOOOOOOOOOOOOOOOOO
