thanks for the concern. it is index order problem. getInt("num") works.
leo
-----Original Message-----
From: Andrea Lardicci [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 12:30 AM
To: [EMAIL PROTECTED]
Subject: Re: Data Type of 'Count(tblUser.status) AS num'?
Did you try getInt(num)?
AL
At 09.26 02/01/01 -0800, you wrote:
>Thank you all for the reply to my question.
>I tried 'getInt(1)', it doesn't work either.
>when i changed the query to
>
>select count(tblUsers.status) as num, tblUsers.username as temp
>from tblUsers
>group by tblUsers.username, tblUsers.status
>
>getString("temp") works fine, but not getInt("num").
>I think it data type problem for sql server. i may
>need to convert num to some jdbc specified datatype.
>
>any hint?
>
>thanks,
>
>leo
>
>
>-----Original Message-----
>From: Uday Bhosle [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 02, 2001 7:28 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Data Type of 'Count(tblUser.status) AS num'?
>
>
>I do not know why it should be a problem you can do two things
>first try using
>ResultSet.getInt(1) instead of
>ResultSet.getInt("num")
>
>second one try your code with other JDBC driver.
>
>Uday Bhosle
>B3Web Solutions
>
>
>
>
>
>"Liu, Leo Huaizhen" <[EMAIL PROTECTED]> on 01/02/2001 01:02:35 AM
>
>Please respond to "A mailing list for discussion about Sun Microsystem's
>Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>
>To: [EMAIL PROTECTED]
>cc: (bcc: Uday Bhosle/The Hub Group Inc.)
>Subject: Data Type of 'Count(tblUser.status) AS num'?
>
>
>
>Please help me out.
>
>I have query (SQL Server7.0)
> SELECT Count(tblUsers.status) AS num, username
> FROM tblUsers
> GROUP BY tblUsers.username,tblUsers.status
>
>However, the ResultSet.getInt("num") gave me error:
> javax.servlet.ServletException: [Microsoft][ODBC SQL Server
>Driver]Invalid Descriptor Index
> java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid
>Descriptor Index
>
>I don't know what data type of 'num' should be, and how to fix this error.
>Please help.
>Thanks,
>
>Leo.
>
>
>.....
>while (rs1.next())
>{
> out.println(rs1.getString("username")); //this is
>ok...
> out.println(String.valueOf(rs1.getInt("num")) //error here....
>}
>
>....
>
>___________________________________________________________________________
>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
___________________________________________________________________________
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
