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

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 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.

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,

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.

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

Checkbox question-type not mapping results in SQL Completion Event
Last Post 05-16-2011 05:33 PM by bcorngtr. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bcorngtrUser is Offline
wading in the water
wading in the water
Posts:18
Avatar

--
05-12-2011 07:09 AM
    I have a DR module that includes a checkbox question.  I have a Dynamic SQL completion event that runs upon registration that calls a stored procedure to insert a record with some of the registration information (need to use table outside of DR for this particular info).  I am mapping the checkbox question via the proper shortfield name, but even when the checkbox is checked, the result is an empty string rather than 'Yes' as I know should be the case based upon the way  DF Dynamic SQL completion events work and other posts to this forum for older versions of DR.  I am running DR Version 4.1.13.26621 on DNN 5.6.

    Any ideas!

    Thanks!
    Brian
    bcorngtrUser is Offline
    wading in the water
    wading in the water
    Posts:18
    Avatar

    --
    05-15-2011 05:03 AM

    Any ideas on this issue?  I have triple checked my settings and cannot see anything out of whack.  I know that I am passing the correct field/question to the SQL Completion Event, so that is definitely not the issue.

    Thanks!

    Brian

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    05-15-2011 05:19 PM
    Hi Brian,

    A couple of questions...
    1. Can you enable Debug Mode on the registration form to see the exact query that is being rendered?
    2. Does it make a difference if the field is mapped or not mapped to a DNN Core profile field?
    3. How does the $(Token) appear within an email event? The same blank or actually has a value?


    Thanks,

    Chad
    bcorngtrUser is Offline
    wading in the water
    wading in the water
    Posts:18
    Avatar

    --
    05-16-2011 05:33 PM
    Chad,

    1. Yes, I have done this and the result for this checkbox question is an empty string.

    2. Just for grins, I created a DNN property (using Quick Create Property) and set the field to this new property.  I also allowed the value to be saved to the database.  Unfortunately, I get the same result - no value whether the box is checked or not.

    3. The token acts the same whether in an email or the SQL event.  There is no value for the question/field whether the box is checked or not.

    I'm at a loss here...

    Thanks!
    Brian
    You are not authorized to post a reply.


     
     

    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