you want to get the first comment in that big text field? Is that accurate?
(It's horrible DB design, btw.)
If so, you should be able to do this:
<cfsavecontent variable="comments">
*** 13/01/2003 09:47:06 TUser1 ***
callno:1126
Some comment1
*** 13/01/2003 08:30:27 TUser2 ***
Some Comment2
</cfsavecontent>
<cfoutput>
FIRST COMMENT =<br>
*** #listgetat(comments, 2, "***")# ***<br>
#listgetat(comments, 3, "***")#
</cfoutput>
Ugly ugly, though.
----- Original Message -----
From: "cf coder"
> Hi Guys,
>
> I'm strugging to display the data correctly from the
> comment column in the database and need your help. I
> want to display the top most comment from the comments
> table. Here is an example. In the example below there
> are 2 comments
>
> *** 13/01/2003 09:47:06 TUser1 ***
> callno:1126
> Some comment1
>
> *** 13/01/2003 08:30:27 TUser2 ***
> Some Comment2
>
> I want to display the TOP most comment. In this case
>
> *** 13/01/2003 09:47:06 TUser1 ***
> callno:1126
> Some comment1
>
> All comments have the ***, date time and user
> information
> "*** 13/01/2003 09:47:06 TUser1 ***"
>
> I would really apprecaite your help.
> Best Regards,
> cfcoder
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
