Re: [WebDNA] Query re: autonumber
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105527
interpreted = N
texte = > I recently used it and it bombed out - i.e all the autonumbers generated by > the append were the same and were negative! I think this was because one of > the record IDs had been generated using [cart]. There's a limit to the number of digits in a "number" in webdna, and the [cart] tag probably creates values that exceed this limitation. I think the rule is to not use values with more than 12 digits to the left of the decimal place in order to avoid this issue. > Also what happens if records are deleted, i.e. the IDs are not all fully > sequential - does autonumber work OK in this situation? Yes, it's fine. The way I understand it, autonumber finds the highest value in the field at the time of the append, then adds 1.
Associated Messages, from the most recent to the oldest:
> I recently used it and it bombed out - i.e all the autonumbers generated by > the append were the same and were negative! I think this was because one of > the record IDs had been generated using
[cart]. There's a limit to the number of digits in a "number" in webdna, and the
[cart] tag probably creates values that exceed this limitation. I think the rule is to not use values with more than 12 digits to the left of the decimal place in order to avoid this issue. > Also what happens if records are deleted, i.e. the IDs are not all fully > sequential - does autonumber work OK in this situation? Yes, it's fine. The way I understand it, autonumber finds the highest value in the field at the time of the append, then adds 1.
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:
Re:emailer 150 (1997)
RE: Languages (1997)
Multi vendor shop (2000)
Update quantity (2000)
Formating found categories (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
301 redirect (2008)
email servers (2000)
Combining search criteria (2000)
more info on [setlineitems] (1997)
Emailer help....! (1997)
Referrer field to header field conversion (1997)
Reversed words (1997)
Error with [applescript] (1999)
Credit Card Number checking (1997)
Cookie Crumble (1998)
RE: Emailer prefs in two places ... (1997)
Two prices in shoppingcart? (1997)
Formating found categories (1997)
Another Excel Problem (2003)