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
HI, i'm implementing virtual hosting using apache + siteaccess + zope but i have a few problems that i try to solve but it is consuming me much time so i ask to you because i'am in a bottleneck. Hi follow the instruction in the "Apache Not Zope.cgi HOWTO" that explains how to use zope behind apache without the need for a cgi, however two things don't work as i want: * The Path * The Undo * The ZNavigator The first i fix using apache redirect rules as folowing (in this example the directory is named "Incorbank" under the root directory): Redirect /Incorbank http://www.incorbank.com/Zope So it works fine, i use partial zopification using http://www.incorbank.com/Zope to http://www.incorbank.com:9673/Incorbank The Undo don't work as expected because any user in this site (http://www.incorbank.com/Zope) can undo changes made in another directory outside Incorbank :(, so bad !!! The ZNavigator don't work too. I folow the instructions in the zope-znavigator.deb debian package but i can not fix that using siteaccess rules, so currently i'm tired, so if any one can help or can send me a working configuration i would be glad to get this. Thanks to all, Nestor A. Diaz Ingeniero de Desarrollo Engendro - Comercio Electronico sobre Linux Email: nestor@engendro.com - WWW: http://www.engendro.com
HI, Can anybody tell me if there is a posibility to use Zope with Informix 7.3 on a Linux machine? maybe using odbc driver? thanks you.. -- Nestor A. Diaz Ingeniero de Desarrollo Engendro - Comercio Electronico sobre Linux Email: nestor@engendro.com - WWW: http://www.engendro.com
"Nestor A. Diaz L." wrote:
HI,
Can anybody tell me if there is a posibility to use Zope with Informix 7.3 on a Linux machine? maybe using odbc driver?
thanks you..
I would be interested in this, too. Could anyone help or give some hints. Thanks Eric
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 <listsmurf@ur.nl> To: <zope@zope.org> 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 - Zope@zope.org 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 )
participants (5)
-
Erich Seifert -
Jonathan -
Nestor A. Diaz L. -
Nestor A. Diaz L. -
Satheesh Babu