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 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
