it's becaus Access is close enought to a RDBMS to not have the concept of "ordering" an unordered recordset. when an RDBMS query is run, it returns the records that match the SELECT statement, in no particular order (unless the ORDER BY clause is used), because the records exist in the relational model, not in a flat model.
christopher olive, cto, vp of web development atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:41 PM To: CF-Talk Subject: RE: Query question It's in that order in the access database that I use - using autonumber. And you're right, it is best to use order by. However, I was wondering what would have happened if I needed information in my database in the order that I view it, but it has no logical ordering column. Thanks, - Matt Small -----Original Message----- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:29 PM To: CF-Talk Subject: Re: Query question How do you know what the order is in the database? That is usually a hidden thing that you wouldn't see. At any rate, it's best prctice to use ORDER BY. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 5:59 PM Subject: Query question > I have a query that I run: > > <cfquery name="getshoworder" datasource="intranet"> > select * from showorder > </cfquery> > > > and > > <cfquery name="getshoworder" datasource="intranet"> > select * from showorder_#form.show# order by id > </cfquery> > > Knowing that the "order by id" is in the order that the data exists in > the table, why does the first query mix things up? > > - Matt Small > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
