mbennie
|
| Posted: 02/01/2002, 12:05 PM |
|
How do I keep a count of the number of times a record is displayed in a grid form? Using ASP.
|
|
|
 |
Nicole
|
| Posted: 02/04/2002, 4:29 AM |
|
Hello,
add special field to the table e.g. show_count and increase it each time record is displayed. It could be done in BeforeShow event. Sample code:
cn.execute("update table_name set show_count= show_count + 1 where primary_key field=" & ToSQL(fldprimary_key_field, "Number"))
|
|
|
|
Erdal
|
| Posted: 01/30/2003, 10:43 AM |
|
this code updated all records why ?
DBSALES.Execute("update Message_Box set counter = counter + 1" &_
"where message_id=message_id")
|
|
|
|
|
