Re: Assigning Serialized Customer Numbers

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15464
interpreted = N
texte = >How do I assign new customers a unique Customer Number that is >sequentially greater than the highest existing customer number? >Is there an example to look at anywhere? Maybe, but I'm not sure off-hand.Here, I'll write one for you. It should work fine if you make a couple of obvious changes (to the database and field name, of course). And if you can understand how and why this works, that's even better ... :)[append db=XXX.db]fieldName=[math]1+[search db=XXX.db&nefieldNamedatarq=[blank]&fieldtype=num&defieldsort=1&max=1][founditem s][fieldName][/founditems][/search][/math][/append]Sincerely, Ken Grome ken@iav.com WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Associated Messages, from the most recent to the oldest:

    
  1. Re: Assigning Serialized Customer Numbers (Kenneth Grome 1997)
  2. Assigning Serialized Customer Numbers (Larry Orchier 1997)
>How do I assign new customers a unique Customer Number that is >sequentially greater than the highest existing customer number? >Is there an example to look at anywhere? Maybe, but I'm not sure off-hand.Here, I'll write one for you. It should work fine if you make a couple of obvious changes (to the database and field name, of course). And if you can understand how and why this works, that's even better ... :)[append db=XXX.db]fieldName=[math]1+[search db=XXX.db&nefieldNamedatarq=[blank]&fieldtype=num&defieldsort=1&max=1][founditem s][fieldName][/founditems][/search][/math][/append]Sincerely, Ken Grome ken@iav.com WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Kenneth Grome

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:

[showif],[refferer],[include] in errormessages.db (2002) Running 2 two WebCatalog.acgi's (1996) can WC render sites out? (1997) Shopping cart now bad (1997) Conversion Database Blues (2001) Thanks and Big News!!! (1997) Need relative path explanation (1997) WebCat2 - many [carts] on one template page? (1997) Conveting Characters to Graphics (1997) TaxTotal Problem (1997) ShowNext (1997) authorize.net CC processing (was WC on Mac OS X or Mac OS (2001) Webcat and logging (1998) Locking up with WebCatalog... (1997) Looking up two prices in Formulas.db (1997) shipcost (1997) Need relative path explanation (1997) Menu to select product variations (1997) 3.0 [TEXT] variables (1998) oops private message leaked into talk list (1997)