DBI: selectrow_array() return first column when called in list context

2013-12-20 Thread mimic...@gmail.com
Hi I need to understand why selectrow_array() return only one column (first column) when called in list context as in the code below. On the otherhand selectrow_arrayref behaves correctly. code = if ($x){ print "When using selectrow_array(), DBI returned:"; print "\$x: $x \$y

Re: DBI: selectrow_array() return first column when called in list context

2013-12-23 Thread mimic...@gmail.com
ken=\'Tt9VpStL4xADSDJQtd4AkM c6cVi66Mwmr9pMcCRgO4NVJ\'})|| die "Could not query database: $DBI::errstr\n"; In the above, $y is undef (or blank) although MySQL has values for both (user and perm) columns. On 21 December 2013 08:23, Martin J. Evans wrote: > On 20/12/2013 14:13, mimic..

Re: DBI: selectrow_array() return first column when called in list context

2013-12-24 Thread mimic...@gmail.com
gt; This helped. > > > > > On 23 Dec 2013, at 15:28, Bruce Johnson > > > wrote: > > > > > > > > >> On Dec 23, 2013, at 2:30 AM, mimic...@gmail.com wrote: > > >> > > >> The SQL query is the same in both cases