bolado

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

...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...

try:

dataSQL = " SELECT * FROM Adaptor WHERE ID = " & ID

hope this helps..

try:

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

hope this helps...

try this:http://www.php.net/manual/en/function.split.phpandhttp://www.php.net/manual/en/control-structures.foreach.php

rs.Open "SELECT * FROM Books WHERE Price BETWEEN " & highstring & " AND " & lowstring & " ORDER BY BookTitle",conn%>

Hope this helps...