how to get next iteration values?
Hi, does somebody knows how to get next iterations of columns from SQL query? I think that is only due my unknowledge of right pythonic syntax. <dtml-let vypisSQL_LET="vypisSQL()"> -- ZSQL method results catch <dtml-in vypisSQL_LET prefix="listing"> current value: <dtml-var column> next value: <dtml-var "vypisSQL_LET.column[listing_number]"> -- here is an error </dtml-in> </dtml-let> Do you have some ideas how to get next value, please? It is possible to do with fill ['','',''....] fields or with memorizing/display last values as a main result, but it is not what I want, it is quite large sequence and ### columns. Many thanks, JL.
Jaroslav Lukesh wrote at 2007-9-17 13:42 +0200:
... does somebody knows how to get next iterations of columns from SQL query? I think that is only due my unknowledge of right pythonic syntax.
<dtml-let vypisSQL_LET="vypisSQL()"> -- ZSQL method results catch <dtml-in vypisSQL_LET prefix="listing">
current value: <dtml-var column> next value: <dtml-var "vypisSQL_LET.column[listing_number]"> -- here is an error
Do it in a "Script (Python)". It is much easier there.... Apart from that: "vypisSQL_LET[listing_number]" is the next hit (provided it exists). Thus, "vypisSQL_LET[listing_number].column" is the "column" field of the next hit. Be aware that you need to handle the boundary case (that you are already at the last hit). -- Dieter
----- Original Message ----- From: "Dieter Maurer" <dieter@handshake.de>
Jaroslav Lukesh wrote at 2007-9-17 13:42 +0200:
... does somebody knows how to get next iterations of columns from SQL query? I think that is only due my unknowledge of right pythonic syntax.
<dtml-let vypisSQL_LET="vypisSQL()"> -- ZSQL method results catch <dtml-in vypisSQL_LET prefix="listing">
current value: <dtml-var column> next value: <dtml-var "vypisSQL_LET.column[listing_number]"> -- here is an error
Do it in a "Script (Python)". It is much easier there....
Apart from that: "vypisSQL_LET[listing_number]" is the next hit (provided it exists). Thus, "vypisSQL_LET[listing_number].column" is the "column" field of the next hit. Be aware that you need to handle the boundary case (that you are already at the last hit).
It works! Many thanks for your help, JL.
participants (2)
-
Dieter Maurer -
Jaroslav Lukesh