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 thatguarantees uniqueness - so if you shorten it, uniqueness is no longerguaranteed.Why not use a different method of generating customer numbers?The following WebDNA should append a new record to the customers.dbdatabase with a customer number that's one higher than the highestprevious customer number in that database. Just make sure you startwith a customer.db that has at least one record with a positiveinteger in the customerNumber field ... like the number 1 for example... :)[append db=customer.db]customerNumber=[math][searchdb=customer.db&necustomerNumber=0&customerNumberType=num&decustomerNumberSort=1&max=1][founditems][customerNumber][/founditems][/search]+1[/math][/append]öïùíSincerely, Ken GromeWebDNA Solutionshttp://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 thatguarantees uniqueness - so if you shorten it, uniqueness is no longerguaranteed.Why not use a different method of generating customer numbers?The following WebDNA should append a new record to the customers.dbdatabase with a customer number that's one higher than the highestprevious customer number in that database. Just make sure you startwith a customer.db that has at least one record with a positiveinteger in the customerNumber field ... like the number 1 for example... :)[append db=customer.db]customerNumber=
[math][searchdb=customer.db&necustomerNumber=0&customerNumberType=num&decustomerNumberSort=1&max=1]
[founditems][customerNumber][/founditems][/search]+1[/math][/append]öïùíSincerely, Ken GromeWebDNA Solutionshttp://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:
More questions about serial number dishing (1997)
How To question on setting up downloads (1997)
OSX Install error (2000)
Is this possible in simple search? question? (1998)
Searchable Archives (1998)
File upload woes (1998)
Crediting money back to a customer (2000)
Emailer (WebCat2) (1997)
Share cost of training videos! (1998)
Re:listfiles-looking for slick solution (1997)
Database append/replace (2004)
2.0 Info (1997)
WebCatalog for guestbook ? (1997)
WebDelivery downloads alias, not original ? (1997)
Can you identify the [body]? (1999)
Include Files (1998)
Major Security Hole IIS NT (1998)
Thanks ! (1997)
Order not created error (1997)
Protecting Images (2003)