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 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.
Tags: Categories:
about author

DNNSmart

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

    Leave a comment

    2000 character(s) remaining. Comment limited to 2000 characters.
    Post Comment
    Search
    Categories
    Calendar
    Authors
    Archives
    Home   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service   |   About Us   |   Membership