TennesseeGuy
02-09-2005, 03:23 PM
I am quite ure there is nothing wrong with this statement but it errors out nonetheless. Am i missing something?
Syntax error in UPDATE statement
strSql = "update from MEMBERS set M_WARN = M_WARN + 1 WHERE MEMBER_ID = " & intMemberID
'Response.Write strSql
'Response.End()
my_Conn.Execute (strSql)
When I run the response.write everything displays properly. Update from the correct table with the correct user name and with the correct warn total. But it still errors out when I remove the response.write statements.
Fixed
Syntax error in UPDATE statement
strSql = "update from MEMBERS set M_WARN = M_WARN + 1 WHERE MEMBER_ID = " & intMemberID
'Response.Write strSql
'Response.End()
my_Conn.Execute (strSql)
When I run the response.write everything displays properly. Update from the correct table with the correct user name and with the correct warn total. But it still errors out when I remove the response.write statements.
Fixed