I'm looking for a simple way to check on and then increment a value in a db
number field. For example, for a simple hit counter that commits hit
information to a db field: someone hits the page; you check the database to
determine the current value of hits on that page; add 1 to it; then update
the record with the incremented value.
The method above would require 2 <cfquery> actions as I see it: one to check
the current value; one to update the field with the incremented value. Is
there some way to do this without requiring 2 separate actions?
Thanks for any ideas.
Paul Sinclair
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
