Read more links 1

[aaronjonmartin]

Ok this may be a bit of a newbie question but here goes anyway:

I have a field in a database which contains 5000 characters, I want to display a particular amount of these characters (say 100) in a template column of a datagrid. Then after them provide a link which when clicked loads a new page which displays the full amount of characters (a click to read more link). What would be the best way of displaying just 100 of the characters?

Thanks for any help in advance

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[ca8msm]

Just do it in the SQL e.g.

SELECT ID, SUBSTRING(FIELD1,1,100) AS SHORTDESC, FIELD1 AS LONGDESC FROM TABLE1

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[aaronjonmartin]

Ah hadnt thought of that, will give it a try thanks

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[aaronjonmartin]

worked a treat mate thankyou

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)