<div>
You query looks fine, the only thing I can think of if its not working is that views is a reserved word.<br />
Therefore you need to put [ ] brackets around the field name.<br />
<br />
E.g<br />
UPDATE user_projects<br />
SET [views] = [views] + 1 &nbsp; &nbsp;<br />
<br />
Can you try this and see if it works?
</div>


You query looks fine, the only thing I can think of if its not working is that views is a reserved word.
Therefore you need to put [ ] brackets around the field name.

E.g
UPDATE user_projects
SET [views] = [views] + 1    

Can you try this and see if it works?

<div>
Good catch... I didn't copy the complete query statement on accident...<br />
<br />
I tried the above solution and that didn't work. Any other thoughts?<br />
<br />
UPDATE user_projects<br />
SET views = views + 1 &nbsp;<br />
WHERE project_ID = '#project_ID#'<br />
<br />
Thx,<br />
<br />
Brian
</div>


Good catch... I didn't copy the complete query statement on accident...

I tried the above solution and that didn't work. Any other thoughts?

UPDATE user_projects
SET views = views + 1  
WHERE project_ID = '#project_ID#'

Thx,

Brian

<div>
My IDs are like so... B690F14E-08-08-11... So I do need the quotes. Looks like everything is working though now. I'll give everybody equal points.<br />
<br />
Thank you!
</div>


My IDs are like so... B690F14E-08-08-11... So I do need the quotes. Looks like everything is working though now. I'll give everybody equal points.

Thank you!

<div>
<div class="content wysiwyg-content">
How would I add +1 value to an existing column value in my table? Feel like this is a easy question but I haven't done it for a while and forgot the syntax to do so.<br />
<br />
I tried...<br />
<br />
UPDATE user_projects<br />
SET views = views + 1 &nbsp; &nbsp;<br />
<br />
Didn't work.<br />
<br />
Thx for the help!
</div>
</div>


How would I add +1 value to an existing column value in my table? Feel like this is a easy question but I haven't done it for a while and forgot the syntax to do so.

I tried...

UPDATE user_projects
SET views = views + 1    

Didn't work.

Thx for the help!

add +1 to column value in mySQL

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.