Hi I am getting a strange error and I have no clue as how to fix this.. I am getting values from select multiple tag from the FORM and trying to update the value in the table.
Say the select tag is like this <select name="course" multiple> <option value="c">c</option> <option value="java">java</option> <option value="perl">perl</option> </select> And I selected "java" , "perl". then the select course will have the value as javaperl. when I did the update query I am getting the error as DBI returned -> ERROR: Unterminated quoted string Then I used the hardcoding in the query then it was working fine.. So i feel there is some hiddencharacter which is causing the issue. when I printed the length it was giving 1 more the actual length. I tried all possible ways like $course=~ s/\r//g; splitting up ...substring... I hardcorde the select value in $course and then tried then it worked fine.. I am using postgres databse Query was $course I get from the select value update course_info set course='$course' where name='anish'; Thanks Anish
