inserting select options into multiple rows

praveen t n

Hi All,

I have a container with text, textarea and select (multiple selection possible) fields. I need to insert multiple selection (say a & b) as different rows into db. Used list-to-replicant and list-to-field as per dd manual.

datacapture.cfg
[html]


Description

Class







<br>





[/html]
deployment config
[html]

name="ProductType"
allows-null="yes"
data-type="VARCHAR(3)"
list-to-replicant="yes"
list-field="list/0/description_list/0/description_sc"
value-from-field="list/0/description_list/[0-49]/description_sc"
is-replicant="yes"
/>
[/html]
When I selected A, B and deployed only the value A got inserted into the DB. Got the error "value for ProductType exceeds column width 4 > 3". Any suggestions?

There is one Primary Key for the table (will this create any problem?).

regards,
Praveen