Items: 0 Total: $0
en-USzh-CN
Search
You are here:Support  >  Articles
Articles

For this article, it will teach you how to use Execute SQL feature. Execute SQL feature allows you inserting values of form fields into your custom data tables.

For this article, it will teach you how to use Execute SQL feature. Execute SQL feature allows you inserting values of form fields into your custom data tables.

 

For example, you have three fields “Name”, “Email” and “Comment” in your form. And you also have one FormTable which includes Name, Email, Comment these three fields. You want information submitted by users added into Formtable.


Configuration Steps

1. First of all, please enter Management Center -> Module Settings page and check option “Execute SQL”.


2. You need to write SQL script in SQL Script. In Sql script, you can include Tokens on the right of Textbox. These tokens represent form fields. In this example, we write following sql script.

insert into FormTable

(Name,Email,Comment)

values('[Step1Content1]','[Step1Content2]','[Step1Content3]')




3. In this way, data of form will be inserted into FormTable after users clicking submit button.
about author

Joshua Bright

Developer

Although DNNSmart was newly founded in August 2012, we devoted to DNN development work since 2008. We specializes on the DotNetNuke (DNN) Content Management System including DNN skin design, DNN programming and website construction. Our development team is located in China, our professional and outstanding developers are passionate about web design, programming and web applications.

Comments (5)

  • charles dom

    For this article, it will teach you how to use Execute SQL feature. Execute SQL feature allows you inserting values of form fields into your custom data tables http://www.citeulike.org/user/tempos/article/14386495

    • charles dom

      For this article, it will teach you how to use Execute SQL feature. Execute SQL feature allows you inserting values of form fields into your custom data tables here

  • john mike

    Indeed, I have designed it with time limitations by choosing the time when the Internet access ought to be blocked however it doesn't work unless I put the gadgets in the Block List. Which implies I need to physically Block and Unblock the gadgets regular.
    https://www.doneassignment.co.uk/write-my-assignment.php

  • Benefits of Cucumber

    Great content material and great layout. Your website deserves all of the positive feedback it’s been getting.

  • Questions to Ask a Guy

    I really impressed after read this because of some quality work and informative thoughts . I just wanna say thanks for the writer and wish you all the best for coming!. Questions to Ask a Guy

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • Questions to Ask a Guy says: I really impressed after read this because of some quality work and informative thoughts . I just wanna say thanks for the writer and wish you all the best for coming!. Questions to Ask a Guy

    Jan 14, 2018
  • Questions to Ask a Guy says: I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. Questions to Ask a Guy

    Jan 14, 2018
  • Questions to Ask a Guy says: Good website! I truly love how it is easy on my eyes it is. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your RSS which may do the trick? Have a great day! Questions to Ask a Guy

    Jan 14, 2018
  • Benefits of Cucumber says: Great content material and great layout. Your website deserves all of the positive feedback it’s been getting.

    Jan 13, 2018
  • Benefits of Cucumber says: I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. Benefits of Cucumber

    Jan 13, 2018
  • Benefits of Cucumber says: I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. Benefits of Cucumber

    Jan 13, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact