•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,703 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,208 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 4661 | Replies: 1
 |
•
•
Join Date: Oct 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
[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]
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]
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
- datagrid replacing null values (VB.NET)
- dynamic combo load problems (PHP)
- Exception Data is Null. This method or property cannot be called on Null values. (VB.NET)
- search (MS SQL)
- Need help diplaying null values (PHP)
- help with polymorphism and inheritance...getting null values (Java)
Other Threads in the MySQL Forum
- Previous Thread: Daily Auto MySQL Backup saved to directorty
- Next Thread: Foreign Keys
