Hi Chris !
I am using MS ACCESS ( from Office Premium 2000)!
I tried to use count(*) from.... but error keeps coming...and I tried
various syntaxes ( if I was going wrong there ).
I am out actually ...I will get the errors tomorrow...However, I have tried
to use resultset.previous(), resultset.absolute(4) and I get the error
java.lang.UnsupportedOperationException when I run the servlet.
what drivers can I use with MS ACCESS ?
Thankx
Gautam
>From: Chris Pratt <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Total No. of records
>Date: Sat, 7 Aug 1999 14:13:40 -0700
>
>JDBC 2.0 is part of Java2 (i.e. jdk 1.2.x), but you must get the JDBC 2.0
>drivers from the Database vendor, and at the moment there aren't very many
>available. What Database are you using? And, what do you mean that "count
>is not working"?
> (*Chris*)
>
>----- Original Message -----
>From: Gautam Batra <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, August 07, 1999 6:41 AM
>Subject: Re: Total No. of records
>
>
> > Hi can someone tell me where can i get JDBC 2.0 driver or is it part of
> > jdk1.2.1 ?
> >
> > count is not working !
> >
> > Gautam
> > ----- Original Message -----
> > From: Joe Sam Shirah <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, August 07, 1999 5:30 PM
> > Subject: Re: Total No. of records
> >
> >
> > > >Use a database specific feature such as Oracle's COUNT
> > >
> > > The COUNT() column function, SELECT COUNT(*) FROM... is standard
>SQL.
> > >
> > > If one is fortunate enough to have a JDBC 2.0 driver ( can you say
> > > AS.400? ) one can also use
> > >
> > > resultset.last();
> > > int rownumber = resultset.getRow();
> > >
> > >
> > >
> > > Joe Sam Shirah
> > > Autumn Software
> > >
> > >
> >
>___________________________________________________________________________
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> > body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources:
>http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> > >
> >
> >
>___________________________________________________________________________
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
>body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
