try ... IncrementValue() On Sat, 13 Jul 2002, Mark Leder wrote:
> I want to do an insert into a db of a query row incremented by one? > I know how to retrieve the MAX row from the db, but how do I write the > function that adds 1 to the value. > > For example, query MAX returns a value of 1000. > > Then I want to CFSET newvalue = 1000 + 1> > > Thanks, > Mark > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
