Re: A JDBC problem!

[Panayotou, Michael]

Could you send the java code ?

-----Original Message-----
From: Cutty [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 9:26 AM
To: [EMAIL PROTECTED]
Subject: A JDBC problem!

Hi:

 

   I have a problem with JSP programming on JDBC ,it is a little bit complex ,but I'll try to make myself clear.

 

   I have a table in my database named hcds ,its structure is as follow:

.

.

........

Family	ModelNo	PartNumber	SerialNo	Customer	DateofShipment	DateofPurchase
HB13L	KDD2200	B33400TW	1096706	STD	2001-9-19	2001-10-18
HB13L	KDD2200	B33400TW	1096796	STD	2001-9-19	2001-10-18
HB13L	KDD2200	B131	NH11T195F8HW	NKO	2001-10-11	2001-10-21
HB13L	KDD2200	B131	NH10T1A15FV0	NKO	2001-10-26	2001-10-26

........ .

.

.

 

  There are 500 lines in the table.I use getString() to obtain the data from it.

  The problem is , the getString("SerialNo")  returns null on the line where the SerialNo change from a pure  numeral format(1096796) to a mixed format (NH11T195F8HW).but it works well if the SerialNo is in a single format.

  When I picked up four line as showed above to test ,same thing happened. but if I delete first line(whose SerialNo was 1096706) or add some English characters in its SeroalNo colum , the problem did NOT happen;

  I am so confused and can not solve it.

  I really appreciate if anybody can help me out of that.

 

Cutty

[EMAIL PROTECTED]

[EMAIL PROTECTED]