UPDATE tblSubscribe SET intCount = intCount + 1 WHERE intChoiceID = 12 ?
HTH -----Original Message----- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 8, 2003 13:37 To: CF-Talk Subject: increment a count in a db 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 ??? 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
