I have data coming in from a SQL table into 2 fields on a page. In one of those fields i want to display the actual data its getting from that SQL table for that field only if there are conditions not met. If the 2 conditions are met I want to display just a value that I specify.
EX....this is an active 911 calls site and the field im wanting this for is the complaint type field. For like a Domestic call i want that field to say LAW ENF instead of Domestic which is what would come form the SQL table. I have a field in my table called "call class" that i can say if call class="X" then do this and so on.....
I need something for ASP for this field that im showing for the complaint type on the page that will do this for me.