Re:Finding max value for a field

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13366
interpreted = N
texte = >I want to generate a sequential series of ID numbers for database >records (I have to do this separately from the [cart] function). > >Is there an easy way to quickly look up the maximum value in a >particular field for all database records? I can then use [math] to make >the next number. > >Thanks, >Pat McCormickDo a sort on that field and set the max to 1 Jay Van Vark ******************************* Pacific Coast Software | eCommerce (WebCatalog) 11770 Bernardo Plaza Court | Site Hosting & Development Suite 453 | http://www.smithmicro.com San Diego, CA 92128 ******************************* 619.675.1106 Associated Messages, from the most recent to the oldest:

    
  1. Re:Finding max value for a field (Jay Van Vark 1997)
>I want to generate a sequential series of ID numbers for database >records (I have to do this separately from the [cart] function). > >Is there an easy way to quickly look up the maximum value in a >particular field for all database records? I can then use [math] to make >the next number. > >Thanks, >Pat McCormickDo a sort on that field and set the max to 1 Jay Van Vark ******************************* Pacific Coast Software | eCommerce (WebCatalog) 11770 Bernardo Plaza Court | Site Hosting & Development Suite 453 | http://www.smithmicro.com San Diego, CA 92128 ******************************* 619.675.1106 Jay Van Vark

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

emailer setup (1997) [TaxableTotal] - not working with AOL and IE (1997) RE: too many nested [xxx] (1997) What am I missing (1997) Checking two required fields (1998) download a file (2001) [WebDNA] Email Log.txt (2014) webDNA language. (2004) Multiple catalog databases and showcart (1997) Re:multiple digests, please stop (1997) AppleScript question (1997) [SearchString] usage (1997) ISAPI WC6a and Windows 2003 Web Edition (2006) CART question (2004) OK, here's a new one (2002) Restricting templates from causing havoc (2000) can I get formvariables for an include? (1999) Sendmail doesn't (was Queertrons?) (1997) Serving .wml pages to WAP via webcat (2000) 2.0 Beta (1997)