[Zope] Select Count problem

[Jim Penny]

On Wed, Jul 24, 2002 at 05:44:03PM -0600, Jose Gerardo Amaya Giron wrote:
> Hello all. 
> 
> In a SQL Method I'm executing a select count query this way
> 
> select count(*) as count from table where attrib=something
> 
> now I want to get the results in a python script I try to get it with no
> success with the following 
> 
> SQLdata_datos_count = container.dic_datos_count(pdf_id=1)
> 
> SQLdata_datos_count[0].count
> 
> but I get a
> 
> Error Type: TypeError
> Error Value: argument 2 to map() must be a sequence object
> 
> what is the way to get the count data correctly
> 
> thanks in advance
> 
> Gerardo
> 

in a python script, you are returned a "results" structure.
SpinWing has a HOWTO on this, and there is an older one by me (jpenny).

Short answer.

res=container.dic_datos_count(pdf_id=1)

Then len(res) is the number of rows returned by the query.
res[0][0] is the first item of the first row, etc.

res.names() is a list of names (column headers) of res.

This fragment is ofen useful.

res=container.dic_datos_count(pdf_id=1)
n2i={}
names=res.names()
for i in range(len(names)):
  n2i[names[i]]=i

Then, you can select a row element using:

res[row][n2i['name']], for example, 

res[0][n2i['count']

Of course, in your case, res[0][0] is much easier.

Jim Penny
> 
> 
> 
> _______________________________________________
> 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 )
>