hello together,

i'd like to show the first 100 chars from a database entry. is there a function for this?

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_shoutbox_STRING
Recordset1.Source = "SELECT TOP 3 * FROM shoutbox ORDER BY postid DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

i use asp with an access-database

greetings peter

Hiya

Try this thread, exactly the same request except for the number.

www.dmxzone.com/forum/topic.asp?TOPIC_ID=28973&FORUM_ID=7&CAT_ID=5&Topic_Title=Diplaying+Partial+Results+from+a+Search&Forum_Title=ASP

Digga

Sharing Knowledge Saves Valuable Time!!!