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

  • 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

  • simulator truck

    very good post, i certainly enjoy this fabulous website, go on it simulator truck

  • website

    i always want a dining room that is brightly colored that is why i always paint our room with cream accent, website

  • Bilal Khan

    Particularly better than average post. I just uncovered your weblog and expected to express that I've really refreshing surfing around your blog sections. After all I'll be purchasing in to your feed and I trust you create again soon!

    Web Design Company New York

  • ahmed

    San Diego Web Design
    awsome blog loved ittt....

  • muneeb khatri

    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.. happy Independence day greetings

  • billu

    Especially superior to anything run of the mill post. I basically revealed your weblog and anticipated that would express that I've incredibly quickening surfing around your blog domains. After all I'll be acquiring in to your feed and I trust you make again soon!

    Spanish food restaurants near me

  • dewapoker

    Bless you for this particular facts I has been checking all Msn to be able to come across it! dewapoker

  • Nagapoker

    Thanks for the post, I liked its content and style. I discovered this web site on Google and also have right now added this in order to my personal book marks. I’ll be sure to visit again quickly. Nagapoker

  • borneo culture

    This website and I conceive this internet site is really informative ! Keep on putting up! borneo culture

  • Michigan Lasik Eye surgery

    i just love the ending part of your artical. best artical i ever read i understand very easily

  • Bilal Khan

    Especially superior to anything average post. I basically revealed your weblog and predicted that would express that I've incredibly vitalizing surfing around your blog domains. After all I'll be acquiring in to your feed and I trust you make again soon!

    seo company in bangladesh

  • Work Injuries Houston

    ehternet cables are still the ones that i use for my home networking applications“ Work Injuries Houston

  • MWD computer

    Hello! I wish to provide a large thumbs up for the fantastic info you have here within this post. I will be coming back to your site for additional soon. MWD computer

  • Work Injuries Houston

    ehternet cables are still the ones that i use for my home networking applications“ Work Injuries Houston

  • Holidays to Marrakech

    I seemed to be aware about this kind of currently, nevertheless there was clearly numerous helpful pieces that completed the image personally, thank you so much! Holidays to Marrakech

  • Dinh Cu EB5

    A very informationrmative article and lots of really honest and forthright comments made! This certainly got me thinking about this issue, cheers all. Dinh Cu EB5

  • articlefu

    Article Fun is a rapidly growing platform who strive relentlessly to provide par excellence quality content of various verticals like fashion, health and fitness, Business, relationship, lifestyle, beauty, and travel to our users. articlefun

  • movers and packers Dubai Abu Dhabi

    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.. movers and packers Dubai Abu Dhabi

  • Serrurier

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

  • best budget gaming keyboards

    This is a great post. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this again. best budget gaming keyboards

  • Dil Hi Toh Hai

    I have read your excellent post. This is a great job. I have enjoyed reading your post first time. I want to say thanks for this post. Thank you... Dil Hi Toh Hai

  • Malwarebytes for Mac

    I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post. Malwarebytes for Mac

  • muneeb khatri

    Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!.Rawalpindi Intermediate Result 2018

  • bridal hair hairpin

    I need to appreciate this extremely good read!! I certainly loved every little bit of it. I have you bookmarked your site to check out the fresh stuff you post. bridal hair hairpin

  • burri60

    You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming.
    Warmtepomp werking

  • top mechanical keyboard

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

  • San Diego employment lawyer

    Always so interesting to visit your site.What a great info, thank you for sharing. this will help me so much in my learning San Diego employment lawyer

  • movie123

    I am impressed by the information that you have on this blog. It shows how well you understand this subject. movie123

  • McDonald’s Customer Satisfaction Survey

    We are tied directly into the sate’s renewal database which allows us to process your request almost instantly. McDonald’s Customer Satisfaction Survey

Leave a comment

2000 character(s) remaining. Comment limited to 2000 characters.
Post Comment
Support
Search
Calendar
Categories
Archives
Most
  • watch nfl online says: 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. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. watch nfl online

    12 hours ago
  • McDonald’s Customer Satisfaction Survey says: We are tied directly into the sate’s renewal database which allows us to process your request almost instantly. McDonald’s Customer Satisfaction Survey

    Aug 15, 2018
  • movie123 says: I am impressed by the information that you have on this blog. It shows how well you understand this subject. movie123

    Aug 13, 2018
  • San Diego employment lawyer says: Always so interesting to visit your site.What a great info, thank you for sharing. this will help me so much in my learning San Diego employment lawyer

    Aug 13, 2018
  • Young says: Android TV is an unique os created by Android TV Box Google that's different from (yet based on) Get brand new Android TV Box the very same code as its Android Best Android TV Box mobile OS that's frequently found on smartphones. Contently Where regular Android is official source developed for touchscreens.

    Aug 13, 2018
  • top mechanical keyboard says: Nice blog and absolutely outstanding. You can do something much better but i still say this perfect.Keep trying for the best. top mechanical keyboard

    Aug 12, 2018
Home   |   EffectCollection   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service
Quick Contact