Increasing by 1..

[denny911]

Hello,In the table "mytbl" there's a field named "hits". I'm trying to make this piece of code below increase the value of that field by one.

<% Set conn = Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("database-path.mdb"))SQL = "UPDATE mytbl SET "sql=sql & " VALUES "sql=sql & "hits ='" & hits+1 & "'"sql=sql & " WHERE ID = " & ID & ""on error resume nextconn.Execute sql, recaffectedif err<>0 then Response.Write("Error!")else  Response.Write("Record Added")end if%>

Below this is the code that shows the value of the field hits and it works just fine. The problem is after I refresh the page, that value is NOT increased by 1, as it is supposed to be (the ERROR message appears but database's value is displayed). It only shows the value as it is, every time I refresh the page.Any suggestions?Thanks

[bolado]

try:

SQL = "UPDATE mytbl SET "sql=sql & " VALUES "sql=sql & "hits = hits + 1"sql=sql & " WHERE ID = " & ID & ""

hope this helps...

[aspnetguy]

from what you provided it appears that hits is a field in your db not a variable in ASP thats whysql=sql & "hits ='" & hits+1 & "'"won't workthe solution provided by bolado should work

[denny911]

try:

SQL = "UPDATE mytbl SET "sql=sql & " VALUES "sql=sql & "hits = hits + 1"sql=sql & " WHERE ID = " & ID & ""

hope this helps...

<{POST_SNAPBACK}>

unfortunately, this didn't help.. the ERROR message is still there..Anything else?

[bolado]

...what's the error description?(try removing the line 'On Error Resume next')...are you getting a value in ID var?...the field hits has at least a number (or row)?sry, for my bad engrish...

[aspnetguy]

try this

sql = "UPDATE mytbl SET "sql=sql & "hits = hits + 1"sql=sql & " WHERE ID = " & ID & ""

You don't need VALUES in there

[bolado]

ouch, I didn't see that one...

[denny911]

thank to both of you, guys--the problem was in other parts of code, but i had to use the hint from BOLADO's first post.Thanks again!