Timestamp and User with custom asp script

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to add the built in timestamp and user logon info as with a new
submittal to a database. These are option and I attempted to copy the copt of
s builtin fields into the database results wizard.
I think from reviewing the several sites I have gone to this can be
accompllished thru using the hidden fileds but do not know the syntax to use
example
<input type="hidden" name="lastupdatedrecordtime" value="<%=Date()%>">
<input type="hidden" name="lastuserupdated" value="<%=Remote_User%>">
 
Hi,
Easiest would be to set the last update date in the database, then you won't
need a form field.
update table set field1='something', LastUpdate=now ......

For the user you'd want
<input type="hidden" name="lastuserupdated"
value="<%=Request.servervariables("Remote_User")%>">
although this won't work if your site is publically accessible, ie doesn't
require logon - remote user will always be blank.

Cheers,
Jon
 
Understood I can use a trigger but as you stated the remote user would be
blank and I need who altered last.
Reviewing the documentation on the web and the help file it states the
hidden field can be used to accomplish but no where lists the proper value
for the hidden field.
 
Back
Top