If your database doesn't support LIMIT sql clause (like Oracle)
or if you don't want complexity in SQL, you can do it in dtml
like

<dtml-in my_query>
 <dtml-if "_['sequence-number'] <=4 ">
  <dtml-var year>
 </dtml-if>
</dtml-in>

How ever, this assumes that the list of years are ordered properly
within the SQL. Also, this is good *ONLY* for queries that
return small number of data. You should not use this to pick
4 rows out of 10000 rows returned :-)

----- Original Message ----- 
From: Jonathan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 01, 2000 10:43 AM
Subject: [Zope] Substracting value from variable?


> Hi all,
> 
> Is there a way to have a ZSQL Method select the four highest values 
> from a list of values in a database? Example:
> 
>   select distinct year from table
> 
> returns the following results
> 
>   1975
>   1980
>   1985
>   1990
>   1995
>   2000
> 
> from which I want to select the latest four years:
> 
>   1985
>   1990
>   1995
>   2000
> 
> Possible? Can't seem to find anything in the docs :(
> 
> Thnx,
> Jonathan
> 
> _______________________________________________
> Zope maillist  -  [EMAIL PROTECTED]
> 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 )
> 
> 


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
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 )

Reply via email to