> Or since it's inline SQL, CreateUUID might work for any other DB. In MySQL you'd use:
SELECT * FROM table ORDER BY RAND() LIMIT 5 > Now call me an idiot Er, you're an idiot? ;) -- ------------------------------------------------------- Badpen Tech - CF and web-tech: http://tech.badpen.com/ ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 08 September 2004 17:48 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] A new problem ??? > > 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] > > -- 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]
