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:
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)