Re: fieldnamesdir=ra equivalent for [sql]
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41582
interpreted = N
texte = 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-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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:
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-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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/
John Peacock
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:
Authentication (1998)
Initiating NewCart (1997)
WC2b15 File Corruption (1997)
b12 cannot limit records returned and more. (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Share Snippet? (1999)
Webcat 2.0.1 date math bug -> Crash! (1997)
NT b19 sends extra MIME headers (1997)
CAlendar (2003)
Error -108 (1997)
Extended [ConvertChars] (1997)
[WebDNA] RSS Feed help (2009)
%@#*& back button!!! (1999)
Separate SSL Server (1997)
Cart Creation (1998)
Nested tags count question (1997)
$purchase WITHOUT creditcar (1997)
webcat NT (1998)
Firesite and WebCat (1999)
lookup and two records? (1997)