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
<%= 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