Very Computer

> This is a weird problem.  Am attempting to extract information of a
database
> and display it on a ASPX web page.  The information extracts ok but it
seems
> that not the whole word is displayed.  For example, when user logs in, the
> main page should say, "Greetings Joe Bloggs", instead it says "Greetings J
> B".  When in the database, the column for first name is in full "Joe" and
> column for second name is "Bloggs".  Somehow it is only extracting the
first
> letter of the column.

> Heres my stored procedure to retrieve customer details of the database.

> --------------------------------------------------------------------------
--
> ---
> ALTER PROCEDURE dbo.retrieveUserDetails
> /*
> */










> AS









> from customers

> --------------------------------------------------------------------------
--
> ---

> And here is the code for placing the extracted data from the server on to
a
> *.aspx page.

> --------------------------------------------------------------------------
--
> ---

> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles MyBase.Load
>         UserSessionCheck(Session, Request.Cookies("EHome"))
>         If Session("loginStatus") = 1 Then
>             loggedInMsg.Text = "Wellcome, you are currently logged in as "
>             With sqlProcRetrieveUserDetails

>             ''Pass in customer ID to retrieve specified customer record

>                 sqlConnection.Open()
>                 .ExecuteNonQuery()
>                 sqlConnection.Close()

>             ''Display retrieved information and put them in their
respective
> labels.

>             End With
>         Else
>             firstName.Visible = False
>             lastName.Visible = False
>             loggedInMsg.Text = "You are currently logged in as guest."
>         End If
> End Sub

> --------------------------------------------------------------------------
--
> ---

> And here is the DB table design sheet.

> --------------------------------------------------------------------------
--
> ---

> Key:        Column Name:                        Data Type:        Length:
> Allow Nulls:
> 3             CustomerID                             int
> 4                            0
> 0             CustomerFirstName                 varchar              50
> 1
> 0             CustomerLastName                 varchar              50
> 1
> 0             CustomerAddress                    varchar             150
> 1
> 0             CustomerCity                          varchar
100
> 1
> 0             CustomerPostCode                  varchar             15
> 1
> 0             CustomerCountry                     varchar             100
> 1
> 0             CustomerEmail                        varchar             150
> 1
> 0             CustomerUserName                 varchar             25
> 1
> 0             CustomerPassword                  varchar             25
>         1
> 0             CustomerCookie                      tinyint               1
> 1

> --------------------------------------------------------------------------
--
> ---

> So customerFirstName would contain "Joe" and CustomerLastName would
contain
> "Bloggs".

> But when runing the procedure, only the first letter of the columns are
> displayed. E.g. "J " and "B ".  The last part of the letters it seems have
> been hacked off, but why?

> If anyone know what the problem is with this?

> Thanks!