[Zope] Building a cursor in a SQL query results

[Paolo Bizzarri]

Hi zopers,

this is my second try, and I hope to have better
luck than before.


My problem: I have to scan the query result of a
SQL query.

Currently, I have been able to assing the query
results to a variable and scanning the list
without resubmitting the query.

However, I am reassigning a variable inside a
cursor cycle and the variable do not seem to
change value.

Can you help me ?


This is my code


<!--#call
"REQUEST.set('fallite',ConnessioniFallite(anno=1999))"-->

<!--#call "REQUEST.set('cursore', 0)"-->

<!--#call "REQUEST.set('ID_corrente', 0)"-->

<!--#with REQUEST-->

<ol>

<!--#in ElencaID-->
<li> <!--#var IDomnibox--></li>
<ol>
  <!--#in "_.range(1, 12)"-->

	<li><B><!--#var cursore--></B></li>


       <!--#if
"_['sequence-index']==_.int(fallite[cursore]['mese'])-1
		and fallite[cursore]['omnibox']==IDomnibox"-->
	  	<li><!--#var
"fallite[cursore]['totale_fallite']"-->
		<!--#call "REQUEST.set('cursore', cursore+1)"-->
		</li>
	<!--#else-->
		<li>0
	<!--#/if-->
  <!--#/in-->

</ol>
<!--#/in-->

</ol>


-- 
Paolo Bizzarri - Responsabile Marketing  I3 Icube
Srl
Sede:   Via Ridolfi 15 - 56124 Pisa (PI), Italia 
E-mail: p.bizzarri@icube.it		WWW: www.icube.it	
Tel: 	(+39) 050 97 02 07		Fax: (+39) 050 31 36 588