Dede how to invoke company profile

Dedecms do business site template, the home will often add "about us" or "Company Profile" and the like text, in the column can be made into a "channel cover" or "single page."
But if you want to be able to invoke {dede:field.content/} content dynamically on the homepage, it is not possible to use a single label, because the home page is not a cover sheet. To implement this function, SQL statements are used to read the content fields in the table using SQL statements. As follows:
{dede:sql sql= "Select content from Dede_arctype where id=1"} [field:content/] {/dede:sql} Analysis: Content inside the SELECT content from Dede_arctype is the field that holds the cover content, id=1 refers to the ID of the field name to invoke, [field:content/] This is the underlying field.
If the profile is relatively long, you can limit the number of words: Method one:
{dede:sql sql= "select Content,substring (content,1,100) as content from Dede_arctype where id=7"}
[field:content/] ...
{/dede:sql} Method two:
{dede:sql sql= ' Select content from Dede_arctype where id=1 '}
[Field:content function= ' substr (@me, 0,500) '/]
{/dede:sql}