[Zope] Help needed on ZPyGreSQLDA and empty query result.

[Gilles.Lavaux]

Hello All,

I have a problem with the PostgreSQL module and empty query result:

When a select query (named TestSearch bellow) return no tuple, the message
is 'Error, exceptions.IndexError: tuple index out of range'
In case of a Gadfly DB, the same query will return:'There was no data
matching this select test query'

My problem is that this query SQL method is use in a <!--#IN tag:
<!--#in TestSearch size=50 start=query_start-->
   <!--#if sequence-start-->
      <!--#if previous-sequence-->etc...

This cause a 'system unavailable' page to be rendered, instead of a ' no
record something...'

Do you know any workarround or DTML error trapping solution? Is it a bug
inthe ZPyGreSQLDA module itself ? If yes it it inside the 'query' function?
I actualy use an external method to filter the records, shall I also use a
external method to do a 'try: except:' test on the TestSearch ?


Thanks For any solution/help.

Gilles

gilles.lavaux@mail.esrin.esa.it