CODEWITHSUNDEEP
database
karthik
karthik

Reputation: 11

Should I add "ALL" value in a table to retrieve all its values?

I have a region table in which I store master region data like Europe, America. etc. Now, in the region drop down in the UI I want to add an option to select all regions. Should i add a new record "ALL" in the region table or should I add the "ALL" option only in the UI? Also in the JSP (UI) i retrieve the region from DB (EJB) and show the list in the JSP page.

Upvotes: 1

Views: 123

Answers (1)

Yuriy Faktorovich
Yuriy Faktorovich

Reputation: 68667

Add it in the UI, otherwise you're breaking your data model.

Upvotes: 6

Related Questions