Feeling thick how do i add 1 !

[wantstolearncfm]

Hi,
Ive done this countless times but wheter it be mind lapse god knows but i cant remember how to add one to a record
as in
i have a login attempts file it stores the attempted login in a database all i want it to do is plus 1 everytime the IP tries to login into the attempts column
how can i do it!

 

[wantstolearncfm]

<cfquery name="incrementip" datasource="spano">
update visitor
set visits = visits + 1
where IP = '#REMOTE_ADDR#'
</cfquery>
Fixed it,
Totally dumb for a minute there!
Out of interest under the DPA 1988 how long can i log an ip address for before it must be removed?