Re: Inserting more than one entry into a MySql DB

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);

Comment on Re: Inserting more than one entry into a MySql DB Select or Download Code

Replies are listed 'Best First'.
Re: Re: Inserting more than one entry into a MySql DB by Kiko (Scribe) on Feb 01, 2002 at 19:45 UTC
Hi, I retrieve the icodes as such: @icodes = split(/,/, $q->param('icodes')); Are you saying that i should just leave it alone? Thanks -Kiko	[reply]
Re: Re: Re: Inserting more than one entry into a MySql DB by dws (Chancellor) on Feb 01, 2002 at 21:27 UTC
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.	[reply] [d/l]