Strange DropList behavior

[MartinLev]

Hi!

My dropDown menu are working fine (using PHP Assistant), except for one detail the list contain values from a List Value (first name, last name). There is a space between the first and last name.

When I choose a person, only it's first name is entered in the database.

Lets say my value list is

John Doe

Susan Whatever

Martin Familyname

All the values display fine in the web browser.

When user choose "Susan Whatever", only "Susan" is entered in the database.

Any clue? Seems like everything after the sapce is not passed to the database.

Martin

[almedajohnson]

why don't you make two different fields? One for first name and other for last name rather than single name field. It will also make your queries simple.