Incomplete database entry

grail

We're using postgreSQL as our database. Two of our data entry fields are (first,last)name and (last,first)name. Search options require us to have it like this or we would just do first and last seperately.

On to the problem, when the name is entered into the text field it is usually entered like thus (Firstname Lastname). When done like this, as people are used to doing, only the first name makes it into the database field, everything after the space is dropped. Is there anyway to make sure that both names get into the database? Instead of being chopped off at the space.

THANKS!

Anon

I'm not sure if this is the problem but when you insert it into the database are you inserting the variables using quotes? like '$name' i'm not sure if that will solve the problem but i know in Oracle if its a text field and you are inserting something you need the quotes do not know if that is the case with PostgreSQL. But doesn't hurt to try

grail

Yeah the variables are conatined within quotes, so I dont think that is what is causing the (after space) data to be droped I havent figured out.

grail

Ive been working on this and have found this is going on. When passing variables recieved from a user through a form I lose part of the data. This is how the transfer goes.

("Array[data1]" = "$Array[data1]" = '$data1')
"Array[First Name]" = "$Array[First Name]" = '$First'

The above is an expample of what is happening. The variables are passed three times and on the last pass, the second part of the data after the 'space' in the name the last part of the name is lost. I cant figure out why I loose that last part of the data. Any Ideas?

NOTE: The last variable is a variable in a SQL statement

grail

I seem to be loosing the last part of the data when its sent to the page that Displays the data for review. When I bypass this page it inserts the data into the database properly. In the review page Im using echo statements within a table to display the transfered variable data. This works as expected. Also on this page is another form with hidden fields, that have an echo statement that corresponds with the table above in its value attribute. This value seems to loose any data after the "space" in a variable with a (FirstName LastName) format even though the data in the table (which references the same variable) remains consistant. So I loose the last name. Any ideas on how I can keep this data from disappearing?