Java Web Application Query Is Not Working [duplicate]

Question

My program of java is connected to a database which has tables Asset_11398 and Emp_11398.. both are connected through a relationship..

i want to write a query which will should show the Assets which are not allocated to employees.. means it should only show the fields where the 'Emp_ID' field is empty.. i have been trying to run it using the query below but i know there is something wrong with it.. can someone please take a look at the query?

ResultSet resultset = statement.executeQuery("select * from Asset_11398 Where Emp_ID = null");

Khate · Accepted Answer · 2015-06-09 07:46:32Z

0

Have you try something like this:

ResultSet resultset = statement.executeQuery("select * from Asset_11398 Where Emp_ID is NULL");

edited Jun 9, 2015 at 7:46

answered Jun 8, 2015 at 17:37

Khate

3692 gold badges3 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nia_925 Over a year ago

no.. it isnt working..

Khate Over a year ago

I have updated the code block. It should work. Just note that when query a Null col|row, there should use "is" not "="

Collectives™ on Stack Overflow

Java Web Application Query Is Not Working [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related