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:
RE: Symantec VIsual Page 1.0.3 (1997)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
For those of you not on the WebCatalog Beta... (1997)
How can I Add several Items into the cart at once? (1997)
Blasted shownext (request for 4.0) (1998)
[shownext] link disappears after first use. Why? (2000)
Secure server question (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
Max Record length restated as maybe bug (1997)
Add to Cart & List of Products (1997)
Hiding a subsection of text (2002)
2.0 Info (1997)
emailer stuck (1997)
Multiple SSL Keys (1998)
European dates (1998)
Help formatting search results w/ table (1997)
I'm new be kind (1997)
RequiredFields template (1997)
ListFields and [name] (1997)
WC Database Format (1997)