Re: [CDBI] Weird things with has_a and lazy population

[prev] [thread] [next] [Date index for 2005/11/17]

From: Phil Mitchell
Subject: Re: [CDBI] Weird things with has_a and lazy population
Date: 20:17 on 17 Nov 2005
>
> > here is DBI->trace:
> ....
>  T  <- prepare_cached('SELECT id FROM my_domains WHERE  id =3D ?
> ')=3D ( DBIx::ContextualFetch::st=3DHASH(0x8426a7c) ) [1 items] at DBI.pm
> line 391

There appears to be a problem with the way your columns are specified.
This SELECT statement is only retrieving your 'id' col. I've never
used set_up_table -- maybe the postgres version has some gotchas...
why not just set your columns explicitly with
__PACKAGE__->columns(...) and then you'll have a better idea what CDBI
is seeing...

>  T  <- FETCH('Active')=3D '' at DBI.pm line 1124
>  T  <- FETCH('Taint')=3D 1 at ContextualFetch.pm line 49
>     <- STORE('Taint' 0)=3D 1 at ContextualFetch.pm line 50
>     <- execute(46)=3D 1 at ContextualFetch.pm line 51
>  T  <- STORE('Taint' 1)=3D 1 at ContextualFetch.pm line 52
>  T  <- FETCH('NAME_lc')=3D [ 'id' ] at DBI.pm line 1125
>  T  <- bind_columns(SCALAR(0x84709f8))=3D 1 at DBI.pm line 1125
>  T  <- fetchrow_arrayref=3D [ '46' ] row1 at ContextualFetch.pm line 59
>  T  <- fetchrow_arrayref=3D undef row1 at ContextualFetch.pm line 59
>     <- disconnect_all=3D '' at DBI.pm line 677
> !T  <- DESTROY(DBIx::ContextualFetch::st=3DHASH(8426a7c))=3D undef during=
 global des...
>
> --
> Dmitry <df2@xx.xx>
>
>
> _______________________________________________
> ClassDBI mailing list
> ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
>


--
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
2People Blog: http://2-people.blogspot.com/
2People site: http://www.2people.org

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

Re: [CDBI] Weird things with has_a and lazy population
Phil Mitchell 20:17 on 17 Nov 2005

Generated at 21:49 on 21 Nov 2005 by mariachi v0.52