I am using NHibernate and have a requirement where in when i am deleting a row i should not hard delete the row instead update the status to delted and set few system properties like who deleted etc.

For doing this i have decided to go with custom sql statement like.

```
<sql-delete>
  update PPDE set SysStatusID = 2 where PPDID =? 
</sql-delete>

```

in the sql statement i am able to get reference to just id , but how can i update the SysUserID to the user who delted this row.

Basically how to set up dynamic paramater values in custom sql statements.

Any help is greatly appreciated.