RE: differentiating between NULL and 0 - David Parker - com.mysql.lists.java

5 messages in com.mysql.lists.javaRE: differentiating between NULL and 0

From	Sent On	Attachments
Jeff Mathis	18 Dec 2002 15:50
Mark Matthews	18 Dec 2002 19:14
David Parker	18 Dec 2002 19:17
Christopher Taylor	18 Dec 2002 19:28
Jeff Mathis	19 Dec 2002 08:01

Subject:	RE: differentiating between NULL and 0
From:	David Parker (da...@rbii.com)
Date:	12/18/2002 07:17:43 PM
List:	com.mysql.lists.java

ResultSet.wasNull() "Reports whether the last column read had a value of SQL NULL". That might be what you are looking for....

- DAP

-----Original Message----- From: jmat...@predict.com [mailto:jmat...@predict.com] Sent: Wednesday, December 18, 2002 6:50 PM To: ja...@lists.mysql.com Subject: differentiating between NULL and 0

Hello,

I see from the documentation that calling one of the ResultSet.getFloat methods will return 0 if a column value has SQL NULL. I need to know the difference between a mull database filed, and an actual 0 in the field. Any suggestions?

thanks

jeff

To request this thread, e-mail <java...@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-dap=rbii...@lists.mysql.com>