|
 |
asp_databases thread: Fetching Limited Data from a Dababase
Message #1 by "krishna kumar" <krishi_kk@u...> on Mon, 26 Feb 2001 18:58:33
|
|
Hi,
Is there a way in which I can limit the number of rows fetched from the
database at a time. we have a huge database (about 40 million rows) and
depending on the query, we need to display, say 4000 rows, and then be
able to fetch more rows and display the results on the website depending
on the query.
Any ideas or suggestions
Thanks in advance,
Krishna
Message #2 by "Jimenez, Sonny (S)" <SJimenez3@d...> on Mon, 26 Feb 2001 14:11:33 -0500
|
|
Use a navbar and limit the amount of rows you retrieve
Message #3 by "krishna kumar" <krishi_kk@u...> on Mon, 26 Feb 2001 19:35:07
|
|
> Use a navbar and limit the amount of rows you retrieve
Hi
Can u elaborate on this a bit please. I am using WIN NT 4.0, IIS , ASP
and teradata as the database
Thanks
Krishna
Message #4 by "Greg Covey" <gecovey@s...> on Mon, 26 Feb 2001 11:46:50 -0800
|
|
Check out this article at http://www.smashco.com/pages.asp
This may or may not help you, since you're talking about 40 million records.
Hope this helps,
Greg
Message #5 by Philo <philo@r...> on Mon, 26 Feb 2001 14:53:34 -0500
|
|
At 06:58 PM 2/26/2001 +0000, krishna kumar wrote:
>Hi,
> Is there a way in which I can limit the number of rows fetched from the
>database at a time. we have a huge database (about 40 million rows) and
>depending on the query, we need to display, say 4000 rows, and then be
>able to fetch more rows and display the results on the website depending
>on the query.
>
>Any ideas or suggestions
What database?
In SQL Server, I believe you want the TOP command for your select statement.
In Oracle, look into the rownum pseudocolumn.
Philo
Message #6 by "krishna kumar" <krishi_kk@u...> on Mon, 26 Feb 2001 20:16:40
|
|
Hi Philo,
The database is Teradata on UNIX.
Thanks
Krishna
> At 06:58 PM 2/26/2001 +0000, krishna kumar wrote:
> >Hi,
> > Is there a way in which I can limit the number of rows fetched from
the
> >database at a time. we have a huge database (about 40 million rows) and
> >depending on the query, we need to display, say 4000 rows, and then be
> >able to fetch more rows and display the results on the website depending
> >on the query.
> >
> >Any ideas or suggestions
>
> What database?
>
> In SQL Server, I believe you want the TOP command for your select
statement.
> In Oracle, look into the rownum pseudocolumn.
>
> Philo
Message #7 by "Jimenez, Sonny (S)" <SJimenez3@d...> on Mon, 26 Feb 2001 14:14:15 -0600
|
|
What are you using to create your asp pages?
Message #8 by "krishna kumar" <krishi_kk@u...> on Tue, 27 Feb 2001 14:39:41
|
|
> What are you using to create your asp pages?
>
Hi
We are using MS Visual Interdev to create the ASP pages.
Thanks,
Krishna
|
|
|
View Cart
