instead of using recorset, try with this
SQL = "Insert INTO Nometable (LogEquipment, ecc ..... ) VALUES ('" &
Equipment & "', '" & ....
Conn.execute(SQL)
where I assume Conn is your well defined connection object to database
pay attention to ' & " in SQL string
HTH
-----Messaggio originale-----
Da: elizabetas@m... [mailto:elizabetas@m...]
Inviato: venerd́ 4 gennaio 2002 3.46
A: ASP Databases
Oggetto: [asp_databases] server error
hi,
i keep on getting a error message from wrox list manager that my message
is rejected because it has attachment. i'm not trying to attach
anything , what can be the problem?
any way,
i have a page that is attempting to add new row to a table. i'm
getting "500 internal server error"
what can be wrong?
here is the code:
<!-- #include file="Connection.asp" -->
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
<HTML>
<HEAD><LINK rel="stylesheet" type="text/css" href="Style.css">
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<body>
<%
dim Room
Room = Request.Form ("Room")
dim Equipment
Equipment = Request.Form ("Equipment")
dim Part
Part = Request.Form ("Part")
dim Description
Description = Request.Form ("Description")
Response.Write Room
Response.Write Equipment
Response.Write Part
Response.Write Description
dim ServDate
ServDate = Date
dim rsUpdate
set rsUpdate = Server.CreateObject ("ADODB.Recordset")
rsUpdate.Open "ProblemLog", strConnect, adOpenDynamic, adLockOptimistic
rsUpdate.AddNew
rsUpdate!LogEquipment = Equipment
rsUpdate!LogDate = ServDate
rsUpdate!LogPart = Part
rsUpdate!LogUser = Session ("Passw")
rsUpdate!LogDescription = Description
rsUpdate!LogRoom = Room
%>
ok
</body>
</html>
$subst('Email.Unsub').
View Cart
