Record Retrieval rate counter

[Rossy]

I would like to be able to count how many times individual records from a database are retrieved. For example if I have a database of all the shops in a shopping mall website, I would like to count how many times each store was searched for and their details displayed. Can I add a field to the databse where I can write to it and increment the number as each record is retieved?

 

[mrichards]

Yes your on hte right track. when a seach is onde on the db the counter field of the record that is selected could be could be br incremented with an sql

UPDATE Table1 SET Table1.countfield = [countfield]+"1";

Mark

 

[wushutwist]

Either set a trigger on the table, at the record level or do it in the Application Layer. Either way you will be using something similar to what mrichards said.
Wushutwist