with Access no. you could bring back all the data and display only the results
you want with cfloop but that is inefficient and a hackish mess.
"Michael Lugassy" <[EMAIL PROTECTED]> wrote:
Alex,
The Database is Access, how can I loop, exactly?
Michael.
> what dastabase? you could do it it in a
This makes no sense. Unless you've got an "order by" clause, there is no order
to the rows, so choosing rows 2-4 is no different than choosing rows 1-3 or
18-20.
Perhaps you want "order by personID asc" combined with "select top 4", and then
ignore the 1st row in the result.
-David
On Sunday,
Alex,
The Database is Access, how can I loop, exactly?
Michael.
> what dastabase? you could do it it in a stored proc with a loop
>
> "Michael Lugassy" <[EMAIL PROTECTED]> wrote:
>
> Is it possible to SQL-SELECT a specific number of rows from between the
result
> set.
> NOT by using the BETWEEN
what dastabase? you could do it it in a stored proc with a loop
"Michael Lugassy" <[EMAIL PROTECTED]> wrote:
Is it possible to SQL-SELECT a specific number of rows from between the result
set.
NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
to select only rows x through y.
Is it possible to SQL-SELECT a specific number of rows from between the result set.
NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
to select only rows x through y.
let's say I have this results set
personID personNAME
1 Michael
2 Roman
5 matches
Mail list logo
