I do something similar for my blog on my homepage http://www.stangocity.com
<http://www.stangocity.com>
<cfoutput query="hotnews">
#title#<br>
#left(description,50)#......
</cfoutput>
-----Original Message-----
From: Mark Henderson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 3:16 PM
To: CF-Talk
Subject: Truncating database field
Currently I have a hotnews page which calls information from an access
database table. In this table when the data is entered it captures the date
and time, and I would now like to be able to do two things with this. In
another linked page I'd like to display the title and only the first 50
characters of the relevant description field for each item. A google search
didn't reveal much. I'm sure this is possible..any ideas?
Here's the query...
<cfquery datasource="#request.dsn#" name="hotnews">
SELECT
news_ID,title,description,image,date_added,active
FROM
hot_news
</cfquery>
TIA
MarkH
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Re: Truncating database field John Stanley
- Re: Truncating database field Mark Henderson
- Re: Truncating database field Bert Dawson
- RE: Truncating database field Lawrence Ng