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

  • 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

  • Quickbooks File Doctor 2018

    Amazing knowledge and I like to share this kind of information with my friends and hope they like it they why I do Quickbooks File Doctor 2018

  • soccer picks today

    Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!! soccer picks today

  • erectile dysfunction singapore

    As I website owner I think the subject material here is really fantastic, regards for your efforts.

  • training room singapore

    With havin so much content do you ever run into any issues of plagorism or copyright violation? My blog has a lot of completely unique content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my agreement. Do you know any solutions to help prevent content from being ripped off? I’d definitely appreciate it.

  • training room singapore

    With havin so much content do you ever run into any issues of plagorism or copyright violation? My blog has a lot of completely unique content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my agreement. Do you know any solutions to help prevent content from being ripped off? I’d definitely appreciate it.

  • training room singapore

    With havin so much content do you ever run into any issues of plagorism or copyright violation? My blog has a lot of completely unique content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my agreement. Do you know any solutions to help prevent content from being ripped off? I’d definitely appreciate it.

  • training room singapore

    With havin so much content do you ever run into any issues of plagorism or copyright violation? My blog has a lot of completely unique content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my agreement. Do you know any solutions to help prevent content from being ripped off? I’d definitely appreciate it.

  • best football predicton site of the year

    Nice blog and absolutely outstanding. You can do something much better but i still say this perfect.Keep trying for the best.

  • kuliah sambil kerja

    I’m curious to find out what blog platform you have been utilizing? I’m experiencing some minor security issues with my latest site and I’d like to find something more secure. Do you have any recommendations? kuliah sambil kerja

  • print lanyard in singapore

    Divorce Solicitor… [...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]… print lanyard in singapore

  • print lanyard in singapore

    Divorce Solicitor… [...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]… print lanyard in singapore

  • apprendre les média social

    You are so cool man, the post on your blogs are super great.”‘.’” apprendre les média social

  • apprendre les média social

    You are so cool man, the post on your blogs are super great.”‘.’” apprendre les média social

  • video conference room

    I have to admit that i sometimes get bored to read the whole thing but i think you can add some value. Bravo ! conference room video conferencing equipment

  • wedding photo retouching services

    You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! wedding photo retouching services

  • ShowBox apk

    You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! ShowBox apk

  • roof cleaners near me

    This website and I conceive this internet site is really informative ! Keep on putting up! roof cleaners near me

  • Technology Guide

    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 Technology Guide

  • https://damdaar.com/6-most-curable-cancers-in-the-world/

    These moles might be irregular in dimensions and coloration and that is what makes them such a wellness threat. If you have been born with this problem you could also be more probably to develop Melanoma and so you might need to get the needed precautions when it comes to guarding your skin and your health. https://damdaar.com/6-most-curable-cancers-in-the-world/

  • SEO companies in dubai

    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. SEO companies in dubai

  • Love Marriage Specialist Delhi

    http://www.topvashikaranspecialists.com/Love-Marriage-Specialist.html
    Every young person in the world is troubled by the problem of love marriage because today everyone wants to get married to a simple life is a crucial decision which is taken into consideration if you think without thinking in life, if the marriage is the result of it is very unnecessary because the most important work in life is marriage, which is concluded with great discretion in youth The Zeal people started showing a lot of inter-ceste in love marriage, which has to face many difficulties. Firstly, the marriage of the family is not approved for the sake of which there is a lot of trouble in your life which is very family-oriented in India. On the basis of traditions, the caste trusts the entire community in which the person wants to get married, the same caste Due to which marriage is endowed in India, social and excess is played, which makes people feel relieved.

  • Noida escorts

    http://www.jaskaur.in/noida-escorts.html

    http://blog.jaskaur.in/

    Loading performance is too fast and interesting. I saw some valuable articles you uploaded here. So thanks a lot.

  • clipping path company

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.. clipping path company

  • Zwembaden op maat

    Great ?V I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, web site theme . a tones way for your client to communicate. Excellent task.. Zwembaden op maat

  • Portrait Retouching

    Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!!

  • arabic majlis

    I would like to say that this blog really convinced me to do it! Thanks, very good post. arabic majlis

  • DewaQQ

    I think you have remarked some very interesting points , regards for the post. DewaQQ

  • Bilal Khan

    Phenomenal and supportive article.

    Accountants Hove

  • Bilal Khan

    Phenomenal and supportive article.

    Accountants Hove

  • Zwembad plaatsen prijs

    Wonderful blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you Zwembad plaatsen prijs

  • Wordpress webdesign

    I have learned some new elements from your web site about pcs. Another thing I have always imagined is that laptop computers have become a product that each family must have for several reasons. They supply you with convenient ways in which to organize homes, pay bills, go shopping, study, hear music and even watch television shows. An innovative strategy to complete many of these tasks is a laptop computer. These personal computers are portable ones, small, effective and lightweight. Wordpress webdesign

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • Wordpress webdesign says: I have learned some new elements from your web site about pcs. Another thing I have always imagined is that laptop computers have become a product that each family must have for several reasons. They supply you with convenient ways in which to organize homes, pay bills, go shopping, study, hear music and even watch television shows. An innovative strategy to complete many of these tasks is a laptop computer. These personal computers are portable ones, small, effective and lightweight. Wordpress webdesign

    1 hours ago
  • Zwembad plaatsen prijs says: Wonderful blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you Zwembad plaatsen prijs

    1 hours ago
  • Norton Technical Support Number says:
    Thank you so much for this post. It has the most informative step by step instructions I have read. You can contact at this number +18555583999 to avail the services provided by Norton technical support number

    13 hours ago
  • Bilal Khan says: Phenomenal and supportive article.

    Accountants Hove

    22 hours ago
  • Bilal Khan says: Phenomenal and supportive article.

    Accountants Hove

    22 hours ago
  • Norton Security Error 8504 says: Extremely decent blog on this site. It is extremely hard to get this sort of with valuable data. I am calmed I happened upon this site in the event that you have any issue with Norton then you call your Norton to bolster number +18555583999.

    Jul 14, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact