Force Truncate

[frontpagecustoms.com]

is there a way to force truncate a memo field in a database results
region. I want to only display a fixed amount of text in the search
results field instead of the entire memo.

 

[Kathleen Anderson]

You would want to use the SQL Substring function - here's some info:
http://www.1keydata.com/sql/sql-substring.html



--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Thomas A. Rowe]

On the page where your want to display the data, do

<%=Left(RecordSet("fieldname"),100))%>

which is grabbing the first 100 characters of the field content.

recordset = your recordset name
fieldname - the field name from your database

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[frontpagecustoms.com]

On the page where your want to display the data, do

<%=Left(RecordSet("fieldname"),100))%>

which is grabbing the first 100 characters of the field content.

recordset = your recordset name
fieldname - the field name from your database

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

Thanks I'll give this a try.