On Thu, 20 Apr 2006 16:33:14 -0700 (PDT), William R. Mussatto wrote: Hi William
>> $sql = 'insert into table_x (column_y, column_z) values (?, 99)'; >> $sth = $dbh -> prepare($sql); $sth -> execute(undef); -- Cheers > Minior change: should it not be: > $sth -> execute((undef)); Well, no. Firstly I believe the original code is correct, and secondly that won't make any difference :-)! Perhaps you were thinking of trying to force DBI to quote the value (just guessing)? But I used a placeholder (the ?) to get DBI to do this /without me having to hold DBI's hand/ as to what needs quoting. Long Live Placeholders! -- 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