User Profile Management - space appended to user profile field on storing.

This is Interesting: Free IT Magazines  
Home > Archive > User Profile Management > September 2004 > space appended to user profile field on storing.





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author space appended to user profile field on storing.
Martin

2004-09-22, 9:48 pm

This is a strange one...

It seems I have a custom profile field that CS2002 insists on appending a
space to when it stores it in the database.
Even as I write this, I think it can't be true, but am looking at the value
userprofile.Properties["myfield"].Value immediately prior to calling
userprofile.Update(); -- the value has no space at the end

After update executes I look in the database, and *there* is a space at the
end of the text.

What's going on?
I don't see spaces at the end of other fields, yet I can't see that it's a
bug in my code unless the debugger is giving me duff information.

Anyone?
Martin


Martin

2004-09-22, 9:48 pm

How embarassing - the data field in SQL was fixed length!


"Martin" <x@y.z> wrote in message
news:u$gzvKjnEHA.2612@TK2MSFTNGP15.phx.gbl...
> This is a strange one...
>
> It seems I have a custom profile field that CS2002 insists on appending a
> space to when it stores it in the database.
> Even as I write this, I think it can't be true, but am looking at the

value
> userprofile.Properties["myfield"].Value immediately prior to calling
> userprofile.Update(); -- the value has no space at the end
>
> After update executes I look in the database, and *there* is a space at

the
> end of the text.
>
> What's going on?
> I don't see spaces at the end of other fields, yet I can't see that it's a
> bug in my code unless the debugger is giving me duff information.
>
> Anyone?
> Martin
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com