Well, imagine this...ROW_NUMBER is used in dynamic evaluation of resultsets in T-SQL...think of it like CF MOD paging in SQL....it allows you amongst other things to bring back a set (or single) row based on its rank in the current resultset.
Your example needs to be something like : SELECT ROW_NUMBER() OVER(ORDER BY FIELD1) AS rownum, FIELD1, FIELD2, .[...] FROM YOURTBLE ORDER BY FIELD1 Basically its gonna be a function you will or will not use, it all depends on one thing...do you regard your rows in a table as logical or simply insertions with no logical order? One N -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? How can you use ROW_NUMBER()? My first thought was something like this... SELECT *, ROW_NUMBER() OVER(ORDER BY TestID) AS RowNumber FROM tblTest WHERE RowNumber BETWEEN 10 AND 20 ORDER BY RowNumber .. but you can't have the alias in the WHERE clause. Am I missing the point? Ade -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 10:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? I have loved it so far...come a long way from Alpha....to be honest is the T-SQL additions / modifications which are proving to be fantastic..... ROW_NUMBER is one of those holy grail (and nemesis) of RDBMS...some people require it etc and some people think its stupid.....jeez Oracle has had these abilities for while now. The biggest addition has to be Reporting Services (now available for 2K also) and the integration of the CLR...which is huge for us. N -- 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] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- 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]
