Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcalculated field expressionscalculated field expressions
Previous
 
Next
New Post
4/17/2010 7:10 PM
 

Hi;

I'm trying to generate a value based on whether a true/False field (call it 'Field') is true or false. I used the expression:

iif ([field]='True',1,2) but that always seems to generate a 2. The question therefore is , what value should i test for for a True/False field value?

Secondly. I see that some questions have been referred to documentation in the project page(s). Where do i find that?

Regards

Hans Hermans

 
New Post
5/10/2010 9:56 AM
 
Is it silly of me to suggest not capitalizing the word "True"? It'll be returned as "true," not "True," so if that's the code you're actually using then fixing that might do it.
 
New Post
5/18/2010 12:05 PM
 
thanks for the suggestion, but that does not do it.
 
New Post
5/18/2010 12:18 PM
 
Too simple, huh? Figures. Try adding _UDT_Original to the end of your field name. The value of the field itself might be "Yes" in which case it wouldn't match up. (When in doubt, view the data as XML and see if your information matches up with what you're expecting to find.)
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcalculated field expressionscalculated field expressions


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out