Re: [WebDNA] [replace] bug in v7.0?
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 105913
interpreted = N
texte = [search db=my.db&neSKUdata-findall][math show=f]num=[numfond]+1[/math][/search][text show=t]timestamp=[math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math][random][num][/text]MarcOn 11/2/2010 4:09 PM, Kenneth Grome wrote:> 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> ---------------------------------------------------------> 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> .>-- -------------------------------------------Marc ThompsonSoftware EngineerMedia SolutionsUniversity Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu-------------------------------------------
Associated Messages, from the most recent to the oldest:
[search db=my.db&neSKUdata-findall][math show=f]num=[numfond]+1[/math][/search][text show=t]timestamp=[math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math][random][num][/text]MarcOn 11/2/2010 4:09 PM, Kenneth Grome wrote:> 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> ---------------------------------------------------------> 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> .>-- -------------------------------------------Marc ThompsonSoftware EngineerMedia SolutionsUniversity Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu-------------------------------------------
Marc Thompson
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:
$Replace with [founditems] (1997)
Exclamation point (1997)
with Link i need to (1997)
OK, here goes... (1997)
Error Msg (1998)
WebCat b13 CGI -shownext- (1997)
2.1 pricing? (1998)
server2003 isolation mode (2004)
dates and hex formatting (1997)
Digest for 4/18/97 (1997)
Showing unopened cart (1997)
RE: Explorer oddities (1997)
user flush db (2002)
php vs WebCatalog (2000)
Ready,Set; Print! (1999)
[WebDNA] testing (2012)
show all problem (1997)
Forms & Tables (1998)
[writefile] (1997)
Moment of Thanks (1997)