What submit-method are you using? GET/POST maybe you are exceeding the
GET-Maximum?
What are you using CGI.pm or Apache::Request? You could retrieve params
using @names = $cgi->param().
OT: You could also use placeholders, prepare the query once and execute
it with your data within the loop.
Tom
On Mon, 2003-12-15 at 18:11, Tom Conway wrote:
> My initial browser-refresh problem was variable scoping and I've worked that
> out.
>
> I now have another odd problem.
>
> I have a function that reads params and creates update statements.
> Up to 18 lines of 5 elements each posted from a form.
>
> The Code is like...
>
> MyUpdate($dbc,$query)
> ....
> for ($cnt=0; $cnt<18; $cnt++) {
>
> $id = $query->param('id'.$cnt);
> $fname = '"'.$query->param('first_name'.$cnt).'"';
> $lname = '"'.$query->param('last_name'.$cnt).'"';
>
> $sql = qq{UPDATE table
> SET first_name = $fname, last_name = $lname
> WHERE id = $id};
>
> After about 7 times thru, param() returns NULL for last_name, first_name but
> the ID has a value.
> I use the same logic to retrieve data and it works fine.
>
> The same code works without mod_perl enabled.
>
> _________________________________________________________________
> Dont worry if your Inbox will max out while you are enjoying the holidays.
> Get MSN Extra Storage! http://join.msn.com/?PAGE=features/es
--
\\\||///
\\ - - //
( @ @ )
-oOo--( )--oOo----------------------------------------------------------
___ ___ tom schindl
o __ / / / innovative medientechnik planung AG
/ /\/\/ / / /__/ / __ mailto:[EMAIL PROTECTED]
/ / / / /_/ / / /___/ http://www.impire.de
/ voice:+43(512)34193431,fax:+43(512)34193420
Eduard-Bodem-Gasse 6, A-6020 Innsbruck, Austria, Software Engineering
------------------------------------------------------------------------
--
Reporting bugs: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
