View Mode : display N or Y if a field is empty or not

Talk about any other operations you need to implement: additions, updates etc.

Moderator: alexandrleonenko

patrick23
Junior
Junior
Posts: 10
Joined: Aug 20th, '11, 07:00

View Mode : display N or Y if a field is empty or not

Postby patrick23 » Nov 27th, '11, 14:52

Hi

In View Mode, I would like to display a Y or N ( for instance) if a field is populated or not in the Database ...

Is it possible ?

thanks

Patrick

administrator
Site Admin
Site Admin
Posts: 6011
Joined: Jan 7th, '09, 23:18
Contact:

Re: View Mode : display N or Y if a field is empty or not

Postby administrator » Nov 28th, '11, 07:45

This is a basic SQL thing:

Code: Select all

SELECT...
IF(field = 1, 'Yes', 'No') as my_yes_no_field,
.........
.........


Return to “Additional operations implementation”