I think rowcount is only found in Oracle.
Chris Walker
Brainbench MVP for ASP
http://www.brainbench.com
> -----Original Message-----
> From: Shawn Zhu [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 20, 2000 8:46 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JSP page that display 10 result...
>
>
> Not standard SQL statement...generates syntax error on Access.
>
> > -----Original Message-----
> > From: Antonio W. Lagnada [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 20, 2000 8:10 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: JSP page that display 10 result...
> >
> >
> > In your query use "rowcount"
> >
> > i.e.
> >
> > 1st query "SELECT * FROM table rowcount < 11";
> > 2nd query "SELECT * FROM table rowcount > 10 AND rowcount < 21";
> > etc...
> >
> > --
> > Antonio W. Lagnada
> > Ecommerce Consultant
> > [EMAIL PROTECTED]
> >
> > This email address is specifically
> > for JSP-Interest email list.
> > Remove _NOSPAM for the actual email.
> >
> >
> >
> > ---- Marco <[EMAIL PROTECTED]> wrote:
> > > How to make a JSP page that display 10 result (from a DB) per time
> > > and after
> > > with a next and prev link going forward the result??
> > > Can anyone explain me to this??
> > > Ca i have a code that explain this???
> > > Thanx in advance...
> > > marks
> > >
> > >
> > ==============================================================
> > =============
> > > To unsubscribe: mailto [EMAIL PROTECTED] with body:
> > "signoff JSP-INTEREST".
> > > Some relevant FAQs on JSP/Servlets can be found at:
> > >
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > >
> >
> > ___________________________________________________________________
> > To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax,
> > all in one place - sign up today at http://www.zdnetonebox.com
> >
> > ==============================================================
> > =============
> > To unsubscribe: mailto [EMAIL PROTECTED] with body:
> > "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set
> > JSP-INTEREST DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
