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 Forms
How to include the returned value from a SQL event in an email event
Last Post 10-01-2012 12:27 PM by AF. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
AFUser is Offline
going with the flow
going with the flow
Posts:49
Avatar

--
09-09-2012 03:28 PM
    We have the latest version of DF running on DNN 6.2.0.  On snowcovered it says that in version 4.1 we can include the return value of a SQL event in an email event.

    This is exactly what we need but we see no way to do it and the documentation for Dynamic Forms is still at 3.4?  Also there doesn't appear to be a demo page available to illustrate how to implement this functionality. 

    Please advise ... how do we do this?
    -----------------------------
    www.amazingfacts.org
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    09-10-2012 09:21 AM
    Hello - Yes, this feature has been added... We are working on getting the updated user guide posted (should be this week if possible).

    This was taken from the draft user guide for instructions on what you are discussing here:

    To reference SQL Event Responses within other events such as email, SQL, and other HTTP Form Post events:

    Tip: You can reference the response from SQL events within other email events, http post events, and SQL events. This allows you to (based on the sort order of the event) capture the response returned from the SQL query. To do this you need to reference the event name within the token. The format is $(SQLResponse_EventName).

    To reference HTTP Form Post Responses within other events such as email, SQL, and other HTTP Form Post events:

    Tip: You can reference the response from HTTP Post events within other email events, http post events, and SQL events. This allows you to (based on the sort order of the event) capture the response returned from the HTTP Form Post. To do this you need to reference the event name within the token. The format is $(PostedResponse_EventName).


    Thanks,

    Chad
    AFUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    09-11-2012 02:18 PM
    Chad thanks for the tip,

    Gave this a try but did not work.  I made the column name of the return value in the sql statement be DefaultValue ... does that matter?

    The token is being referenced in the email like so:

    $(SQLResponse_GetTheID)

    Is this correct?  GetTheID being representative of the name of the sql event ... when the email goes out that value is showing just as it is entered '$(SQLResponse_GetTheID)' instead of the actual value.

    Is there a step that I'm missing?
    -----------------------------
    www.amazingfacts.org
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    09-12-2012 09:58 AM
    Hi - Yes, I just checked the code again and it should be doing this.

    Does the sort order on the SQL Event have a lower number then the sort order on the email event?

    So...
    1. The sort order on the SQL Event has a lower number then the email event
    AND
    2. The SQL Event itself has the exact name "GetTheID"?
    AND
    3. You are running on the 4.1 release of Dynamic Forms?

    Thanks,

    Chad
    AFUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    09-12-2012 10:36 AM
    Hi Chad to answer your questions:

    - Yes the sort order on the sql event is 2, the sort order on the email event is 4 (there is no event between them ... I kept a gap in the ordering in case another event needs to be inserted at a later time)

    - Yes the name of the sql event matches the name placed in the token $(SQLResponse_GetThelID)

    - Yes we're running Dynamic Forms 4.10.4

    Does the ordering of the events need to be consecutive? Should the order on the email event be 3?

    -----------------------------
    www.amazingfacts.org
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    09-13-2012 01:46 PM
    Ok - A quick follow up here. We will need to get a patch out related to this. I was able to duplicate the problem this afternoon and after reviewing the code more and more I found that it was only doing this if the EmailTO field had this token and not the Email Message (Whooops ). We implemented some of these checks recently to improve performance in not handling the the replace statement unless the token was present but... obviously the token is not going to be present in the EmailTO field

    So... This will be available in the next patch or hot fix as 04.10.50 and I have just verified that this fix is working properly within our development environment. Thank you for bringing this to my attention.


    Thanks,

    Chad
    AFUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    09-13-2012 02:10 PM
    No problem ... thanks so much for the quick turn-around! We'll be eagerly awaiting the patch ...
    -----------------------------
    www.amazingfacts.org
    AFUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    10-01-2012 10:57 AM
    Hi Chad,

    I'm wondering if there is an ETA on this patch? We're planning a launch of the redesign of our main website in a week or two and would like to be able to include this functionality ...
    -----------------------------
    www.amazingfacts.org
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-01-2012 11:33 AM
    Hi - there is no official launch of the patch but if you open a support ticket and reference this thread I should be able to get you a copy of the patch before its official release.

    Thanks,

    Chad
    AFUser is Offline
    going with the flow
    going with the flow
    Posts:49
    Avatar

    --
    10-01-2012 12:27 PM
    Ok will do ... thanks so much ...
    -----------------------------
    www.amazingfacts.org
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    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