Not only can I not help you, I have a question for you. 1) Did you ever find an answer? If so, may I have it? 2) If not, you mention how you currently are able to access a query and then scan the list. How do you do this? Below is a list of questions, I realize you are busy, but if you have the time to answer any of these let me know. Thanks, Quad I get lost in your code. Here are my assumptions 1) I assume the "call" to ConnessioniFallite is to another funtion. 2) The "<!--#in ElencaID-->" is a call to an SQL query 3) Request.set('cursore', 0) sets the cursore variable to 0 Question 1) What does the "<!--#with REQUEST-->" do? 2) "<!--#var IDomnibox-->" - does this just declare the variable IDomibox? 3) "<!--#in "_.range(1, 12)"-->" what does this delare? 4) "_['sequence-index']" what does this reference? 5) "_.int(fallite[cursore]['mese'])" what does this mean? Is it a record structure? -----Original Message----- From: Paolo Bizzarri [mailto:p.bizzarri@icube.it] Sent: Sunday, August 15, 1999 3:35 AM To: zope Subject: [Zope] Building a cursor in a SQL query results 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 _______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )