Display of different results from same table
I have three tables Manufacturer,Model and Variant where Model references Manufacturer and Variant references Model. The scenario is, I have two pages namely: newCars.jsp and usedCars.jsp. Both the pages use the above tables to display data in them.
Now a real life situation may arise where some model or variant of some manufacturer is out of market in which case i do not want to display that model or variant in my newCars page. whereas i always want all the models and variants to be displayed in the usedCars page. How can i solve this problem as both the pages use the same tables to display their data. I would appreciate any help in this.
Welcome to DevX
Wouldn't this be a matter of how you query your database tables?
How do you display the information now?
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
By ani.since1982 in forum ASP.NET
Last Post: 01-26-2008, 09:46 AM
By runy in forum VB Classic
Last Post: 04-24-2007, 10:37 AM
By Muhammad Waqas in forum VB Classic
Last Post: 12-18-2005, 08:28 PM
By qwasted in forum VB Classic
Last Post: 08-25-2002, 09:50 PM
By WooGor in forum ASP.NET
Last Post: 03-15-2002, 02:37 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center