Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
button logic
Last Post 11-15-2012 05:34 AM by Ryan Bakerink. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Steve KUser is Offline
going with the flow
going with the flow
Posts:49
Avatar

--
10-30-2012 10:52 AM

    I am wondering if this is possible:

    I have a DV that will list events that a user has attended or is signed up to attend. For each record returned, I have an edit button that will load the event details in a DF for editing.

    One of the values returned in the query for the DV is EndDate. Is it possible to have the edit button be visible if today’s date is less than or equal to the end date, and to be invisible if today’s date is greater than the end date?

    If so, how would I go about doing this?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-30-2012 01:36 PM
    Hi Steve - I have seen this implemented a few times. I think you would either need to write some custom JavaScript to make this happen, or... I have seen where you can build within your query or stored procedure some SELECT CASE columns where the data would be brought in as a blank or the data would be brought in as the real edit link. Ryan might be able to explain this to you on your call with him on Thursday. Basically it is some IF/ELSE logic that would exist within your query directly. If you needed us to directly assist or help in writing the query too we can handle that via Premium Service hours which can be picked up at http://www.datasprings.com/hours.


    Thanks,

    Chad
    Steve KUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    11-13-2012 12:41 PM
    I did get this to work, and I want to thank Ryan for the assistance and the SQL syntax needed to accomplish this.

    It is accomplished by adding a column to your table/view/sp to return a url for the image of your delete button, as well as the parameters that are need to be passed to your dynamic form.

    Here is a modified version of the sql statement that adds a column named DeleteButton to my SQL view which I use to populate my DV View. 

    SELECT Any_Needed_Field_Names,
    CASE WHEN EndDate > GETDATE() THEN
    '<a href="http://www.your_domain_name.com/directory_path/
    Dnamic_Form_Name.aspx?DSParam1=' + CAST(FieldName* AS nvarchar(200)) + 'amp;DSParam2=Delete"></a>
    <img alt="">width="16" height="16" src="Path_to_Image_Folder/
    action_delete.gif">' END AS DeleteButton,
    Any_Additionly_Needed_Field_Names
    FROM TableName

    NOTE: The closing anchor tag should follow the close of the image tag! No matter what I tried, the forum software kept moving it to just behind the open anchor tag.

    *FieldName is the name of the field that contains the value you want to pass to your DSParam#
    EndDate is an existing field in my table
    Replace field names, table names as needed.

    Once this is completed you will have a new token called [deletebutton] that you can place in your list view or detail view templates. Now the delete button is only visible when the conditions are met.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    11-15-2012 05:34 AM
    Thank you for sharing your solution.

    Please let us know if you ever have any questions.

    -Ryan
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • 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