Question: Render images with true / false values

I have a database with about 4,000,000 records. I want to use this TableJX to display portions of the records.

Many of the records are stored as True / False values. Instead of outputting the text 'True' or 'False,' I want to output a green check box and a red X.

How can I accomplish this without putting the full HTML IMG tag in the database fields? I don't want to do that for 4,000,000 records.

If the answer is "it can't be done without modifying the code," where is the backend code we have to modify?

Hi,

you can create view, something like this:

CREATE VIEW YourView AS
SELECT 
(case 
(when flag = True) then '<img src="pic1.gif" alt="P1" />'
(when flag = False) then '<img src="pic2.gif" alt="P2" />'
end) As Pic
FROM YourTable