Re: Random

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31878
interpreted = N
texte = This is a very cool solution, and I appreciate the detail. Given that I'm NOT just showing a single banner, though, is it practical to use this in a situation where there may need to be 100 + ads on a single page? Or will it take a lot of time and processor cycles to write to the database after each ad in my case?Thanks, -- Patrick Junkroski Webmaster http://www.vsm.net ---------- >From: Joseph D'Andrea >To: (WebCatalog Talk) >Subject: Re: Random >Date: Mon, May 15, 2000, 1:11 PM >> My solution was to add a field for rotation weight to the ads > database that I called RotWeight. > > You'll need to set the rotation weight to zero for each new record > added and you'll need to have a link on our admin page that sets the > rotation weight to zero in all the records in your database. > > [Search db=ads.db&neSKUdata=0] > [FoundItems] > [replace db=ads.db&eqSKUdata=[SKU]]RotWeight=0[/replace] > [/FoundItems] > [/Search] > > > Then you search on the rotation weight and increment it by one like this: > [Search > db=ads.db&StartDateType=date&EndDateType=date&leStartDatedatarq=[date] > &geEndDatedatarq=[date]&ROTWEIGHTtype=num&ROTWEIGHTsort=1&ROTWEIGHTsdi > r=as&max=1] > > [FoundItems] > border=0 src=BannerGraphics/[url][Picture][/url]> > [Replace > db=ads.db&eqSKUdatarq=[SKU]]NumViews=[math][NumViews]+1[/math]&RotWeig > ht=[math][RotWeight]+1[/math][/Replace] > [/FoundItems] > [/Search] > > Good luck! > > ___Joe___ > > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.com/ > _________________________________________________ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  2. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  3. Re: [WebDNA] random blank results? how come? ("Psi Prime Inc, Matthew A Perosi " 2014)
  4. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  5. Re: [WebDNA] random blank results? how come? (Kenneth Grome 2014)
  6. Re: [WebDNA] random blank results? how come? (Toby Cox 2014)
  7. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  8. Re: [WebDNA] random blank results? how come? (sgbc cebu 2014)
  9. Re: [WebDNA] random blank results? how come? (Stuart Tremain 2014)
  10. Re: [WebDNA] random blank results? how come? (Toby Cox 2014)
  11. [WebDNA] random blank results? how come? (sgbc cebu 2014)
  12. Re: [WebDNA] Random Numbers no repeat within a range (Stuart Tremain 2014)
  13. RE: [WebDNA] Random Numbers no repeat within a range ("Vincent Medina" 2014)
  14. Re: [WebDNA] Random Numbers no repeat within a range (Stuart Tremain 2014)
  15. RE: [WebDNA] Random Numbers no repeat within a range ("Vincent Medina" 2014)
  16. Re: [WebDNA] Random Numbers no repeat within a range (Dan Strong 2014)
  17. [WebDNA] Random Numbers no repeat within a range ("Vincent Medina" 2014)
  18. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  19. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  20. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (christophe.billiottet@webdna.us 2011)
  21. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  22. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  23. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (christophe.billiottet@webdna.us 2011)
  24. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  25. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (christophe.billiottet@webdna.us 2011)
  26. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (Kenneth Grome 2011)
  27. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  28. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  29. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  31. Re: [WebDNA] Re: WebDNA7 site randomly dropping tags (christophe.billiottet@webdna.us 2011)
  32. [WebDNA] Re: WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  33. [WebDNA] WebDNA7 site randomly dropping tags (aaronmichaelmusic@gmail.com 2011)
  34. Re: [WebDNA] [random] limit 1-10 (Stephen Braun 2010)
  35. Re: [WebDNA] [random] limit 1-10 ("Dan Strong" 2010)
  36. Re: [WebDNA] [random] limit 1-10 (Govinda 2010)
  37. Re: [WebDNA] [random] limit 1-10 (Tom Duke 2010)
  38. Re: [WebDNA] [random] limit 1-10 ("Dan Strong" 2010)
  39. Re: [WebDNA] [random] limit 1-10 (Kenneth Grome 2010)
  40. [WebDNA] [random] limit 1-10 (Stephen Braun 2010)
  41. Re: [WebDNA] [sendmail] random duplicates (Donovan Brooke 2010)
  42. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  43. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  44. Re: [WebDNA] [sendmail] random duplicates (Stuart Tremain 2010)
  45. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  46. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  47. [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  48. Re: [WebDNA] WebDNA 4.5.1 process DBServer.exe memory allocation is skyrocketing at random intervals. (Stuart Tremain 2008)
  49. OT: Javascript Random Number ( Clint Davis 2007)
  50. WIDGET: random image generator ( Donovan Brooke 2007)
  51. WIDGET: random image generator ( Donovan Brooke 2007)
  52. Re: Random/Odd/Even Listings ( "WebDna @ Inkblot Media" 2005)
  53. Re: Random/Odd/Even Listings ( "WebDna @ Inkblot Media" 2005)
  54. Re: Random/Odd/Even Listings ( Jesse Proudman 2005)
  55. Random/Odd/Even Listings ( Ki Il Song 2005)
  56. Re: Random Generator ( Ki Il Song 2005)
  57. Re: Random Generator ( Ki Il Song 2005)
  58. Re: Random Generator ( Clint Davis 2005)
  59. Random Generator ( Ki Il Song 2005)
  60. Re: New random discoveries? ( matthew.bohne@benetela.com 2005)
  61. Re: New random discoveries? ( "Justin Carroll" 2005)
  62. Re: New random discoveries? ( John Peacock 2005)
  63. Re: New random discoveries? ( Jesse Proudman 2005)
  64. Re: New random discoveries? ( matthew.bohne@benetela.com 2005)
  65. Re: New random discoveries? ( John Peacock 2005)
  66. Re: New random discoveries? ( "Justin Carroll" 2005)
  67. Re: New random discoveries? ( "WebDna @ Inkblot Media" 2005)
  68. New random discoveries? ( "Justin Carroll" 2005)
  69. Re: Random Links ( Stuart Tremain 2004)
  70. Re: Random Links ( Stuart Tremain 2004)
  71. Re: Random Links ( "Paul Berman" 2004)
  72. Re: Random links from datatbase ( Brian Fries 2004)
  73. Re: Random links from datatbase ( "Paul Berman" 2004)
  74. Re: Search Sort Random ( Kenneth Grome 2004)
  75. Search Sort Random ( frank@cwolfe.com 2004)
  76. Re: random in arizona ( Jesse Williams-Proudman 2003)
  77. Re: random in arizona ( Scott Anderson 2003)
  78. Re: random in arizona ( Jesse Williams-Proudman 2003)
  79. Re: random in arizona ( "WebDna @" 2003)
  80. Re: random in arizona ( Jesse Williams-Proudman 2003)
  81. Re: random in arizona ( "WebDna @" 2003)
  82. Re: random in arizona ( marc@kaiwi.com (Marc Kaiwi) 2003)
  83. Re: random in arizona ( "Dan Strong" 2003)
  84. Re: random in arizona ( Donovan Brooke 2003)
  85. Re: random in arizona ( "Dan Strong" 2003)
  86. Re: random in arizona ( "Dan Strong" 2003)
  87. Re: random in arizona ( "Dan Strong" 2003)
  88. Re: random in arizona ( "Dan Strong" 2003)
  89. Re: random in arizona ( Jesse Williams-Proudman 2003)
  90. Re: random in arizona ( marc@kaiwi.com (Marc Kaiwi) 2003)
  91. Re: random in arizona ( Jesse Williams-Proudman 2003)
  92. Re: random in arizona ( marc@kaiwi.com (Marc Kaiwi) 2003)
  93. Re: random in arizona ( marc@kaiwi.com (Marc Kaiwi) 2003)
  94. Re: random in arizona ( Jeff Logan 2003)
  95. Re: random in arizona ( marc@kaiwi.com (Marc Kaiwi) 2003)
  96. random in arizona ( Jeff Logan 2003)
  97. Re: Random Sort Problem ( Steve Craig 2003)
  98. Re: Random Sort Problem ( Donovan 2003)
  99. Random Sort Problem ( Steve Craig 2003)
  100. Re: random prob (Ron Ceballos 2003)
  101. Re: random prob (Glenn Busbin 2003)
  102. Re: random prob (Rob Marquardt 2003)
  103. Re: random prob (Ron Ceballos 2003)
  104. Re: random prob (Glenn Busbin 2003)
  105. Re: random prob (Beljaeff, Gene 2003)
  106. Re: random prob (Rob Marquardt 2003)
  107. Re: random prob (Ron Ceballos 2003)
  108. Re: random prob (Rob Marquardt 2003)
  109. Re: random prob (Ron Ceballos 2003)
  110. Re: random prob (Rob Marquardt 2003)
  111. Re: random prob (John Peacock 2003)
  112. Re: random prob (Glenn Busbin 2003)
  113. Re: random prob (Ron Ceballos 2003)
  114. Re: random prob (Rob Marquardt 2003)
  115. random prob (Ron Ceballos 2003)
  116. different sized random banners (Lester Emo 2003)
  117. Re: Random again (Rob Marquardt 2003)
  118. Random again (Tim Robinson 2003)
  119. ver 4 random crashes (Terry Wilson 2003)
  120. Re: random .inc files pulled and placed (Dale's Stuff 2002)
  121. Re: random .inc files pulled and placed (Alain Russell 2002)
  122. Re: random .inc files pulled and placed (Lester Emo 2002)
  123. Re: random .inc files pulled and placed (Stuart Tremain 2002)
  124. random .inc files pulled and placed (Lester Emo 2002)
  125. Re: Bug in random search - MacOS v4.5 plugin ... (Kenneth Grome 2002)
  126. Re: Bug in random search - MacOS v4.5 plugin ... (Frank Nordberg 2002)
  127. Re: Bug in random search - MacOS v4.5 plugin ... (Kenneth Grome 2002)
  128. Re: Bug in random search - MacOS v4.5 plugin ... (Brian Fries 2002)
  129. Re: Bug in random search - MacOS v4.5 plugin ... (Kenneth Grome 2002)
  130. Bug in random search - MacOS v4.5 plugin ... (Kenneth Grome 2002)
  131. Re: Random search is not random (Tim Robinson 2002)
  132. Re: Random search is not random (Glenn Busbin 2002)
  133. Re: Random search is not random (Alain Russell 2002)
  134. Random search is not random (Tim Robinson 2002)
  135. Re: Was random sort ever dealt with effectively??? (Alain Russell 2002)
  136. Was random sort ever dealt with effectively??? (Lester Emo 2002)
  137. Re: Non-repeating Random Numbers - CORRECTION (Dan Strong 2002)
  138. Re: Non-repeating Random Numbers - CORRECTION (Brian Fries 2002)
  139. Re: Non-repeating Random Numbers - CORRECTION (Stuart Tremain 2002)
  140. Re: Non-repeating Random Numbers - CORRECTION (Dan Strong 2002)
  141. Re: Non-repeating Random Numbers - CORRECTION (Stuart Tremain 2002)
  142. Re: Non-repeating Random Numbers - CORRECTION (Andrew Simpson 2002)
  143. Re: Non-repeating Random Numbers - CORRECTION (Andrew Simpson 2002)
  144. Re: Non-repeating Random Numbers (Andrew Simpson 2002)
  145. Re: Non-repeating Random Numbers - CORRECTION (Dan Strong 2002)
  146. Re: Non-repeating Random Numbers - CORRECTION (Dan Strong 2002)
  147. Re: Non-repeating Random Numbers (Dan Strong 2002)
  148. Re: Non-repeating Random Numbers (John Peacock 2002)
  149. Non-repeating Random Numbers (Dan Strong 2002)
  150. Re: Picking a random entry from a .db (Matthew Bohne 2001)
  151. Re: Picking a random entry from a .db (Maurice Rickard 2001)
  152. Re: Picking a random entry from a .db (Nitai @ ComputerOil 2001)
  153. Picking a random entry from a .db (Matthew Bohne 2001)
  154. Re: (random sorting) (Brian Fries 2001)
  155. Re: Random bug, OSX 10.04 (John Peacock 2001)
  156. Re: Random bug, OSX 10.04 (Paul Fowler 2001)
  157. Re: Random bug, OSX 10.04 (John Peacock 2001)
  158. Random bug, OSX 10.04 (Paul Fowler 2001)
  159. Re: Random letter and/or number (Stuart Tremain 2001)
  160. Re: Random letter and/or number (John Peacock 2001)
  161. Re: Random letter and/or number (Marc Frechet 2001)
  162. Re: Random letter and/or number (Kenneth Grome 2001)
  163. Re: Random letter and/or number (Michael Davis 2001)
  164. Random letter and/or number (Stuart Tremain 2001)
  165. Re: random within a specified range (Alisha Outridge 2001)
  166. Re: random within a specified range (Andrew Simpson 2001)
  167. Re: random within a specified range (Alisha Outridge 2001)
  168. Re: random within a specified range (Clayton Randall 2001)
  169. Re: random within a specified range (Alisha Outridge 2001)
  170. random within a specified range (Andrew Simpson 2001)
  171. Re: are we ready to fix random sort? - Or did that already happen? (John Butler 2000)
  172. Re: are we ready to fix random sort? - Or did that already happen? (Grant Hulbert 2000)
  173. Re: are we ready to fix random sort? - Or did that already happen? (John Butler 2000)
  174. Re: are we ready to fix random sort? - Or did that already happen? (Grant Hulbert 2000)
  175. Re: are we ready to fix random sort? - Or did that already happen? (John Butler 2000)
  176. Re: Random (Cameron Bales .:. 2000)
  177. Re: Random (Patrick 2000)
  178. Re: Random (Cameron Bales .:. 2000)
  179. Re: Random (Patrick 2000)
  180. Re: Random (Joseph D'Andrea 2000)
  181. Re: Random (Patrick 2000)
  182. Re: Random (John Peacock 2000)
  183. Random (Patrick 2000)
  184. are we ready to fix random sort? (John Butler 2000)
  185. Re: Random info is still wrong ... (Kenneth Grome 2000)
  186. Re: DocNote#2 - Random info is still wrong ... (Grant Hulbert 2000)
  187. DocNote#2 - Random info is still wrong ... (Kenneth Grome 2000)
  188. Re: necessary? (Kenneth Grome 2000)
  189. Re: (jpeacock@univpress.com 2000)
  190. Re: (John Butler 2000)
  191. necessary? (John Butler 2000)
  192. Re: Random Images (Nicolas Verhaeghe 2000)
  193. Re: Random Images (Nicolas Verhaeghe 2000)
  194. Random Images (Gregory Scott 2000)
  195. Re: Random Order Sort? (Karl Goiser 2000)
  196. Re: Random Order Sort? (John Butler 2000)
  197. Re: Random Order Sort? (WebDNA Support 2000)
  198. Random Order Sort? (Karl Goiser 2000)
  199. Re: Balancing randomness (Rob Marquardt 2000)
  200. Re: Balancing randomness (Peter Ostry 2000)
  201. Re: SOLUTION.... Re: Balancing randomness (Rob Marquardt 2000)
  202. Re: Balancing randomness (Christer Olsson 2000)
  203. Re: SOLUTION.... Re: Balancing randomness (Kenneth Grome 2000)
  204. Re: SOLUTION.... Re: Balancing randomness (Rob Marquardt 2000)
  205. SOLUTION.... Re: Balancing randomness (Joseph D'Andrea 2000)
  206. Re[2]: Balancing randomness (Kenneth Grome 2000)
  207. Re: Balancing randomness (Joseph D'Andrea 2000)
  208. Re: Balancing randomness (John Butler 2000)
  209. Re[2]: Balancing randomness (Joseph D'Andrea 2000)
  210. Re: Balancing randomness (Miguel Castaneda 2000)
  211. Re: Balancing randomness (Rob Marquardt 2000)
  212. Re: Balancing randomness (Joseph D'Andrea 2000)
  213. Re[2]: Balancing randomness (jpeacock@univpress.com 2000)
  214. Re[2]: Balancing randomness (jpeacock@univpress.com 2000)
  215. Re: Balancing randomness (Peter Ostry 2000)
  216. Re: Balancing randomness (Rob Marquardt 2000)
  217. Re: Balancing randomness (Joseph D'Andrea 2000)
  218. Re: Balancing randomness (jpeacock@univpress.com 2000)
  219. Balancing randomness (Rob Marquardt 2000)
  220. Re: Random sort is not random at all..... (Paul Willis 2000)
  221. Re: Random sort is not random at all..... (Dale LaFountain 2000)
  222. Re: Random sort is not random at all..... (Nicolas Verhaeghe 2000)
  223. Re: Random sort is not random at all..... (Kenneth Grome 2000)
  224. Re: Random sort is not random at all..... (Joseph D'Andrea 2000)
  225. Re: Random sort is not random at all..... (Nicolas Verhaeghe 2000)
  226. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (Christopher Feyrer 2000)
  227. Re: Random sort is not random at all..... (Webcat 2000)
  228. Re: Random sort is not random at all..... (John Butler 2000)
  229. BUG: Random sort is not random at all..... (Joseph D'Andrea 2000)
  230. Random sort is not random at all..... (Joseph D'Andrea 2000)
  231. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  232. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  233. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (Dale LaFountain 2000)
  234. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Hill 2000)
  235. Re: random sorting broken (was Re: Re[2]: php vs WebCatalog) (John Butler 2000)
  236. random sorting broken (was Re: Re[2]: php vs WebCatalog) (Dale LaFountain 2000)
  237. Re: Webcatalog Future?!? - Was Re: &fieldsdir=ra truely random?? (J Lane 2000)
  238. Re: Webcatalog Future?!? - Was Re: &fieldsdir=ra truely random?? (Bob Minor 2000)
  239. Webcatalog Future?!? - Was Re: &fieldsdir=ra truely random?? (J Lane 2000)
  240. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  241. Re: &fieldsdir=ra truely random?? (John Butler 2000)
  242. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  243. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  244. Re: &fieldsdir=ra truely random?? (Kenneth Grome 2000)
  245. Re: &fieldsdir=ra truely random?? (John Butler 2000)
  246. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  247. Re: &fieldsdir=ra truely random?? (Webcat 2000)
  248. Re: &fieldsdir=ra truely random?? (John Butler 2000)
  249. Re: &fieldsdir=ra truely random?? (John Butler 2000)
  250. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  251. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  252. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  253. Re: &fieldsdir=ra truely random?? (Jesse Williams Proudman 2000)
  254. Re: &fieldsdir=ra truely random?? (Kenneth Grome 2000)
  255. Re: &fieldsdir=ra truely random?? (John Butler 2000)
  256. Re: &fieldsdir=ra truely random?? (Kenneth Grome 2000)
  257. &fieldsdir=ra truely random?? (John Butler 2000)
  258. Re: Generating a random image, but avoiding repeated images. (jpeacock@univpress.com 1999)
  259. Re: Generating a random image, but avoiding repeated images. (Conrad Hubbard 1999)
  260. Generating a random image, but avoiding repeated images. (Christopher Feyrer 1999)
  261. Re: (2) Leading reasons for TCPConnect randomly failing? (Charlie Romero 1999)
  262. Leading reasons for TCPConnect randomly failing? (Charlie Romero 1999)
  263. Re: Using [random] (Kenneth Grome 1999)
  264. Re: Using [random] (Kenneth Grome 1999)
  265. Re: Using [random] (Kenneth Grome 1999)
  266. Re: Using [random] (Christer Olsson 1999)
  267. Using [random] (webcat 1999)
  268. Using [random] (webcat 1999)
  269. Multiple searches on a single page / random record from full database? (webcat 1999)
  270. Re: random random links (Josh Knauer 1999)
  271. Re: random random links (Josh Knauer 1999)
  272. Re: random random links (Josh Knauer 1999)
  273. Re: random random links (Martin Bech 1999)
  274. Re: random random links (PCS Technical Support 1999)
  275. random random links (Richard 1999)
  276. Banner not random (Edwin Hoevers 1999)
  277. Re: Random tags HELP!!!! (Rob Marquardt 1999)
  278. Random tags HELP!!!! (Talklist 1999)
  279. Re: Random tags HELP!!!! (Martin Bech 1999)
  280. Re: Random ads (Britt T. 1998)
  281. Random ads (Wilkins, John 1998)
  282. Random ads (Wilkins, John 1998)
  283. Random ads (Wilkins, John 1998)
  284. Re: ShowNext and random sort (PCS Technical Support 1998)
  285. Re: ShowNext and random sort (Dave MacLeay 1998)
  286. Re: ShowNext and random sort (PCS Technical Support 1998)
  287. ShowNext and random sort (Trevor Crist 1998)
  288. Re: Random Image (PCS Technical Support 1998)
  289. Random Image (Mícheál O Sé 1998)
  290. Re: Random question (Peter Ostry 1998)
  291. Re: Random question (bob 1998)
  292. Re: Random question (Brian B. Burton 1998)
  293. Random question (Kenneth Grome 1998)
  294. Re:Random Command (Jay Van Vark 1997)
  295. Random Command (Paul Keen 1997)
  296. Re: random images (Raymond Hatch 1997)
  297. Re: random images (Grant Hulbert 1997)
  298. Re: randomness (John Hill 1997)
  299. randomness (Brian B. Burton 1997)
  300. random images (Raymond Hatch 1997)
  301. Random Number Generator works for Ranges of Numbers (Kenneth Grome 1997)
  302. Re: [random] only for 1-100??? (Kenneth Grome 1997)
  303. Re: [random] only for 1-100??? (Kenneth Grome 1997)
  304. Re: [random] only for 1-100??? (Kenneth Grome 1997)
  305. Re: [random] only for 1-100??? (Daniel Cameron 1997)
  306. Re: [random] only for 1-100??? (Daniel Cameron 1997)
  307. [random] only for 1-100??? (Daniel Cameron 1997)
  308. Re: Banners and sort of random display (Grant Hulbert 1997)
  309. Re: Banners and sort of random display (Kenneth Grome 1997)
  310. Banners and sort of random display (grichter@panavise.com (Gary Richter) 1997)
  311. [random] ( will)
  312. random password-generator code (Dan Strong Gene)
This is a very cool solution, and I appreciate the detail. Given that I'm NOT just showing a single banner, though, is it practical to use this in a situation where there may need to be 100 + ads on a single page? Or will it take a lot of time and processor cycles to write to the database after each ad in my case?Thanks, -- Patrick Junkroski Webmaster http://www.vsm.net ---------- >From: Joseph D'Andrea >To: (WebCatalog Talk) >Subject: Re: Random >Date: Mon, May 15, 2000, 1:11 PM >> My solution was to add a field for rotation weight to the ads > database that I called RotWeight. > > You'll need to set the rotation weight to zero for each new record > added and you'll need to have a link on our admin page that sets the > rotation weight to zero in all the records in your database. > > [Search db=ads.db&neSKUdata=0] > [founditems] > [replace db=ads.db&eqSKUdata=[SKU]]RotWeight=0[/replace] > [/FoundItems] > [/Search] > > > Then you search on the rotation weight and increment it by one like this: > [Search > db=ads.db&StartDateType=date&EndDateType=date&leStartDatedatarq=[date] > &geEndDatedatarq=[date]&ROTWEIGHTtype=num&ROTWEIGHTsort=1&ROTWEIGHTsdi > r=as&max=1] > > [founditems] > [url][sku][/url] target=_blank> border=0 src=BannerGraphics/[url][Picture][/url]> > [Replace > db=ads.db&eqSKUdatarq=[SKU]]NumViews=[math][NumViews]+1[/math]&RotWeig > ht=[math][RotWeight]+1[/math][/Replace] > [/FoundItems] > [/Search] > > Good luck! > > ___Joe___ > > _________________________________________________ > Joseph D'Andrea JoeDan@West21.com > WEST21.com Internet services for the 21st Century > http://www.west21.com/ > _________________________________________________ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Patrick

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:

Setting up WebCatalog with Retail Pro data (1996) [date format] w/in sendmail (1997) [OT] SQL and Crackers (2000) Click-through/Referral tracking solution needed (2000) Quit revisited (1997) [WebDNA] Triggers issue, or sendmail? (2012) WAP (2000) [WebDNA] Feature Request [TABLE ... &delimiters=] (2008) WebCat2 Append problem (B14Macacgi) (1997) Summarising on two fields (1998) RE: Loss in form (1998) createfolder not behaving as expected (1999) sendmail and proper header formatting (2005) Credit card types (1997) [ShowNext] (1997) Searching for a space (2000) Help formatting search results w/ table (1997) Search in 2 or more catalogs (1997) WebCat Beta NT 18 (1997) Nesting format tags (1997)