hmm..I believe with two tables you need to put the Number of the column,
rather than the column name that you want to sort by.
So do a simple CFOUTPUT of the results to see how the columns are ordered,
count the column number for Times..and use
ORDER BY 6 DESC instead of order by Times..
Umm...I believe..
if I'm wrong someone feel free to jump in :)
-Gel
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Hi,
I hope someone can point me in the right direction for thie query...
Querying 2 tables, and I want to order the results from the
viewed_numbers.times table, in descending order. So I did this (using * as
the tables are both small)
<cfquery name="getadvert" datasource="localads">
SELECT * FROM advert_details, viewed_numbers
WHERE advert_details.ID = viewed_numbers.adID
ORDER by times DESC
</cfquery>
It returns the results, but isn't following my ORDER by statement - they
appear to be randomly displayed.
What am I doing wrong?
Cheers
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
