[Zope3-Users] can't seem to get data from proxied database rows

[matt wilbert]

Thank you Garrett.  That does work--no ForbiddenAttribute errors.

And I do use too many python expressions--I write more python than
TAL, so it seems more natural.  I'll see if I can suppress it.

Thanks again,

Matt


On Mon, 21 Mar 2005 21:47:32 -0600, Garrett Smith
<garrett at mojave-corp.com> wrote:
> Hi Matt,
> 
> I haven't used the rdb package, but from what I can tell, it's setup to
> allow you to read col values as attributes. E.g.
> 
>   python:row.lastname
> 
> In tales, this would be:
> 
>   tal:replace="row/lastname"
> 
> Btw, you don't need (or want) to using python for basic tales
> statements. E.g.
> 
>   tal:replace="python:name"
> 
> should just be:
> 
>   tal:replace="name"
> 
> And not to be too critical ;) but I'd call it 'row' instead of 'name'.
> 
> 
>  -- Garrett
> 
> 
> -----Original Message-----
> From:   matt wilbert
> Sent:   Sun 3/20/2005 3:02 PM
> To:     zope3-users at zope.org
> Cc:
> Subject:        [Zope3-Users] can't seem to get data from proxied
> database rows
> I have a database connection to a mysql database from ZopeX3.  It
> works (I can run test
> queries), and I have created a minimal Sql Script ("select * from
> test'") which also works when I test it.  It is called "listPeople"
> 
> Now I try to use it from a ZPT that looks like this:
> 
> <table tal:repeat="name context/listPeople">
>   <tr tal:replace="python:name">Name</tr>
> </table>
> 
> I get a result that looks like:
> 
> <security proxied zope.app.rdb.GeneratedRowClass instance at
> 0x2a9b1d95a8>
> <security proxied zope.app.rdb.GeneratedRowClass instance at
> 0x2a9b1d94d0>
> <security proxied zope.app.rdb.GeneratedRowClass instance at
> 0x2a9b1d9f38>
> 
> which makes sense because there are three rows in the test table.
> 
> However, I can't figure out how to get at the data.  Any attempt to
> reference something inside
> the proxied objects  (like "python:name[0]" or
> "python:name['lastname']" gives me a ForbiddenAttribute error.  Is
> this something I can't do with a TTW ZPT, or am I missing something
> more straightforward.  I have granted all possible permissions to
> Everybody.
> 
> Thanks,
> 
> Matt Wilbert
> _______________________________________________
> Zope3-users mailing list
> Zope3-users at zope.org
> http://mail.zope.org/mailman/listinfo/zope3-users
> 
> 
>