Forums

This topic is locked

insert just 2 line or 100 lettres from database

Posted 15 Sep 2001 15:56:50
1
has voted
15 Sep 2001 15:56:50 anouar stevens posted:
i have a page for results with recordset
, so when i want to display the results from a champX (memo) i want to be writed just the first 2 line from the all text

think's for any idea



Replies

Replied 15 Sep 2001 16:07:29
15 Sep 2001 16:07:29 Owen Eastwick replied:
Try this:

<%= Left ((YourRecordsetName.Fields.Item("YourDatabaseTable".Value), 100)%>

<b>NOTE</b> - the parameter <b>100</b> will display the first 100 characters, adjust this to display as many as you wish.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Edited by - oeastwick on 09/15/2001 16:18:53

Reply to this topic