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:

Negative Range Error (2003) Searching Multiple DBs (1997) Database Security Rev., (2002) SMSI, please fix the StandardConversions.db (2005) simple answer? [hideif] (1997) Webcat XML/XSLT Performance vs. static Html (2006) [group] ? (1997) [isfile] ? (1997) Creating folders and deleting files (1997) PIXO support (1997) Running 2 two WebCatalog.acgi's (1996) Re:2nd WebCatalog2 Feature Request (1996) Multiple prices (1997) Purging the .hdr file from cache ... ? (2003) [OT] Command line - OSX (2005) Searching multiple fields (1997) The beginning (1997) Location of Browser Info.txt file (1997) Problem 2: Prefs file... (1997) Path of Events (1999)