Re: SKU lookup

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13099
interpreted = N
texte = Sorry,It is for adding new records, I don't want to have to sift through the entire db to find a unique SKU, so i thought that this would be a good way to do it. Is there a better way?Kenneth Grome wrote: > > >Hello > > > >Hey how would one write an expression to lookup the last SKU entry made > >in a given db, and then add 1 to it, and enter that automatically in the > >SKU field? > > What record do you want this new SKU value to go into? > > Do you want it to go into a brand new record, or do you want to > replace the existing SKU value in the last record of the database? > > It makes a big difference in the code ... > > Sincerely, Ken Grome > WebDNA Solutions > http://www.hui.net/dna/webdna.html-- _ __( )_ While Eeyore frets ... ( (o____ and Piglet hesitates ... | | and Rabbit calculates ... | (__/ and Owl pontificates \ / ___ / \ \___/ / ^ / \ ...Pooh just is. | | |__|_HUNNY | | \______)____/ \ / \ /_ Damien Joldersma | ( __) p00h@wcug.wwu.edu (____) http://www.wcug.wwu.edu/~p00h Associated Messages, from the most recent to the oldest:

    
  1. Re: SKU lookup (Damien Joldersma 1997)
  2. Re: SKU lookup (Kenneth Grome 1997)
  3. Re: SKU lookup (Olin 1997)
  4. Re: SKU lookup (Kenneth Grome 1997)
  5. Re: SKU lookup (Daniel Cameron 1997)
  6. Re: SKU lookup (Damien Joldersma 1997)
  7. Re: SKU lookup (Kenneth Grome 1997)
  8. SKU lookup (Damien Joldersma 1997)
Sorry,It is for adding new records, I don't want to have to sift through the entire db to find a unique SKU, so i thought that this would be a good way to do it. Is there a better way?Kenneth Grome wrote: > > >Hello > > > >Hey how would one write an expression to lookup the last SKU entry made > >in a given db, and then add 1 to it, and enter that automatically in the > >SKU field? > > What record do you want this new SKU value to go into? > > Do you want it to go into a brand new record, or do you want to > replace the existing SKU value in the last record of the database? > > It makes a big difference in the code ... > > Sincerely, Ken Grome > WebDNA Solutions > http://www.hui.net/dna/webdna.html-- _ __( )_ While Eeyore frets ... ( (o____ and Piglet hesitates ... | | and Rabbit calculates ... | (__/ and Owl pontificates \ / ___ / \ \___/ / ^ / \ ...Pooh just is. | | |__|_HUNNY | | \______)____/ \ / \ /_ Damien Joldersma | ( __) p00h@wcug.wwu.edu (____) http://www.wcug.wwu.edu/~p00h Damien Joldersma

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:

multi-paragraph fields (1997) Search/sort in URL Was: GuestBook example (1997) quantity minimum problem (1997) RAM variables (1997) Refreshing document (2000) Classified (1999) url value (2002) WebCat2 several catalogs? (1997) emailer (1997) Database Structuring (again) (2003) Credit Card Number checking (1997) WC results --> Access/Filemaker (1998) remotely add + sign (1997) Problems with [Applescript] (1997) user/password validation (1998) [OT] Helllllooooooo.... (2002) BUG: SiteBuilder -FAQ and?? (2005) Retaining formatting (2000) Fwd: [WebDNA] Array for Dummies (2010) problem: mail changed (1997)