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 theentire db to find a unique SKU, so i thought that this would be a goodway 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:
Sorry,It is for adding new records, I don't want to have to sift through theentire db to find a unique SKU, so i thought that this would be a goodway 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)