Re: Multithreading of [replace]
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23112
interpreted = N
texte = >>Now that I've made all these comments, I have an even faster solution. The >>fact of the matter is that you don't need the search context at all. >>Therefore I would get rid of it completely. You can perform the same tasks >>shown above with a single replace and a single lookup, like this: >> >>[replace >>append=t&db=carts.db&eqCARTdata=[cart]&allcase=t]cart=[cart]&date=[date >>%Y/%m/%d]&firstpage=[lookup >>db=carts.db&value=[cart]&lookinfield=cart&returnfield=firstpage¬found=[thisu >>r >>l]] ]&lastpage=[thisurl][/replace] > >If I really, really had to stick with the original db solution I would >split that db into 10 different ones and store visitor 1 in db 1, visitor 2 >in db 2 and so on. The info of which db a visitor belongs to I would pass >in the URI.Good idea! An easy way to select which cart.db to use (cart0.db, cart1.db, cart2.db ... cart9.db) would be to grab the last digit of the cart value and use the db with that digit in its name, like this:[replace db=cart[getchars start=1&end=1&from=end][cart][/getchars].db& ...Of course, this assumes the visitor carries the cart value throughout his entire visit ... :)Sincerely, Ken Grome
Associated Messages, from the most recent to the oldest:
>>Now that I've made all these comments, I have an even faster solution. The >>fact of the matter is that you don't need the search context at all. >>Therefore I would get rid of it completely. You can perform the same tasks >>shown above with a single replace and a single lookup, like this: >> >>[replace >>append=t&db=carts.db&eqCARTdata=
[cart]&allcase=t]cart=
[cart]&date=[date >>%Y/%m/%d]&firstpage=[lookup >>db=carts.db&value=
[cart]&lookinfield=cart&returnfield=firstpage¬found=[thisu >>r >>l]] ]&lastpage=
[thisurl][/replace] > >If I really, really had to stick with the original db solution I would >split that db into 10 different ones and store visitor 1 in db 1, visitor 2 >in db 2 and so on. The info of which db a visitor belongs to I would pass >in the URI.Good idea! An easy way to select which cart.db to use (cart0.db, cart1.db, cart2.db ... cart9.db) would be to grab the last digit of the cart value and use the db with that digit in its name, like this:[replace db=cart[getchars start=1&end=1&from=end]
[cart][/getchars].db& ...Of course, this assumes the visitor carries the cart value throughout his entire visit ... :)Sincerely, Ken Grome
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:
is [Bankres] an internal webcat variable? (1999)
Writefile doesn't work, which permissions to use? (2005)
(2000)
WebCat2b15MacPlugin - [protect] (1997)
same bill to and ship to? (1998)
remotely add + sign (1997)
db merge problem (2002)
no global [username] or [password] displayed ... (1997)
Further on formula.db failure to calculate shipCost (1997)
Narrowing NT Crashing error (2000)
price totals (2003)
Best way to handle 404 errors with WebDNA and Web* V (2003)
Card clearance, problems - solutions? (1997)
2.1 Stuff (1998)
CommitDatabase vs. CloseDatabase (2001)
displaying 12 results 4 by 3 (2000)
WC2b15 File Corruption (1997)
looking for developers with solutions (2000)
Laying an egg. (1998)
Trouble with formula.db + more explanation (1997)