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 ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2787 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
