Cutter (CF_Talk) wrote: >It was probably a month or so ago someone showed how to increment a >count in a database with a single query, but I can't find it in the >archive. Can someone show me the way here please? > >Table:tblSubscribe > int:intChoiceID > str:strChoice > int:intCount > >Update intCount for selected strChoice as intCount + 1 > update tblSubscribe set intcount=intcount+1 where strChoice=?
> >??? > >Cutter > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4