Posted on 2012-04-06
we have a table, that every time a specific use queries it/retrieve data, we want the current record to be send to be last.
For this, we can create a "counter" field that will do this.
What would be the best approach to do this, should we use SQL from the server side asp file, a trigger or a stored procedure ?
In SQL would be something like:
SELECT USERNAME, DESCRIPTION, RECORDID, COUNTER FROM TABLE1 ORDER BY COUNTER
UPDATE TABLE1 SET description = description.Text() Where username = SUserName.Text()
and recordid = recordid.Text()
Rs.Movelast; (classic asp)
sCOUNTER = Rs.("Counter") +1;
UPDATE TABLE1 SET Counter = wCOUNTER