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
"pre-sales" question
Last Post 01-23-2008 07:59 AM by Chad Nash. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Tom LyczkoUser is Offline
wading in the water
wading in the water
Posts:26
Avatar

--
01-22-2008 02:18 PM

    Maybe others would be interested too??

    Where and how does Dynamic Forms store data, if one does not specify a UDT (user-defined table), and how does one view the stored data??

    Thank you, Tom
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-23-2008 07:59 AM
    Tom,

    Hi. Dynamic Forms stores data in relational tables (specifically DynamicForms_QuestionResponse table). This table includes foreign keys such as the DynamicQuestionID and stores other important information such as the data time of the response and most important (to query against and if you build a view against the table the UniqueResponseID) so that for each form that is submitted there is a uniquecompletionID that is kept.

    So... All of that being said you could store the data in any table you wanted to. Dynamic Forms includes a feature called Dynamic SQL Events and like other completion events you can fire these for any form submission or based on a user response to a field (or can also setup as few or as many completion events as you would like). So, with a SQL Event you could actually insert or update any table... You have access to all field tokens within the email so if you had a table called 'MyCustomTable' with three fields in it you could have something like this:

    Insert Into MyCustomTable(FirstName, LastName, EmailAddress) Values('$(FNameField)', '$(LNameField)', '$(EmailField)')

    This is assuming the shortfield name for your fields on the form is FNameField, LNameField, and EmailField.

    Hope this helps!

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