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
participants (1)
-
Paolo Bizzarri