I am trying to update a value in CF by adding 1 to it (or possibly performing other calculations on he value.
The value in the Database is currently 2000 and I am using the following code:
<cfquery name="MyQuery" DATASOURCE="Data">
SELECT * FROM MyTableTBL
The returned value is still only 2000 when it should be 2001, any ideas what I am doing wrong. Sorry I know this is probably simple