#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Gumeracha, South Australia
    Posts
    2
    Rep Power
    0

    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...
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Gumeracha, South Australia
    Posts
    2
    Rep Power
    0
    sorry people, just relised that this works perfectly, it was a VBscript problem

IMN logo majestic logo threadwatch logo seochat tools logo