Re: fieldnamesdir=ra equivalent for [sql]
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41589
interpreted = N
texte = Hi JohnAfter having searched the mysql documentation I came up with:ORDER BY RAND()which seems to do the trick!Mac OS X 10.1.5 MySQL 3.23.51Just thought I'd let you know.on 15/7/02 6:12 pm, John Peacock at jpeacock@rowman.com wrote:> support_lists@cotsworth.com wrote: >> Does anybody know what the equivalent of fieldnamesdir=ra is when using >> [sql]? >> > > Doesn't exist, AFAIK. If you don't specify a sort order in a SQL query, you > get > whatever order the server feels like returning the records in and you > shouldn't > count on getting them in the same order each time. In most cases, you will > receive the records back in the order they were inserted into the database > (sometimes called natural order), but I wouldn't even count on that being > true. > > John-- Simon Cotsworth Producer/Engineer/Programmer=============================================================== M: 07973 233390 E: simon@cotsworth.com http://simon.cotsworth.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:
Hi JohnAfter having searched the mysql documentation I came up with:ORDER BY RAND()which seems to do the trick!Mac OS X 10.1.5 MySQL 3.23.51Just thought I'd let you know.on 15/7/02 6:12 pm, John Peacock at jpeacock@rowman.com wrote:> support_lists@cotsworth.com wrote: >> Does anybody know what the equivalent of fieldnamesdir=ra is when using >> [SQL]? >> > > Doesn't exist, AFAIK. If you don't specify a sort order in a SQL query, you > get > whatever order the server feels like returning the records in and you > shouldn't > count on getting them in the same order each time. In most cases, you will > receive the records back in the order they were inserted into the database > (sometimes called natural order), but I wouldn't even count on that being > true. > > John-- Simon Cotsworth Producer/Engineer/Programmer=============================================================== M: 07973 233390 E: simon@cotsworth.com http://simon.cotsworth.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/
support_lists@cotsworth.com
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:
Emailer (1997)
About Include (2001)
Menu to select product variations (1997)
Trigger: Only on Saturday (2001)
web merchant (2000)
Transferring [cart] to Database (1997)
[WebDNA] Talklist Archive & Twitter (2009)
WebCatalog Programmer looking for a new job (2001)
{Grouping} Docs (1999)
Date problems-more (1997)
weird convertchars behavior (2000)
Loops and [index] (1998)
[WebDNA] Crashing Database (2011)
[WebDNA] sem_open bugfix for os x version 6.2 (2012)
wc 2 pro users - sites, quotes wanted (1997)
Proposed FormVariables hierarchy (2000)
Emailer setup (1997)
[OT] Who's got a cool link (2002)
no global [username] or [password] displayed ... (1997)
Unable to open the demo file (1998)