duploX
Posts: 14
|
| Posted: 05/18/2007, 6:14 PM |
|
How can I display a summary of a memo field ???
I have a memo field where users can write reviews about hotels and travel destinations.
When they search for reviews I would like to display a brief summary (maybe 100 letters) instead of the full review.
Does anyone know how to do that ???
Thank you in advance.
Christoph
|
 |
 |
wkempees
|
| Posted: 05/19/2007, 5:55 PM |
|
if the select contains anything like
SELECT comment from table
you could easily (studying you SQL language reference) in pseudo:
SELECT substring(comment,100) from table
to get the first 100 characters
when comfortable with that you could even shorten the 100 by finding the
last space within your 100
and substitute that space with either [.. contd.] or even a hyperlink to the
full article
Walter
"duploX" <duploX@forum.codecharge> schreef in bericht
news:6464e4f93dfa69@news.codecharge.com...
> How can I display a summary of a memo field ???
>
> I have a memo field where users can write reviews about hotels and travel
> destinations.
>
> When they search for reviews I would like to display a brief summary
> (maybe 100
> letters) instead of the full review.
>
> Does anyone know how to do that ???
>
> Thank you in advance.
>
> Christoph
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
|
