Select the first 10 records

[Yasmin_lady]

I have an access database and want to limit to limit the number of the records returned from a search to 10 ..
How can i do this ..
please help

[vkunirs]

Hi

Write the query like this:

select top 10 * from table.

or still in the cfquery also you can display the 10 records.

<cfquery maxrows="10" query="qryname">

[Yasmin_lady]

And how can i get the next 10 record from my search result

[fusionyogi]

You could use CFQUERY attributes startRow and maxRows to get a certain set of
records. from CF help files: startRow Optional. Specifies the row from which
to start output. maxRows Optional. Specifies the maximum number of rows to
display in the output section. Say you have 50 records and want to show 20 at
a time then for the first set your startRow and maxRows values are 1 and 20 and
for the next set 2 and 20 respectively. Only change the startRow and you are
all set. Hope this helps.

[ctrl+alt+delete]

If the data doesn't change frequently, you should perform one initial query
that gets all of the records, cache it, and then query that query for only
the number of records you want to output in your template using the
startrow/maxrows functionality previously mentioned.

"Yasmin_lady" <webforumsuser@macromedia.com> wrote in message
news:d01rkd$7d2$1@forums.macromedia.com...

> And how can i get the next 10 record from my search result
>