David Jones wrote:
> What database does this work on?
At least on PostgreSQL.
> I should have specified what database I am
> using. I am developing for Oracle 8i.
I presume you mean it doesn't work ;) You could try;
SELECT *
FROM (
SELECT *, Random() AS sortfield
FROM table
)
ORDER BY sortfield
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
