Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
How to do Condition on template?
Last Post 10-10-2012 09:21 AM by Ryan Bakerink. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Michael ManUser is Offline
river guide
river guide
Posts:152
Avatar

--
10-10-2012 07:13 AM
    I looked through 19 pages of this forum and found none thread relating to this issue. So here is my issue

    How do I do condition IF - Then on the template?

    For example I have a column name [Approve], how do I display on the template like this

    IF [Approve] is "1" Then Display "One"

    Else

    Display "Two"

    Can anyone help? Thanks
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    10-10-2012 09:21 AM
    Hello Michael,

    I would use a Case Statement. So you'll need to use Custom SQL as the Data source for your Dynamic View.

    This is the Case Statement Syntax:

    Select
    (Case when [Approve] = 1 THEN 'One' ELSE 'Two' END) As IsApproved, *
    from YOURTABLE

    Let me know if you have any questions.

    Thanks,

    Ryan

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi