Member AVATAR Issue

Topics: Developer Discussion, Help, Request
Jun 15, 2007 at 7:13 PM
I'm having an issue uploading an AVATAR on my Member Details page. I use the browse botton to select an image. Then I click on the upload image botton, but nothing happens.

I'm using SQL 2000 and the database is setup as Case Sensitive.

I've seen where people have encountered this problem and then seem to have fixed it, but they don't list how it was fixed.

Any help would be appreciated.

Thanks...
Jun 15, 2007 at 8:02 PM

deforgej wrote:
I'm having an issue uploading an AVATAR on my Member Details page. I use the browse botton to select an image. Then I click on the upload image botton, but nothing happens.

I'm using SQL 2000 and the database is setup as Case Sensitive.

I've seen where people have encountered this problem and then seem to have fixed it, but they don't list how it was fixed.

Any help would be appreciated.

Thanks...


Please disregard....I found the problem.

In the AvatarImageFetch.ashx file I had to change 'memberinfo' on the following line from

Dim qry As String = "select avatar from memberinfo where memberid=@memberid"

to

Dim qry As String = "select avatar from MemberInfo where memberid=@memberid"

When you are using a SQL DB configured to be Case Sensitive, case does matter.

Thanks...
Coordinator
Jun 15, 2007 at 8:06 PM
Good thing we will be using SubSonic then... they take care of the case for us.