Post reply

Selecting only Certain text from database.

  • January 29, 2003 at 9:08 am

    #80626

    Hey guys and gals, i have a question here. I don't know if this can be done but its worth a shot. In my sql 2000 database i have a field with text that is like 500 to 8000 characters long.

    Well what i want to do is only show like a summary of the text. Not the entire sentence but just a summary, but when you click on the story link it will take you to the full story. I hope i explained it correctly. Example:

    Story: Link here

    Summary of story here: blah blah blah

    blah blah blah (not entire text in database)

    Can this be done?

    Thanks.

  • January 29, 2003 at 2:32 pm

    #447529

    If never more than 8000 characters, instead of using a text column use VARCHAR if an option. Might mean makin a table just for the text and tie with PK value. Then you can use LEFT(colname,length).

    Otherwise on the SQL side you use READTEXT method. I have not tried anything like this as of yet.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply