Items: 0 Total: $0
en-USzh-CNes-ES
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 (36)

  • 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

  • scooter insurance

    I read that Post and got it fine and informative. scooter insurance

    • hac

      Awesome post I might want to thank you for the endeavors you have made in composing this intriguing and educated article. Manhattan Capital Inc

    • hac

      Awesome post I might want to thank you for the endeavors you have made in composing this intriguing and educated article. Manhattan Capital Inc

  • Robinjack

    You really know how to express your thoughts in the written word. This article is dead on accurate in my opinion. I agree with your viewpoints. I hope many readers get to see this material. stand building agencies in Dubai

  • voyance gratuite

    I have bookmarked your blog, the articles are way better than other similar blogs.. thanks for a great blog! voyance gratuite

  • Tier 2 Links

    This is very interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your great post. Also, I have shared your site in my social networks! Tier 2 Links

  • Internet Services

    Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work! Internet Services

  • assignment writing

    Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. assignment writing

  • Cronin

    Both ways entail a different web page at binance including the well-known Binance.com Exchange Login the Advanced sight listed below There are not many distinctions.

  • best under water cameras 2018

    I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.I must admit that your post is really interesting. I have spent a lot of my spare time reading your content. Thank you a lot! best under water cameras 2018

  • igitize embroidery

    This is a good post. This post gives truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. Thank you so much. Keep up the good works digitize embroidery

  • badminton rackets

    The worst part of it was that the software only worked intermittently and the data was not accurate. You obviously canot confront anyone about what you have discovered if the information is not right. badminton rackets

  • motorcycle patches

    This is a good post. This post gives truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. Thank you so much. Keep up the good works motorcycle patches

  • Watch Hate Story 4 Online

    If it's not too much trouble share more like that. Watch Hate Story 4 Online

  • Best wireless gaming keyboard

    I feel a lot more people need to read this, very good info! . Best wireless gaming keyboard

  • photo clipping path

    Hi there, I found your blog via Google while searching for such kinda informative post and your post looks very interesting for me photo clipping path

  • best slim car seat

    I surely acquiring more difficulties from each surprisingly more little bit of it best slim car seat

  • putlocker

    This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck putlocker.

  • Quick Shopping Cart

    It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing. Quick Shopping Cart

  • CE motorcycles jackets

    If it's not too much trouble share more like that. CE motorcycles jackets

  • more info

    Thank a lot. You have done excellent job. I enjoyed your blog . Nice efforts more info

  • paringknifeguide.com

    Hey, great blog, but I don’t understand how to add your site in my rss reader. Can you Help me please? paringknifeguide.com

  • ibdar bank bahrain

    Much thanks for composing such an intriguing article on this point. This has truly made me think and I plan to peruse more ibdar bank bahrain

  • Chat room

    I must admit that your post is really interesting. I have spent a lot of my spare time reading your content. Thank you a lot! Chat room

  • Comedy Shows in India

    This was incredibly an exquisite implementation of your ideas Comedy Shows in India

  • mother day letter from husband to wife

    This article gives the light in which we can observe the reality. This is very nice one and gives indepth information. Thanks for this nice article. mother day letter from husband to wife

  • carpet installation Minneapolis

    This article gives the light in which we can observe the reality. This is very nice one and gives indepth information. Thanks for this nice article. carpet installation Minneapolis

  • email template

    Thanks for providing recent updates regarding the concern, I look forward to read more.

  • Ramadan Calendar 201

    I curious more interest in some of them hope you will give more information on this topics in your next articles. Ramadan Calendar 2018

  • Happy Mothers Day 2018

    A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • cheap desert safari says: very nice post, i certainly love this website, keep on it cheap desert safari

    13 hours ago
  • Happy Mothers Day 2018 says: A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.

    Apr 24, 2018
  • Ramadan Calendar 201 says: I curious more interest in some of them hope you will give more information on this topics in your next articles. Ramadan Calendar 2018

    Apr 24, 2018
  • baby crib says: Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging,

    Apr 22, 2018
  • email template says: Thanks for providing recent updates regarding the concern, I look forward to read more.

    Apr 22, 2018
  • Rosenhain says: Enter your Activation username and password. parentpaylogin.com saved in any kind of component of the system.

    Apr 20, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact