Using [random]

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24012
interpreted = N
texte = Hi folks,I would like to return a random record out of a database, however, the number of records in the database can change each day (or actually from minute to minute).Any suggestions on returning a truly random record from the database?My thought so far is to do a search to grab the total number of records, and then doing something with the random context. But from there I am not sure how to actually grab that random record. Each record int he database does have an unique field. If it makes a difference, some databases have a unique number generated from webcat, the others were gernerated in a previous database.Thanksp.s I was wondering if anyone has created of is interested in working as a small group a fairly robust banner ad management system using webcat (maybe to build upon the sample files PCS has provided).__drt__ Associated Messages, from the most recent to the oldest:

    
  1. Re: Using [random] (Kenneth Grome 1999)
  2. Re: Using [random] (Kenneth Grome 1999)
  3. Re: Using [random] (Kenneth Grome 1999)
  4. Re: Using [random] (Christer Olsson 1999)
  5. Using [random] (webcat 1999)
  6. Using [random] (webcat 1999)
Hi folks,I would like to return a random record out of a database, however, the number of records in the database can change each day (or actually from minute to minute).Any suggestions on returning a truly random record from the database?My thought so far is to do a search to grab the total number of records, and then doing something with the random context. But from there I am not sure how to actually grab that random record. Each record int he database does have an unique field. If it makes a difference, some databases have a unique number generated from webcat, the others were gernerated in a previous database.Thanksp.s I was wondering if anyone has created of is interested in working as a small group a fairly robust banner ad management system using webcat (maybe to build upon the sample files PCS has provided).__drt__ webcat

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:

About the Allow 'Absolute Path' Prefix (2002) # fields limited? (1997) [WebDNA] v7 thisurl has different behavour (2012) Server crashes and triggers . . . are they linked? (2001) Running 2 two WebCatalog.acgi's (1996) WebCat2.0 [format thousands .0f] no go (1997) webcat and OS 8 (1997) Just Testing (1997) Quitting WebMerchant ? (1997) [IpAddress] Tag (1997) Off Topic: Help Wanted (1997) WebDNA permissions? (2002) DRC (2004) [format 40s]text[/format] doesn't work (1997) Thanks Grant (1997) Multiple Form Fields (2000) showif and cart (1997) banner ad redirection page (1999) WebCat for mass emailings (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997)