how to strip extra spaces

Question

I have a cfinput bound to a cfgrid based on a DB query. The
zip field in the DB has a length of 20 chars. When the zip binds to
my cfinput it pulls the data, including the extra spaces after it,
for instance "02134 ". My cfinput zip field validates for ZIP, so
the validation fails because of the extra spaces. Is there a way to
strip these??

Thanks. --Steve

Newsgroup_User · Answer

Depending on what DB you are using trim the space in your query.

Select rtrim(zipcodes) as zipcodes

"sbrehm" <webforumsuser@macromedia.com> wrote in message
news:eknci3$jdp$1@forums.macromedia.com...
>I have a cfinput bound to a cfgrid based on a DB query. The zip field in
>the DB
> has a length of 20 chars. When the zip binds to my cfinput it pulls the
> data,
> including the extra spaces after it, for instance "02134 ".
> My
> cfinput zip field validates for ZIP, so the validation fails because of
> the
> extra spaces. Is there a way to strip these??
>
> Thanks. --Steve
>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded