|
|
Dim Conn, RS
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.mappath("../database/student.mdb")
set rs = server.createobject("adodb.recordset")
temp ="select Counter from logon WHERE Matrix = `" & (Matrix) & "`"
rs.open temp,conn
sql12="update logon set Counter=`::1::` where Matrix=`"&(Matrix)&"`"
conn.execute(sql12)
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/tutor/include/votecount.asp, line 17
|
|
|
|
Presumably your counter field is a data type integer so you should pass it a number without any quotes - what are those :: doing either side of the number anyway??
|
|
|
|
|
|
|
// |
Archive Import (Mie) 
