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.
jjerryjenson
0
Newbie Poster
Recommended Answers
Jump to PostSELECT * FROM table WHERE column IS NULL
All 3 Replies
sn4rf3r
0
Junior Poster
SELECT * FROM table WHERE column IS NULL
jabeen1
0
Newbie Poster
Great one and its solved my problem
marck_don
0
Light Poster
Use the COALESCE function:
COALESCE(Email, 'no email')
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.