Mysterious Trailing Spaces

Question

I am using SQL Database for my application and something I
have not been able to understand: whenever I add a record to the
databse, when I retreive it, it has a bunch of trainling spaces.
This makes implementaion of the data very difficult since I
constantly have to use CStr and Trim functions to get rid of the
spaces. Any idea why this is happening?

Newsgroup_User · Answer

What does the form look like you're submitting data with? Do you find
trailing spaces in any other application?

"esonline" <webforumsuser@macromedia.com> wrote in message
news:e9nvfk$4ic$1@forums.macromedia.com...
>I am using SQL Database for my application and something I have not been
>able
> to understand: whenever I add a record to the databse, when I retreive it,
> it
> has a bunch of trainling spaces. This makes implementaion of the data
> very
> difficult since I constantly have to use CStr and Trim functions to get
> rid of
> the spaces. Any idea why this is happening?

>

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