Re: [WebDNA] [replace] bug in v7.0?
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105912
interpreted = N
texte = Hi Chris,Thanks for testing. I just identified what I believe is the real problem. The [random] tag generates repeatable not random series of digits when used like this:[getchars start=1&end=14][loop start=1&end=14][random][/loop][/getchars]The chance of generating two identical values using this code should be one in 10 trillion so I was relying on this code to generate unique 14 character values when I could not use the [cart] tag to generate unique values ... but in an 80-line db I found that several of my skus contained repeating values generated by this code.:(My guess is that my replace context which used max=1 was replacing the [itemQuantity] value in only one of the matching sku records, then my search context was displaying the other matching sku record which had not been changed. This appeared to be a failure of the [replace] context when viewing the search results, and it wasn't until I looked at the db manually that I found the repeating sku values.Conclusion:The [random] tag generates values in the same pattern when used one after the other as in my code above, so don't use several [random] tags in a row if you need a unique value.Question:What do the rest of you use to create a bunch of unique sku values in one WebDNA template?Sincerely,Kenneth Grome> Hi Ken! we were unable to reproduce usin a test database:>> [replace> db=items.db&eqrefdatarq=[value]&max=1]column1=222222222[/replace]>> is working as expected, with and without &max=1>> Maybe are you using commerce tags somewhere else? v7.0 has commerce> tags disabled.>> - chris>> On Nov 2, 2010, at 18:06, Kenneth Grome wrote:> > Why doesn't this replace context work in v7.0 but it works in> > v6.2? I split it up on separate lines to simplify reading it in> > this email, but of course it all appears on one line in my> > template:> >> > [replace db=db.items.db> > &eqskudatarq=[url][sku][/url]> > &max=1]> > itemQuantity=[url][itemQuantity][/url]> > [/replace]> >> > v7.0 successfully appended the designated record to this db, but> > it fails to replace the itemQuantity value -- yet the same> > replace context works fine on v6.2.> >> > Bug???> >> > Sincerely,> > Kenneth Grome> >> > ---------------------------------------------------------> > This message is sent to you because you are subscribed to> > the mailing list
.> > To unsubscribe, E-mail to: > > archives: http://mail.webdna.us/list/talk@webdna.us> > Bug Reporting: support@webdna.us>> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Hi Chris,Thanks for testing. I just identified what I believe is the real problem. The [random] tag generates repeatable not random series of digits when used like this:[getchars start=1&end=14][loop start=1&end=14][random][/loop][/getchars]The chance of generating two identical values using this code should be one in 10 trillion so I was relying on this code to generate unique 14 character values when I could not use the [cart] tag to generate unique values ... but in an 80-line db I found that several of my skus contained repeating values generated by this code.:(My guess is that my replace context which used max=1 was replacing the [itemQuantity] value in only one of the matching sku records, then my search context was displaying the other matching sku record which had not been changed. This appeared to be a failure of the [replace] context when viewing the search results, and it wasn't until I looked at the db manually that I found the repeating sku values.Conclusion:The [random] tag generates values in the same pattern when used one after the other as in my code above, so don't use several [random] tags in a row if you need a unique value.Question:What do the rest of you use to create a bunch of unique sku values in one WebDNA template?Sincerely,Kenneth Grome> Hi Ken! we were unable to reproduce usin a test database:>> [replace> db=items.db&eqrefdatarq=[value]&max=1]column1=222222222[/replace]>> is working as expected, with and without &max=1>> Maybe are you using commerce tags somewhere else? v7.0 has commerce> tags disabled.>> - chris>> On Nov 2, 2010, at 18:06, Kenneth Grome wrote:> > Why doesn't this replace context work in v7.0 but it works in> > v6.2? I split it up on separate lines to simplify reading it in> > this email, but of course it all appears on one line in my> > template:> >> > [replace db=db.items.db> > &eqskudatarq=[url][sku][/url]> > &max=1]> > itemQuantity=[url][itemQuantity][/url]> > [/replace]> >> > v7.0 successfully appended the designated record to this db, but> > it fails to replace the itemQuantity value -- yet the same> > replace context works fine on v6.2.> >> > Bug???> >> > Sincerely,> > Kenneth Grome> >> > ---------------------------------------------------------> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > archives: http://mail.webdna.us/list/talk@webdna.us> > Bug Reporting: support@webdna.us>> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us
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:
Number date (2006)
California Tax Rates (1998)
How to include weather (2000)
Cannot get subtotal to work (1997)
Upgrading old WebCat Database Files (1997)
WCS Newbie question (1997)
b12 cannot limit records returned and more. (1997)
Frames and WebCat (1997)
browser info.txt and SSL (1997)
Security Tip (1996)
[WebDNA] looking for contract WebDNA coders (2011)
OT: Unix Guru Needed (2003)
ups quickcost [repost] (1999)
test for John (1999)
THANKS (1997)
all records returned. (1997)
problem with applets embedded in tpl files (1997)
presetting a [math] var not working (2000)
Old Topic - [OT] - server speeds. (2002)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)