increment values by 1

[imstillatwork]

I want to increment by 1, this sql posted is incrementing by 2! it worked fine in access. please suggest something!

Maybe i could get some insight as to why this does not work?
UPDATE tblCars
SET carviews=carviews + 1
WHERE CarID=#attributes.CID#

it will work in access / mssql....

THANKS!

 

[swampBoogie]

No, the problem can't be with the update statement, it must lie somewhere else. Maybe you are running the same code twice or ?

 

[imstillatwork]

i've check all the code running everywhere and there is nothing else, if i block only this one query, the number does not change. BTW this is all being done in ColdFusion. its driving me freaking nuts.