Force Truncate

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
Tue Feb 12 21:19:32 CST 2008

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


"frontpagecustoms.com" <mark@sdag.org> wrote in message
news:138026a7-6672-4c91-be2f-b0026f7f6949@l32g2000hse.googlegroups.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.

Thomas
Wed Feb 13 06:55:45 CST 2008

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" <mark@sdag.org> wrote in message
news:138026a7-6672-4c91-be2f-b0026f7f6949@l32g2000hse.googlegroups.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.

frontpagecustoms
Thu Feb 14 10:00:34 CST 2008

On Feb 13, 6:55 am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
> 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" <m...@sdag.org> wrote in message
>
> news:138026a7-6672-4c91-be2f-b0026f7f6949@l32g2000hse.googlegroups.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.

Thanks I'll give this a try.