[Zope] ZGDChart product...

[Furbach, Andreas]

Hello.

The function _chartdata in ZGDchart.py returns only one label column and one
data column. 
You may want to change this to:
*********************************************************************

        def _chartdata(self):
                """
                return the first and second columns of sql query
                results as a pair of tuples
                """
                rows = getattr(self, self.SQL)()
                # data[0] is list of labels
                data =  []
                start = 0
                for row in rows:
                        # each row is a list of fields
                        # initialize empty lists for each column
                        if start == 0:
                          start = 1
                          for i in range(len(row)):
                            data.append([])
                        #
                        # Only insert rows with zero values if
                        # it is not a pie chart
                        # Pie Chart only makes sense with 1 data column
                        #
                        for i in range(len(row)):
                            if (self.REQUEST['zgdchart_runtime_type'] !=
GDC_3DPIE and self.REQUEST['zgdchart_runtime_type'] != GDC_2DPIE) or row[1]
!= 0:
                              #
                              # Coerce the first field into a string
                              # and other fields into a float
                              #
                              if i == 0:
                                  data[i].append( str  (row[i]))
                              else:
                                  data[i].append( float(row[i]))
                #
                # convert lists to tuples
                # apparently, gdchart.chart() accepts lists
                # as well, but I better check with
                # M Steed first.
                #
                # I just tried.
                return data

****************************************************************************
***

and restart Zope, which worked for me.

Andreas Furbach
_______________________________________________________
EDS Informationstechnologie und Service GmbH
Semerteichstr. 50-52
D-44141 Dortmund

Tel.: 0231 / 944-1533
mailto: andreas.furbach@eds.com

>Hi.
>
>This is really a great product.
>
>Unfortunately, I'm not able to create a chart with multiple columns using a

>ZSQL Data Method.
>Multiple columns with a DTML-Method works fine.
>
>Do I miss something. Any ideas?
>
>Thanks for any help. Regards, Marc Ludwig (zope@isp.lu)