oracle doesnt accept a limit clause, so i have to work around that, any ideas! i been stuck on this issue over a few days...
-----Original Message----- From: Gary Stainburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 8:57 AM To: Coello, David; [EMAIL PROTECTED] Subject: Re: how to do paging of records On Wednesday 06 Aug 2003 1:40 pm, Coello, David wrote: > can anyone help me on how to do paging of records i want a few records per > page, im using oracle 8i.!!! and cgi. > david I personally would look at LIMIT and OFFSET clauses for your select statement to enable you to choose the chunk of records retrieved -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]