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 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
> 3 David
> 4 Ilia
> 5 Uri
>
> I want to get Roman till Ilia, WITHOUT specifiying - WHERE personID
BETWEEN 2
> AND 4
> but Specifying something liek:
>
> SELECT ROWS 2 TILL 4 FROM personalls (without personID, which I want to
get!)
>
> Is this possible?
>
> Michael.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
