Re: Not getting unique data in an iterator.

[prev] [thread] [next] [Date index for 2004/07/07]

--Signature=_Tue__6_Jul_2004_20_27_32_-0600_8pu076i_+Orug/zi
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

When grilled further on (Tue, 06 Jul 2004 10:57:38 -0400),
Perrin Harkins <perrin@xxxx.xxx> confessed:

> On Tue, 2004-07-06 at 10:01, Robert Creager wrote:
> > When executing the following, the data retrieved through the inner ($v_iter)
> > iterator is only the first row returned by the db query.  $v_iter does loop
> > the correct number of times (48 with my db in this specific instance), but
> > the data is not changing during the loop.
> 
> Looks like your setup for TASSIV::ObsV has the wrong primary key.
> 
> > package TASSIV::ObsV;
> > 
> > use base qw( TASSIV::DBI );
> > 
> > __PACKAGE__->table( 'obs_v' );
> > __PACKAGE__->columns( 'Primary' => 'star_id' );
> > __PACKAGE__->columns( 'Others' => qw/x y mag smag file_id/ );

Hey Perrin,

Thanks for catching my bugs...  The 'columns' should of been:

__PACKAGE__->columns( 'Primary' => 'obs_id' );
__PACKAGE__->columns( 'Others' => qw/star_id x y mag smag file_id/ );

All works well now.

Cheers,
Rob

        -- 
         20:21:52 up 69 days,  3:06,  5 users,  load average: 2.27, 2.14, 2.07
Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004

--Signature=_Tue__6_Jul_2004_20_27_32_-0600_8pu076i_+Orug/zi
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iEYEARECAAYFAkDrX54ACgkQLQ/DKuwDYzlbWgCfUZ6GfXmDNQwAh3LZLu1B/o6U
by4AniNQJlkVX/DQ7T7L888u+KtUMS1B
=3nP+
-----END PGP SIGNATURE-----

--Signature=_Tue__6_Jul_2004_20_27_32_-0600_8pu076i_+Orug/zi--