Or since it's inline SQL, CreateUUID might work for any other DB.
<cfquery...>
SELECT TOP 5 *
FROM table
ORDER BY 'CreatUUID()'
</cfquery>
Give it a try, it might work.
Ade
BTW, I have installed SQL Server 2005 Beta 2, got a bunch of new features.
Now call me an idiot, but my favourite is dynamic TOP(n)!
-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 17:33
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] A new problem ???
Or try...
<cfquery...>
SELECT TOP 5 *
FROM table
ORDER BY NEWID()
</cfquery>
I think that will work on SS2k.
Ade
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
