Need help with connection code

[Lety]

Does anyone see what I'm doing wrong in the code below? I'm getting an error when trying to connect.

<%
Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open connStr
SQLString = "UPDATE sitePages SET Page_Hits + 1 WHERE Page_Title = 'Calgary'"
MyConn.Execute(SQLString)

MyConn.Close
Set MyConn = Nothing
%>

Thanks in advance.

[Terry]

Originally posted by Lety
SQLString = "UPDATE sitePages SET Page_Hits + 1 WHERE ...

Try changing it to:
UPDATE sitePages SET Page_Hits = Page_Hits + 1 WHERE ...