November 26th, 2003, 09:01 PM
incrementing an integer field using only sql
I need to increment an integerfield as a counter in a promotions table so that I can keep a record of how many people enter my site from a particular promotion link...
This is probably very simple but I have never needed to do it before and have been looking for a while now with no luck
I would have thought I could use a simple query like
UPDATE Promotions SET Counter = (Counter+1) WHERE PromoID=1
but this doesnt seem to work
any help would be great...
November 26th, 2003, 11:14 PM
sorry people, just relised that this works perfectly, it was a VBscript problem