Re: same reseult set with less column

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 29 Sep 2008 18:09:11 -0800
Message-ID: <48e17c37@news.victoria.tc.ca>


Ed Prochak (edprochak_at_gmail.com) wrote:

: No offense intended, DT, but I've never been a fan of ROWNUM. It leads
: to wrong thinking about database results. The row count treats results
: like records instead of rows.

: And funny how it always seems to be web
: apps that use this most often.

Yes, because virtually every single web app in the world has to solve the identical problem - how to display a set of rows one page at a time so that the browser and user both receive a sensible amount of data, and often how to do this in a stateless manner.

 :) Received on Mon Sep 29 2008 - 21:09:11 CDT

Original text of this message