aspose file tools*
The moose likes JDBC and the fly likes Null Values Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Null Values" Watch "Null Values" New topic
Author

Null Values

Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
Hello,

This piece of code is not working with NULL values. there are some categories in db that have no specialty but this code showing them not null and displaying the previous record values for null records



Full code:


OUTPUT:
======

Thanks & best regards
Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
Hello,

Can you please help me?

Best regards
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
If I were you I would re-write my queries as one sql using right join.
Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
Fatih Keles wrote:If I were you I would re-write my queries as one sql using right join.


Thanks for your reply

I split queries as I have to use this data to populate combo boxes. Can you please get me some query example as to how can I proceed?

Best regards
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
May be something like this

Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
Thanks for your reply
 
Don't get me started about those stupid light bulbs.
 
subject: Null Values