>>> [EMAIL PROTECTED] 9/29/2004 12:18:55 PM >>>
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]
