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:
[SHOWIF] (1997)
Shipping Calculation Problem (1997)
Configuring E-mail (1997)
Reversed words (1997)
WebMerchant and PCAuthorize (1998)
[WebDNA] Happy Valentine's Day! (2012)
Alternating colors (1997)
New Plug-in and Type 11 errors (1997)
Major problem (1999)
Two submit buttons ? (1997)
New command suggestion (1997)
[quantity] solved (1997)
A Global Variable (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
searchable list archive (1997)
WebCat2b12--[searchstring] bug (1997)
[WebDNA] Calculate Cube root (2012)
[delete] problem (1997)
bull, f**k (1998)
Encrypt question. (2000)