how to select null values in condition

Reply

Join Date: Oct 2006
Posts: 1
Reputation: jjerryjenson is an unknown quantity at this point 
Solved Threads: 0
jjerryjenson jjerryjenson is offline Offline
Newbie Poster

how to select null values in condition

 
0
  #1
Oct 19th, 2006
[HTML]
i am having four combo boxes.the item in the combo box is taken from the database.we select the data whatever we want and clicking the submit button report want to be displayed.
While selection in the combo boxes, they may select all the fields sometimes they may select one fields and so on.i want to display records according to the selection.to display records i am using jasper i-report.
front end: JSP back end : My SQL
The problem is in the i-report i can write only one query, i cannot check condition sometimes some field may empty or null.

please send me the query so that i can check null values(ie. if the field is null it want to select all the data regarding that field) and select regarding the data.

[/HTML]
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 133
Reputation: sn4rf3r is an unknown quantity at this point 
Solved Threads: 2
sn4rf3r's Avatar
sn4rf3r sn4rf3r is offline Offline
Junior Poster

Re: how to select null values in condition

 
0
  #2
Oct 19th, 2006
  1. SELECT * FROM table WHERE COLUMN IS NULL
Last edited by sn4rf3r; Oct 19th, 2006 at 11:12 am.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC