I have the following code on my page to do a counter for a recorded being requested to keep track of how many times it has been requestion in the table bizop2 I have a field call counter and it is set to int<BR><BR>set R = C.execute(Q)<BR>newcount = cInt(R("counter")) + 1<BR> <BR>Q = "UPDATE bizop2 SET counter = " & newcount & " WHERE id = &#039id&#039"<BR>C.Execute(Q)<BR><BR>I get the following error:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e07&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value &#039id&#039 to a column of data type int. <BR><BR>/bizop_extnd22.asp, line 65