Re: Making DBI (results) more strict

2014-02-11 Thread Darren Duncan
Max, you can distinguish a missing column from a null one quite easily in regular Perl. If exists $hash-{key} is false then the column doesn't exist, where if that is true but defined $hash-{key} is false then it exists but is null. -- Darren Duncan On 2/10/2014, 10:57 AM, Max Maischein

Making DBI (results) more strict

2014-02-10 Thread Max Maischein
Hi all, I recently discovered the greatness that is Hash::Util::lock_ref_keys , when used together with -fetchall_arrayref() like this: ... my $rows= $sth-fetchall_arrayref( {} }; for( @$rows ) { lock_ref_leys( $_ ); }; ... This prevents me from accessing hash

Re: Making DBI (results) more strict

2014-02-10 Thread H.Merijn Brand
On Mon, 10 Feb 2014 19:57:41 +0100, Max Maischein cor...@corion.net wrote: Hi all, I recently discovered the greatness that is Hash::Util::lock_ref_keys , when used together with -fetchall_arrayref() like this: ... my $rows= $sth-fetchall_arrayref( {} }; for( @$rows ) {