[Zope] Regarding Mysql Query

sudhakar sudhakar@mindscapecomputing.com
Tue, 7 Aug 2001 10:10:41 +0530


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