Limiting Text in Query Results

[admin]

Simple Way of limiting the amount of text shown from dbase results just replace the 10's with the amount of charactors you wish to limit.


<%
'Define Topic
Topic = rs("topic")

'Limit amount of Characters to show
Topic = left(topic,10)

'iF 10 Characters is not Null then show first 10 with ... after the first 10

if mid(topic,10) <> "" then
Topic = left(topic,10) & "..."
end if

'display results of topic
response.write("topic")
%>


or simply


<%=("topic")%>


By Willie