I don't think Mysql allows you to increment a column on itself. I think you have to do the math outside of the query. Been a while since I have tried it in Mysql thou.
William ---------------------------------- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Have you ever read a book that changed your life? Go to: http://www.winninginthemargins.com Use PassKey: GoldenGrove You'll be glad you did. ::-----Original Message----- ::From: John Barrett [mailto:[EMAIL PROTECTED] ::Sent: Thursday, May 29, 2008 10:54 PM ::To: CF-Newbie ::Subject: Re: counter for dynamic page :: :: ::Hi Simon, ::Thanks so much for your help:) ::Well that is what I was trying to do, with the recording the page by ::the ID. Thanks so much.However, I am getting a error from MySQL (you ::have an error in your SQL syntax; check the manual that corresponds ::to your MySQL server version for the right syntax to use near '' at ::line 4). The part I can't figure out is why I get the error from ::using SET hit_count = hit_count + 1 with the updated code, but when I ::use the orginal peice I do not get this error. I am wondering if you ::can offer any help? :: ::Thanks so much, ::John ::On May 29, 2008, at 1:04 AM, Simon Free wrote: :: ::> SET hit_count = hit_count + 1 :: :: :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3671 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
