bookmarks and absolute postion

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   hey folks
hey there good folks

i am trying to bookmark my position in Access, after doing an insert. i have checked that the recordset supports both bookmarking and absolute postion .
the problem is, when i response.write the bookmark, even when the insert is successful, the bookmark position is always 1.
any ideas why this is happening? 

could it be related to my insert string:
    strsql = "SELECT * FROM [tblOrgs] WHERE 0 = 1"
and if so, how can i fix this?

below, is the rest of the relevant code:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

rs.addnew
 .....
rs.Update

 ' if rs.Supports(adbookmark) then 
 '  strMessage = "supports boommarks"
 ' else
 ' strMessage = "NO supports boommarks"
 ' end if 

  '0x4000 = absolute position

  bookmark = rs.absolutePosition
 rs.close
set rs = nothing

response.write(bookmark)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Thanks!
Sn