I have this VB SQL Statement and I need to change it to cf mysql <CFQUERY NAME="SRUpdate" DATASOURCE="DomainDefault" USERNAME="joel" PASSWORD="klrtl"> UPDATE Statistic_Results#YearMonth# SET Raw_Hits = 1 + Raw_Hits, Unique_Hits = 1 + Unique_Hits WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' </CFQUERY>
The problem lies when I do the column + 1. Is there an easy way of doing this without doing a new cfquery? ============================== Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] ============================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm