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

[Garrett Smith]

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



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3552 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope3-users/attachments/20050321/c5132dc9/attachment.bin