en-USzh-CNes-ESfr-FR
Search
You are here:Support  >  Articles
Articles
How to use SQLQueryTokens in DNNSmart.Script Manager module?

The main purpose of SQL Query Tokens is to read data from the database, and then use it as tokens in the script.

How to configure?

1, First of all, please input one sql query in the SQL Query of option settings page, you can click Preview Data button to review the query result. If the result is ok, please click Update button to save it.

Cache SQL Query Data: You can configure whether to cache data results, this can improve the performance of loading data in the front-end, without the module to re-read the data in the database every time.

Cache Expired Time: You can configure the cache time.




2. After you configure SQL, you can go to Edit Script page and use your tokens, please refer to screenshot below.




3. Please see screenshot below, the value of token is output in the console.



That’s all! Thanks for your reading. I believe that you would know how to use SQLQueryTokens in DNNSmart.ScriptManager module after reading this article. If you have any question, please send an email to us directly.


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

    Leave a comment

    2000 character(s) remaining. Comment limited to 2000 characters.
    Post Comment
    Search
    Categories
    Calendar
    Authors
    Archives
    Most
    • online quran says: Online Quran

      Sep 30, 2019
    • iwantcheats says: Iwantcheats

      Sep 30, 2019
    • Online Quran Academy says: Online Quran Academy

      Sep 30, 2019
    • Learn Quran Online says: Learn Quran Online

      Sep 30, 2019
    • bilal khan says: Stunning! This could be one unequivocal of the most productive regions We ave ever get together transversely over as for this issue. Genuinely Excellent. I am in addition an expert in this subject so I can comprehend your exertion.



      Walnoten

      Sep 29, 2019
    • macrame toran says: Thanks for this beautiful blog if you want to learn macrame arts then contact me any time

      Sep 28, 2019
    Home   |   DNNSmart Store   |   Free Downloads   |   Support   |   Service   |   About Us