Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Another Question about datetime

 
Anurag Saxena
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi:
I am using-
resultSet.getXXX("columnName");
if coulmn is of type 'datetime', 'nvarchar' or 'numeric' what
corrosponding getXXX() methods should I use?
My database is in MS SQL server.
Also, When I am doing these statements seperately
it works by when running together it gives an error: Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
here what I am doing:
tr.tranDate = rs.getDate("TR_DATE");
tr.chipTranId = rs.getInt("CHIPTRAN_ID");
Thanks for the help.
[ November 14, 2002: Message edited by: Anurag Saxena ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic