Trim extranous characters before displaying

[woolwerks]

I'm using CF MX with MS SQL Server and I can't seem to get the trim function to
work. As an example, I have a field that has a maximum of 100 characters. When
it displays in the browser, the unused characters appear as spaces after the
actual information. I'm using the following commands in my CFC file:

<cfquery datasource="#ds#">
UPDATE RRNEWS
SET TITLE='#Trim(ARGUMENTS.TITLE)#',
BODY='#Trim(ARGUMENTS.BODY)#',
PHOTO='#Trim(ARGUMENTS.PHOTO)#'
WHERE ARTICLEID=#ARGUMENTS.ARTICLEID#
</cfquery>

In the display page, the code is:

<p><b>#news.title#</b><br>
<img src="images/#news.photo#" border="0" align="right" hspace="2"
vspace="5">#news.body#</p>
</cfoutput>

Does anyone have any ideas as to why this isn't working or what I might try to
correct the problem?

Thanks,
Justin:beer;:confused;

[PaulH *TMM*]

woolwerks wrote:

> it displays in the browser, the unused characters appear as spaces after the
> actual information. I'm using the following commands in my CFC file:

how are these columns defined?

[woolwerks]

The columns are defined as follows:

articleid, int, 4, not null, identity, identity seed 1
title, char, 100, allow nulls
body, char, 1500, allow nulls
photo, char, 40, allow nulls

[PaulH *TMM*]

woolwerks wrote:

> The columns are defined as follows:
>
> articleid, int, 4, not null, identity, identity seed 1
> title, char, 100, allow nulls
> body, char, 1500, allow nulls
> photo, char, 40, allow nulls

if i remember right, char columns get padded. maybe varchar?

[woolwerks]

Paul-

That was it! Thanks a million for the assist. It is much appreciated.

Thanks,
Justin