[Zope] Building a cursor in a SQL query results

Marten Quadland mquadland@indigonetworks.com
Tue, 24 Aug 1999 16:08:03 -0500


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 )