Re: Cart#

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13697
interpreted = N
texte = >Is there a way to make the cart number start out smaller? mine are like >20192938372982 long, and I want to use those as customer numbers, but >they don't need to be that long.. maybe like 7 long or somthing.No ... I think cart numbers are generated based on a formula that guarantees uniqueness - so if you shorten it, uniqueness is no longer guaranteed.Why not use a different method of generating customer numbers?The following WebDNA should append a new record to the customers.db database with a customer number that's one higher than the highest previous customer number in that database. Just make sure you start with a customer.db that has at least one record with a positive integer in the customerNumber field ... like the number 1 for example ... :)[append db=customer.db]customerNumber=[math][search db=customer.db&necustomerNumber=0&customerNumberType=num&decustomerNumberSort=1& max=1][founditems][customerNumber][/founditems][/search]+1[/math][/append] öïùíSincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
>Is there a way to make the cart number start out smaller? mine are like >20192938372982 long, and I want to use those as customer numbers, but >they don't need to be that long.. maybe like 7 long or somthing.No ... I think cart numbers are generated based on a formula that guarantees uniqueness - so if you shorten it, uniqueness is no longer guaranteed.Why not use a different method of generating customer numbers?The following WebDNA should append a new record to the customers.db database with a customer number that's one higher than the highest previous customer number in that database. Just make sure you start with a customer.db that has at least one record with a positive integer in the customerNumber field ... like the number 1 for example ... :)[append db=customer.db]customerNumber=[math][search db=customer.db&necustomerNumber=0&customerNumberType=num&decustomerNumberSort=1& max=1][founditems][customerNumber][/founditems][/search]+1[/math][/append] öïùíSincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html 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:

triggers (2003) Help! WebCat2 bug (1997) database size? (1997) Question about links (1999) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WC2f3 (1997) Merging databases (1997) Items XX to XX shown (1997) Where can I download to test? (2003) Frustration with formulas.db (1999) Notepad problems (1998) Search Engine bots (2002) F3 crashing server (1997) Dumb Question about Docs (1997) (ot) sitemap generator (1998) nesting limits? (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) WebCat2b12 - nesting [tags] (1997) [Sum] function? (1997) Prices Dropped (1998)