Re: doubt in oracle high priority

I wonder how u'd have a resultset without knowing the cloumn index.  May be you did a "select * from tablename".   If that is the case, get the cloumn count  (getColumnCount()) and iterate through. While in the loop, get the the actual column name (getColumnName(index)) and then compare it to the cloumn name u want before calling getColumnDisplaySize on the index.

Hope that helps.

Emmanuel Eze
  ----- Original Message ----- 
  From: shashi kanth 
  To: [email protected] 
  Sent: Friday, February 11, 2005 11:20 AM
  Subject: doubt in oracle high priority


   
  hi All,
          Iam using oracle i need to get column width of a table.
      i can do it using ResultSetMetaData.getColumnDisplaySize(int i)
          but i don't know index of the column number but i know name of the column
                i mean to say is there method with name ResultSetMetaData.getColumnDisplaySize(String name)
  your help is appreciated

  thanx
  Shashi 



   ___________________________________________________________________________ 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 




------------------------------------------------------------------------------


  Checked by Hu-fw-scar

___________________________________________________________________________
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

Checked by Hu-fw-scar

___________________________________________________________________________
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