var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: using views
Is there a way inside the design of the view that I can use an if statement to say if the results of a field are t set to Y, if f set to N (not permanently though, just for the recordset)
I don't know if this is the best way to do it but I would probably use a union query and do something like....
select x, y, 'Y' as 'z' from my table where myfield = 't'
select x, y, 'N' as 'z' from my table where myfield = 'f'
this should work, but I don't know if it's the best method as I don't use views much.
Here are three ways to skin that cat. No doubt other people will think up more:
case field when 't' then 'Y' when 'f' then 'N' else 'U' end
replace(replace(field, 't', 'Y'), 'f', 'N')
isnull(nullif(isnull(Nullif(field, 't'), 'Y'), 'f'), 'N')
what about if the field is blank? how can i set that equal to N?
case field when 't' then 'Y' else 'N' end
replace(replace(isnull(field, 'N'), 't', 'Y'), 'f', 'N')
isnull(nullif(isnull(Nullif(field, 'f'), 'N'), 't'), 'Y')