You have two problems. We don't know which one you've solved. Do one thing at a time: <dtml-in test.py> <dtml-in DbQuery1 size=10 start=query_start> <dtml-var sequence-item> </dtml-in> </dtml-in> If that works, your Z SQL methods problem are solved. Nextly, copy one of the printed sequence items and try (Independently): <dtml-var "_.getitem('one of the names')"> Does that help. Besides, it think there's a difference in <dtml-let names="_.getitem('sequence-item')"> and <dtml-let names="_.getitem(_['sequence-item'])"> Both will "work" but it depends on what you want to do. Cheers, Peter ----- Original Message ----- From: "sudhakar" <sudhakar@mindscapecomputing.com> To: <zope@zope.org> Sent: Tuesday, August 07, 2001 6:40 AM Subject: [Zope] Regarding Mysql Query

hi guys,

i am very new to zope . i executed a query that will print 25 column. i don't want to hardcode the column name.i am getting the column name by below python script

test.py rec = context.DbQuery1() print "names: ", rec.names(), "\n" return rec.names()

using the column name i want to print the corresponding data.

<dtml-in test.py> <dtml-in DbQuery1 size=10 start=query_start> <dtml-let names="_.getitem('sequence-item')"> <dtml-var names> </dtml-let> </dtml-in> </dtml-in>

but it's printing the object.

<r instance at 02FF5E50> <r instance at 02FF5730> <r instance at 02FF5200> <r instance at 02FF59A0> <r instance at 02FF54F0> <r instance at 02FF5B60> <r instance at 02FF5180> <r instance at 02FF64A0> <r instance at 02FF68B0> <r instance at 02FF6500>

can any one help me .

regards, S.Sudhakar Sys Admin, Progammer Mindscape Computing (P) Ltd., Bangalore

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )