hi, i would like to know if there is a way and what it is to do the following. i want to limit how many characters will show up in a region on my page. i would like it so that no matter how many characters the field in the database holds that it shows only a set amount on the page itself...eg. you have a field in your database that has the following stored in it. "hi my names fred and i like beer and walking on warm summer nights" but in the display box (where i'm displaying the record) is says this "hi my names fred and i like be..." notice how i included the "..." at the end. any ideas?

sorry about the multi post <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Easy enough.

Assuming the data is in a db field called "fldDescription" and you have a recordset called rs, try:

&lt;%
strConvert = (rs.Fields.Item("fldDescription".Value)
' convert string to the first 20 most characters
strConvert = Left(strConvert,20) & "..."
%&gt;

and later on in your code use:

&lt;%= strConvert %&gt;

to print out the first 20 characters.


Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

hello,
sorry for my English, I am French, a good excuse <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
I have to create an extension to do this, for Ultradev or Dream MX, I can send it to you.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hello,
sorry for my English, I am French, a good excuse <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
I have to create an extension to do this in PHP, for Ultradev or Dream MX, I can send it to you.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
hello,
sorry for my English, I am French, a good excuse <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
I have to create an extension to do this, for Ultradev or Dream MX, I can send it to you.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Oh. An extension to do this. I'm sorry, but I don't know how to make extensions. What I gave you was the ASP code to do what you asked for, but if you can find someone who can show you how to make an extension, you can incorporate that code into it and it should give you the desired results.

Best of luck!

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])