Unanswered: Adding data from listbox to database problem
I have a form, and in this form there is a listbox which is populated with data from a database (in this case, coursenames). The user selects something from the listbox and fills in the rest of the textboxes in the form. When the user clicks submit, all the data is sent to a table I have created in my database. Everything works fine, except there seems to be a problem with the data being sent from the listbox, in that it is only sending the first word of the coursename (i.e. for a course called 'Train the trainers' only the word 'train' is being sent to my database.
Can anyone shed some light on my problem, and maybe give some help?
This is the code I used to populate my listbox, the value 'test' is just the result of my SQL statement to get all the coursenames.
Do While Not display.EOF
response.write "<option value = " & display("Test") & " >"
response.write display("Test") & "</option>"
The code I am using to send my listbox data to my database is as follows, 'Evaluation' being my recordset, and 'training' being the name of the field in my database I would like the data sent to: