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:
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
related data (2003)
Sorting Numbers (1997)
Include a big block of text (1997)
Searchable WebCat (etc.) Docs ? (1997)
[Sum] function? (1997)
[WebDNA] add rows dynamically (2018)
Protecting webdelivery (1997)
Using EIMS instead of Emailer (1998)
Re:listfiles-looking for slick solution (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Encrypted links ... (2000)
SiteEdit Pro Update Announcement (1997)
Emailer help....! (1997)
Validating A Date (2004)
WCS Newbie question (1997)
pc (1997)
Multi-processor Mac info ... (1997)
service stop and restart (1997)
Multiple catalog databases and showcart (1997)