updating many columns

I need to update/insert into a table which has 98
columns, does anyone know of any neat ways I can do
this? currently my query is just plain text with
placeholders like this:

update:
$query = 'UPDATE table SET column1=column1+? ... column98=column98+?
WHERE condition1=? AND condition2 = ?';

insert:

$query = 'INSERT INTO table VALUES (? .. ?)';

does anyone know a better way of doing this (apart from the obvious
way of having a loop from 1 to 98 and concatenting values to $query).

thanks





--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org