How to specify the range of the selected data by core JDBC API?

How to specify the range of the selected data by core JDBC API?

Post by akokcha » Wed, 20 Feb 2002 18:35:14



Hello everybody,
  All search enginee will show a link group for page 1, page 2 and so on if
the record is too large. I met a problem that how to specify a range of data
from database by core JDBC API? Anybody can tell me the tips? Thank you..
 
 
 

How to specify the range of the selected data by core JDBC API?

Post by Davide Bianch » Wed, 20 Feb 2002 16:52:53



Quote:> I met a problem that how to specify a range of data
> from database by core JDBC API?

Simple way: just read from record numer X to record number Y
(where X start from 1 and Y is how-many-record-you-want-in-a-page),
then read from Y+1 to (page*Y) and so on and so forth...
In other word: you have to code the logic yourself.

Otherwise, see if your database have a way to "query" only a
subset of the rows. Not all the database have this kind of feature.

Davide

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

 
 
 

How to specify the range of the selected data by core JDBC API?

Post by ISOMa » Wed, 20 Feb 2002 21:02:56


Heck, I'd like to know how to do this with SQL in general :-)

> Hello everybody,
>   All search enginee will show a link group for page 1, page 2 and so on
>   if
> the record is too large. I met a problem that how to specify a range of
> data from database by core JDBC API? Anybody can tell me the tips? Thank
> you..

 
 
 

1. Selecting records within a specified date range!

Hi Guys

I would like to select records from a table within a specified date range.
The range would be from the Calendar month of July which would be constant
to the last complete Calendar month - so for example, today being the 5th of
Feb., I would only like to select records from July 2000 to January 2001
excluding the current month February.

I would be using a datetime column in the table - 'Created Date'.

I need to find a way to not only specify that the date in the 'Created Date'
column is to date back to July but also to exclude the current month.
I have played around with some of the Date functions but have not been able
to get it quite the way it should be.

Any Ideas?
Thanks

Zed

2. MI-GRAND RAPIDS-93849--ORACLE Financials-DBA Skills-Customer Support-Oracle Financials Specialists/DBAs

3. Selecting Records within a specified date range !

4. Indexes and Statistics query help

5. Row or column specified is outside the range of the specified query result set

6. NUMCPUVPS entry in onconfig.gic

7. Selecting Varchar range (through JDBC).

8. xp_cmdshell

9. Yearly Data from Selected Range of Datea

10. Select numeric data fom varchar but in a range of values

11. selecting range of data

12. Quaterly Data from Selected Range