Re: Inserting more than one entry into a MySql DB

[dws]

Show us the line that sets up @icodes. If, as you say, it is   @icodes="CEN01-SJU1-022102A CEN02-MEX1-022702P CTE01-SJU1-022202A CTE02-MEX1-022802P"; then it only contains a single element. To make that an array, do something like   @icodes=qw(CEN01-SJU1-022102A CEN02-MEX1-022702P CTE01-SJU1-022202A CTE02-MEX1-022802P);

[Kiko]

Hi,
I retrieve the icodes as such:
@icodes = split(/,/, $q->param('icodes'));
Are you saying that i should just leave it alone?
Thanks
-Kiko

[dws]

I retrieve the icodes as such:
@icodes = split(/,/, $q->param('icodes'));
Are you saying that i should just leave it alone?

That should work. I think screamineagle nailed this one. You might be trying to reuse a primary key. Adding error checking after the execute() might reveal this as a problem.