Re: [WebDNA] Query re: autonumber
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105531
interpreted = N
texte = > Ken, > > Thanks for that. I think I'll stick to using cart for record IDs > then. > > A follow up question, if I am doing a bulk append to a db then I can > only create one [cart] on a template, so if I use the following > within a search context am I safe in not creating duplicate cart IDs: > > [search db=import.db&neIDdatarq=find_all][founditems] > > [append db=appendto.db]recordID=[cart][index][/append] > > [/founditems][/search] > > Thanks > - Tom Hi Tom, in the situation you just asked about, I have been in the habit of writing the IDs like this: [founditems] [append db=appendto.db]recordID=[cart]_[index][/append] [/founditems] ...because unless one knows *exactly* how cart strings are created... and what all are their possible values.. then conceivably a cart string could have already in the past been what you were about to write with your current (this page render) [cart] concatenated with one more digit (the [index]). RIght? But by separating the [cart] from the [index] with the underscore, then you KNOW that the complete ID will be unique because the unadulterated [cart] is always unique, and after the underscore will be unique on each iteration of [founditems] (in the context of *that* [cart]). If someone argues my case here, and says you were safe the way you were about to do it.. then I presume that it means they know more than I do about the possible range of cart strings. There must have been discussion on list in the past about that... but I think I was away at that time. ------------ Govinda govinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
> Ken, > > Thanks for that. I think I'll stick to using cart for record IDs > then. > > A follow up question, if I am doing a bulk append to a db then I can > only create one
[cart] on a template, so if I use the following > within a search context am I safe in not creating duplicate cart IDs: > > [search db=import.db&neIDdatarq=find_all]
[founditems] > > [append db=appendto.db]recordID=
[cart][index][/append] > > [/founditems][/search] > > Thanks > - Tom Hi Tom, in the situation you just asked about, I have been in the habit of writing the IDs like this:
[founditems] [append db=appendto.db]recordID=
[cart]_[index][/append] [/founditems] ...because unless one knows *exactly* how cart strings are created... and what all are their possible values.. then conceivably a cart string could have already in the past been what you were about to write with your current (this page render)
[cart] concatenated with one more digit (the [index]). RIght? But by separating the
[cart] from the [index] with the underscore, then you KNOW that the complete ID will be unique because the unadulterated
[cart] is always unique, and after the underscore will be unique on each iteration of
[founditems] (in the context of *that*
[cart]). If someone argues my case here, and says you were safe the way you were about to do it.. then I presume that it means they know more than I do about the possible range of cart strings. There must have been discussion on list in the past about that... but I think I was away at that time. ------------ Govinda govinda.webdnatalk@gmail.com
Govinda
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:
Properly implemented switch-case would be nice ... (2002)
Sorting a summary (2000)
Bug Report, maybe (1997)
# fields limited? (1997)
Math inside [showif] (1998)
webcat serving multiple copies of same db from ram (2000)
SIMS setup (1998)
RE: Any limit to [include] (1997)
Changing Date Format in Field (1999)
Version f1 status (1997)
Convertchars Problem (2004)
Is WebCat 3.0 necessary for calculating shipping? (2000)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Quitting WebMerchant ? (1997)
Bug Report, maybe (1997)
Missing from Docs [folderName] (1997)
[WebDNA] Processor Maxing out (2010)
Emailer [cart] file names (1997)
WebCatalog can't find database (1997)
Memory Error message (1998)