[DB-SIG] postgresql-python return type

[Karl Thomas Diedrich]

Hello,
I am using postgresql-python and pygnome to write an application.
I am having troubles dispaying the results of queries with pygnome. I
wanted to know if anyone knew how to do this or where to look.

The
data type of the results of queries is <pgqueryobject at ...>.
targetSearchResult = self.cnx.query( """SELECT description,
            accession, start, targetSeq, target.name, mismatch, oligoSeq
            FROM target, oligo
            WHERE description LIKE '%""" + keyword + """%'
            AND target.name = oligo.name
            ORDER BY mismatch DESC;"""
            )
type(tagetSearchResult) = <pgqueryobject at ...>
I can display the value(query results) of the object with the print
command
print targetSearchResult

I tried formatting it as a string but I get the object type name instead
of the value
format = '%s'
results = format % (targetSearchResult)
print reults   =    <pgqueryobject at ...>

Thanks,
Karl



Karl Diedrich 
died9501@uidaho.edu
http://www.uidaho.edu/~died9501/
University of Idaho
Environmental Biotechnology Institute
University of Idaho
Food Research Center 103
Moscow, ID 83844-1052