On Thu, 20 Apr 2006 07:51:24 -0700, Loo, Peter # PHX wrote: Hi Peter
> Do you mean plug in the work "undef" before doing the INSERT? Yes. Off the top of my head (add error checks!): $sql = 'insert into table_x (column_y, column_z) values (?, 99)'; $sth = $dbh -> prepare($sql); $sth -> execute(undef); -- Cheers Ron Savage, [EMAIL PROTECTED] on 21/04/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company