Hi.

I'm up against such problem:

website has a webform with 6 question. first 5 is a select type, the last one is texarea. In the select question users are awarded points for selecting proper answer. this is done by piping (4|q1, 7|q2, etc).

later custom made sql query counts up all the point and displays them on the website.

the problem is when user inpust numbers into textarea the query is adding them up giving wrong results.

i've changed the "data" field in webform_submitted_data to int and created an extra field called "comment" and updated the sql query in webfrom_submision.inc but all it does it inputs the same values into "data" and "comment".

the insert query insert values based on %d and %s.

i'm not that good in programming and dont know how to bite this one.

Basically i want webform to insert values from first 5 select element (cid 1-5 in webform_submitted_data) and the value from textarea (cid 6) into field comment.

I hope I've explained enough.

thanks for help