cheers for the response neil - "Did you change DB?"
i don't understand what you are saying, did i change DataBase?? "You will also want to use cfqueryparam for you values in." lost me here as well buddy! "Who did the site for you?" someone back 3 years ago who i just cannot get a hold of anymore! how is it that this worked for CFMX6 and below and now CFMX7 just doesn't like it! "Probably failing here: SET ViewCount=ViewCount + 1" i thought the error message highlighted the following synatx as the error point: WHERE MemberID=#memberid# if it helps, i have a table in which i have a field called "ViewCount" and this field gets updated everytime the above script tis processed. cheers, and any further help will be much appreciated ;-) -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Saturday, June 02, 2007 11:12 AM To: CF-Newbie Subject: Re: Hits Counter upgrade from CFMX6 to CFMX7 Probably failing here: SET ViewCount=ViewCount + 1 Did you change DB? Having a hit counter like this is pretty poor use of DB time and you would be better off getting some kind of simple stats package in place (perhaps Google) You will also want to use cfqueryparam for you values in. Who did the site for you? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: [EMAIL PROTECTED] To: CF-Newbie Sent: Sat Jun 02 08:46:12 2007 Subject: Hits Counter upgrade from CFMX6 to CFMX7 Hi - I have the following hit counter which has been working in all versions of coldfusion upto and including CFMX6. I have now changed my hosting to a new company and they are running CFMX7 and my hit counter code is kicking up an error: <cfquery name="updateHits" datasource="#DSN#"> UPDATE Members SET ViewCount=ViewCount + 1 WHERE MemberID=#memberid# </cfquery> I get the following error: Error Occurred While Processing Request Error Executing Database Query. Syntax error: Stopped parse at . The error occurred in viewmember.cfm: line 30 28 : UPDATE Members 29 : SET ViewCount=ViewCount + 1 30 : WHERE MemberID=#memberid# 31 : </cfquery> 32 : I am not a CF programmer so my knowledge is very limited, but does anyone know a workaround to this problem in CFMX7? Cheers in anticipation of some assistance ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2789 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
