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:
carriage returns in data (1997)
Off Topic: Help Wanted (1997)
More on the email templates (1997)
Protect Tag and Groups (1998)
Secure Server (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
Quit revisited (1997)
RE: Adding a product from another site (1997)
First postarg not taking in $Commands (1997)
Problems getting parameters passed into email. (1997)
[WebDNA] search by range of dates (2009)
PIXO (1997)
math/text variable limits per page (2001)
OT - Dig Sigs (2004)
ThreadMem ignored? (1998)
Problems appending to database (1997)
Talk List Suggestions (1997)
Another question (1997)
quantity [addlineitem] (2001)
Bug or syntax error on my part? (1997)