January 29, 2003 at 9:08 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy