It is something like:
SELECT * FROM table LIMIT 0,10
and then on the next page the limit becomes 10,20 and so on
A code ? ... hm ... not sure ... but if you get any software that does this
kind of list it could give a more precise idea on what I am talking here
about...
Sincerely,
Ma
Hello Joe,
On 04-Feb-01 22:01:37, you wrote:
>I was just meaning plain SQL - can't microsoft say ANSI? All I ask for is a
I don't think there is a standard way of achieving what the LIMIT clause
can that works for all or at least most databases.
>simple little standard and for people to follo
Joe,
Does SQL92 count?
Best regards,
Andrew
---
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness Infrastructure Technology
http://www.openlinksw.com
On 2/4/01 8:09 PM, "Joe Stump" <[EMAIL PROTECTED]> wrote:
> I was just meaning plain
I was just meaning plain SQL - can't microsoft say ANSI? All I ask for is a
simple little standard and for people to follow it - I'm not asking for every
feature of the standard - just a following.
--Joe
On Sun, Feb 04, 2001 at 10:43:37PM -0300, Manuel Lemos wrote:
> Hello Joe,
>
> On 04-Feb-01
Hello Joe,
On 04-Feb-01 21:18:55, you wrote:
>AFAIK this is more of a SQL thing than a DB specific thing. Just look up the
>LIMIT equivilent in MS SQL (should just be LIMIT) and use that for paging,
>once you get the hang of it it's quite easy.
>You can look through my paging class at www.miest
Hello Michael,
On 04-Feb-01 21:23:26, you wrote:
>AFAICT there is no 'LIMIT' feature in MS SQL products (TOP and supposedly
>BOTTOM, but BOTTOM has never worked for me and TOP doesn't seem to work on
>all versions).
>How is metabase handling this? Pulling everything, looping thru, and only
>re
AFAICT there is no 'LIMIT' feature in MS SQL products (TOP and supposedly BOTTOM,
but BOTTOM has never worked for me and TOP doesn't seem to work on all versions).
How is metabase handling this? Pulling everything, looping thru, and only
returning the requested rows?
Yes, I could log in/downloa
AFAIK this is more of a SQL thing than a DB specific thing. Just look up the
LIMIT equivilent in MS SQL (should just be LIMIT) and use that for paging, once
you get the hang of it it's quite easy.
You can look through my paging class at www.miester.org/software - it goes one
deeper and does [ pre
Hello Scott,
On 04-Feb-01 14:41:58, you wrote:
>Has anyone seen a good lession or code example on paging records from MS Sql
>7? Say I have 300 records and
>want to break them down to 10 per page using [previous | next ] and a list
>of page numbers at the bottom.
You may want to use Metabase t
I'm pretty sure there's no other way to do it but to read them all in and
only display what you need.
AFAIK, MSSQL doesn't support paging itself, but relies on the
ADO driver to do this. If you make an reference to an ADO object in
VBScript, you can set how many rows are in a 'page', then tell i
Scott,
As far as I know, MS SQL supports a syntax like this:
SELECT TOP 10 FROM table_name WHERE etc etc
However, I don't know how to make it start from a certain offset; I guess MS
SQL's documentation, especially the T-SQL doc, should help.
""Scott Parks"" <[EMAIL PROTECTED]> a écrit dans le
11 matches
Mail list logo
