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:
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:
Passing [quantity] (2000)
Bug Report, maybe (1997)
disappearing SKU (etc.) fields (1998)
SSL and Webstar 3 with Webcatalog (1998)
Running _every_ page through WebCat-error.html (1997)
WebCat2 Append problem (B14Macacgi) (1997)
how to do multiple prices/item? (1998)
Country & Ship-to address & other fields ? (1997)
shipcost (1997)
Date search bug (1998)
WebCatalog 2.0 b 15 mac (1997)
emailer setup (1997)
[WebDNA] Trying to search for two values within one criteria... (2016)
Fwd: Problems with Webcatalog Plug-in (1997)
WebMerch/Emailer Error (1998)
WebCat2.0 [format thousands .0f] no go (1997)
WebCat2 several catalogs? (1997)
WC 3.0.1 Mac days_to_date (1998)
Protecting databases (1999)
WC2.0 Memory Requirements (1997)