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:

New public beta available (1997) Artwork (1997) carriage returns in data (1997) trouble updating records in database (1998) Internet Explorer and caching (2000) RE: problem with applets embedded in tpl files (1997) WebTrends (2002) Replace with Producteditor.tpl (2000) [defined]ish (1997) Great product and great job ! (1997) [Sum] function? (1997) OBDC Support (1997) no global [username] or [password] displayed ... (1997) WebCat2 - Getting to the browser's username/password data (1997) WebCat editing, SiteGuard & SiteEdit (1997) Help!!!! (1997) Emailer (1997) Uploading out of FMP (2001) RE: Problems reading files created by WC (1997) URL for Discussion Archive (1997)