Forums

This topic is locked

Certain Amounts of Data only

Posted 03 May 2002 16:46:06
1
has voted
03 May 2002 16:46:06 David Thomas posted:
Hi,
Is it possible that when including a recordest with name link and description to only show say the first 3 lines of the description on the master page.

Coz, some of the descriptions are quite hefty and i dont want people having to trawl through 10 pages to find the tool they want.

access 2000 db, UD4, asp/vb script is my set up. cheers for any feedback.

<img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle> I'm new to this stuff but i love it already <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

"Those who think they know it all, in fact no nothing at all" - Me!

Replies

Replied 03 May 2002 17:43:28
03 May 2002 17:43:28 Andrew Watson replied:
Its not so easy to specify the amount of lines but it is dead simple to limit the amount of characters returned.

just change the bit of code that says...

Recordset.Fields.Item("DescriptionField".Value

to read

Left(Recordset.Fields.Item("DescriptionField".Value, 100)

(where 100 is the amount of characters you want)

Cheers
Leed

:: Son, im Thirty.... ::
Replied 03 May 2002 18:26:23
03 May 2002 18:26:23 David Thomas replied:
Brilliant!!

thanks mate, one less headache to worry about<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

"Those who think they know it all, in fact no nothing at all" - Me!

Reply to this topic