How to write the database content is limited to 25 words

Use left (the field you want to read, 20) and you're good to go. 20 characters.

Data read from the database. substring(0,20)

Use a function that takes the length of the string, and I forgot the name of the function.

Do you show the title of the new rotten news in the list, which is a maximum of 20 words?

select news_content,left(news_title,20)

from news where news_category_name='Company Profile' order by news_id desc

More or less so, you can also write more complex, such as adding ellipses.

You didn't make it clear. Whether to control the gridview to display only a few individual fields in the database table or to control the number of words displayed in each cell (for example, I only want to make the product name display 3 words, and do not display or use more words.) Representation).

If it's the former, there are two ways:

1.Hide columns that don't need to be displayed in the property generator.

2.Control with ** (with select statement).

If it's the latter, it's more complicated. I also can't say how to control the number of words in a cell.

Control the number of words with select using the function method.

The data type of your database field is set too little.

Is there a limit to the length of characters that can be added to MySQL data inventory?

Hello, has it been solved, I also have this kind of problem.

These are the things you need to take into account when designing your fields. For example, text can be up to 255 bytes. The remarks can be very large, more than 60,000.

Press F1 on the Access page, and there is a detailed description of the data type in the Help, and set the data type according to the instructions.

You can change the file to a note.

"CSS controls the number of words.

Confidence.com uses CSS to control the number of words in the title of the article, and Confidence.com uses CSS to control the number of words in the title of the article.

Confidence.com uses CSS to control the number of words in the title of the article, and Confidence.com uses CSS to control the number of words in the title of the article.

Hypertext Markup Language, an application under the standard Universal Markup Language.

The structure of HyperText Markup Language consists of a "head" part (English: header) and a "body" part (English: body), where the "head" part provides information about the web page, and the "body" part provides the specific content of the web page.

You didn't make it clear. Whether to control the gridview to display only a few individual fields in the database table or to control the number of words displayed in each cell (for example, I only want to make the product name display 3 words, and do not display or use more words.) Representation).

If it's the former, there are two ways:

1.Hide columns that don't need to be displayed in the property generator.

2.Control with ** (with select statement).

If it's the latter, it's more complicated. I also can't say how to control the number of words in a cell.

Control the number of words with select using the function method.

You're going to get rid of the long lines in the format. len() will take ** or characters into account!