LIMIT string length : "something like this......"

[hpadwal]

Hello all,

Surprised i couldnt f8ind the answer on google but i need to limit the length of a string retrieved from database.

can you help?

"something like this......"

Thanks you

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

- Doh

http://www.my-portfolio.me.uk

 

[hpadwal]

Found it..

use

<%=LEFT(rsDirt("shortteaser"), 60)%>...

around your recordset

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

- Doh

http://www.my-portfolio.me.uk

 

[ChrisHirst]

thread333-882989

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[DreXor]

also in the <A> tag you can use TITLE="full length string" so that on mouse over they can see the entirety of the text or a longer snippet like left(data,200).

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
" I always think outside the 'box', because I'm never inside the 'loop' " - DreX 2005