Re: perl dbh->quote and numeric columns

At 15:15 -0400 6/27/02, walt wrote: >On Thursday 27 June 2002 02:30 pm, Mike(mickalo)Blezien wrote: >> Walt, >> >> Use Perl's 'undef' for NULL values. >> >> $quoted_some_variable = undef; >> >> now the $quoted_some_variable will be a null value. >> >> >>On Thu, 27 Jun 2002 12:50:55 -0400, wal

Re: perl dbh->quote and numeric columns

On Thursday 27 June 2002 02:30 pm, Mike(mickalo)Blezien wrote: > Walt, > > Use Perl's 'undef' for NULL values. > > $quoted_some_variable = undef; > > now the $quoted_some_variable will be a null value. > > >>On Thu, 27 Jun 2002 12:50:55 -0400, walt <[EMAIL PROTECTED]> wrote: > >> > >>I'm in the

Re: perl dbh->quote and numeric columns

Walt, Use Perl's 'undef' for NULL values. $quoted_some_variable = undef; now the $quoted_some_variable will be a null value. >>On Thu, 27 Jun 2002 12:50:55 -0400, walt <[EMAIL PROTECTED]> wrote: >>I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql. >> >>Does anyone

perl dbh->quote and numeric columns

I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql. Does anyone know how to get the dbh->quote(some_value) function in perl to return the string "NULL" if some_value is empty. Currently its returning '' (2 ticks) and when you update a numeric column, it sets the value to