You have 2 choices...
1) get the ID from the Execute Scalar
ID = Cmd.ExecuteScalar()
or
2) the reader (BTW, not sure you can call reader directly after
calling ExecuteScalar on the same command, in any case you only need
to do one, the other is redundant)
if myReader.Read() then
ID = rdr("ID")
End if
Then you create a new command
strSQL "UPDATE USERS SET TIMESTAMP = NOW() WHERE ID = '" & ID
Cmd = New SqlCommand(strSQL, Conn)
cmd.ExecuteNonQuery
HTH
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
