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 (68)

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

  • Restore old photos online

    I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post.

  • Mac and Cheese Day

    When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your.

  • snow ski apartments falls creek

    You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject! snow ski apartments falls creek

  • Price today Graco 4Ever 4-in-1 Convertible Car Seat

    When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. Price today Graco 4Ever 4-in-1 Convertible Car Seat

  • private label manufacturers

    When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. private label manufacturers

  • facebook

    Blasphemy! : ) Simply kidding. Ive go through related points upon various other weblogs. Sick acquire your term for this. Continue to be sound! the companion. facebook

  • Where to Buy PhenQ

    This is also a very good post which I really enjoyed reading. It is not every day that I have the possibility to see something like this.. Where to Buy PhenQ

  • web marketing services

    Thanks a lot for providing individuals with an exceptionally wonderful opportunity to read in detail from this website. It’s always so pleasurable and full of a good time for me personally and my office colleagues to search the blog particularly thrice weekly to study the new items you will have. And of course, we’re at all times pleased with your stunning tactics you give. Selected two areas in this article are undeniably the most efficient we have ever had. web marketing services

  • Los Angeles Printing Experts

    Have you tried twitterfeed on your blog, i think it would be cool.,”.*; Los Angeles Printing Experts

  • autoblog wordpress website

    i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me. autoblog wordpress website

  • بهترین وکیل ملکی

    i do not like trailer homes because it is not sturdy enough specially when the weather goes bad~ بهترین وکیل ملکی

  • Little Singham Videos

    Comfortabl y, the post is really the freshest on that deserving topic. I harmonise with your conclusions and definitely will thirstily look forward to your next updates. Simply saying thanks will not simply just be adequate, for the extraordinary clarity in your writing. I will directly grab your rss feed to stay informed of any updates. Gratifying work and much success in your business dealings! Little Singham Videos

  • Little Singham Videos

    Comfortabl y, the post is really the freshest on that deserving topic. I harmonise with your conclusions and definitely will thirstily look forward to your next updates. Simply saying thanks will not simply just be adequate, for the extraordinary clarity in your writing. I will directly grab your rss feed to stay informed of any updates. Gratifying work and much success in your business dealings! Little Singham Videos

  • best mattress protector

    i would be busy again doing some home decors this coming christmas, i’d be buying some new decors for the season“ best mattress protector

  • 메이저사이트

    we can always give food aid to the african countries if we just save some pennies and donate it to them~ 메이저사이트

  • www.spartagenxtforsale.com

    Spartagen XT is an advanced testosterone booster that is designed to help improve* male potency. It is claimed to feature organic and herbal compounds that boost* testosterone levels. CLICK HERE www.spartagenxtforsale.com

  • wholesale distributors

    Looking for wholesale distributors? Visit my blog wholesale distributors

  • customized patches

    Our custom patches are perfect for uniforms, duffle bags, jackets or any other use.

  • Review Of Roblox Game

    There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job.. Review Of Roblox Game

  • visit site

    Writing with style and getting good compliments on the article is quite hard, to be honest.But you've done it so calmly and with so cool feeling and you've nailed the job. This article is possessed with style and I am giving good compliment. Best! visit site

  • FNaF World Update 3 Download

    Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. FNaF World Update 3 Download

  • judi online terpercaya

    Real fantastic info can be found on weblog .

  • Lonat

    It's incredible due to the fact that mustache trimmer really quick shaving, and also a number of choices. How does the beard trimmer work shave in similar means Hoover provided for vacuum, Most Popular Beard Trimmers to work around the shapes of the chin, neck and also face, puzl four rounded heads that move in Know More Exactly what's even more, a dual-sided trimmer.

  • prediciton site

    There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job.. prediciton site

  • eid al adha wishes

    There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job.. eid al adha wishes

  • maid service

    You produced some decent points there. I looked online to the issue and discovered most people is going in addition to using your site. maid service

  • Gevelwerk

    I’d ought to talk to you here. Which is not some thing It’s my job to do! I love to reading a post that may make people believe. Also, thanks for allowing me to comment! Gevelwerk

  • Zwembad polypropyleen

    when i cook at home, i always make sure that i only cook healthy recipes because i don’t want to get fat,. Zwembad polypropyleen

  • แทงบอล

    Whoa that guideline is astonishing it truly helped me and my family, thanks a lot! แทงบอล

  • blog biznesowy

    You completed some fine points there. I did a search on the matter and found most persons will consent with your blog. blog biznesowy

  • freesamples

    you can get free samples of many types of products.

  • professional search optimization company

    it is a company that works to improve your web presence or digital reach using organic search as a basis.read more

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • Fertility Hospital says: This is comprehensive and helpful blog post. Thank you very much!

    13 hours ago
  • Women's hospital says: I really love to visit to your blogging site because I want more to increase my knowledge.

    15 hours ago
  • professional search optimization company says: it is a company that works to improve your web presence or digital reach using organic search as a basis.read more

    Jun 14, 2018
  • freesamples says: you can get free samples of many types of products.

    Jun 14, 2018
  • blog biznesowy says: You completed some fine points there. I did a search on the matter and found most persons will consent with your blog. blog biznesowy

    Jun 13, 2018
  • แทงบอล says: Whoa that guideline is astonishing it truly helped me and my family, thanks a lot! แทงบอล

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