Try these
{{extend 'layout.html'}}
<h1>This is the test/show_periods.html template</h1>
{{for period in periods:}}
<TR>{{=period}}</TR>
{{ subperiods = db(db.subperiod.period=period.id).select()}}
{{for subperiod in subperiods:}}
<TR>{{=subperiod}}</TR>
{{pass}}
{{pass}}
and the following method:
def show_periods():
periods=db().select(db.period.ALL)
return dict(periods=periods)
On Jun 15, 5:22�pm, "Francois (Jersey)"
<francois.ches...@googlemail.com> wrote:
> I tried the following view:
>
> {{extend 'layout.html'}}
> <h1>This is the test/show_periods.html template</h1>
>
> {{for period in periods:}}
> � � <TR>{{period}}</TR>
> � �{{ subperiods = db(db.subperiod.period=period.id).select()}}
> � � �{{for subperiod in subperiods:}}
> � � � � �<TR>{{subperiod}}</TR>
> � � � � � {{pass}}
> � � {{pass}}
>
> and the following method:
>
> def show_periods():
> �� � periods=SQLTABLE(db().select(db.period.ALL))
> �� � return dict(periods=periods)
>
> I does not work, what does I get wrong? Apologies, if this look
> staighforward.
> thanks
>
> Error traceback
>
> Traceback (most recent call last):
> � File "/home/francois/web2py/gluon/restricted.py", line 105, in
> restricted
> � � ccode = compile(code.replace('\r\n', '\n'), layer, 'exec')
> � File "/home/francois/web2py/applications/cookbook4/views/test/
> show_periods.html", line 42
>
> SyntaxError: keyword can't be an expression
>
> In file: /home/francois/web2py/applications/cookbook4/views/test/
> show_periods.html
>
> response.write('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//
> EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>\n<html
> xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">\n<head>
> \n<meta http-equiv="content-type" content="text/html; charset=utf-8" />
> \n<meta name="keywords" content="',escape=False)
> response.write(response.keywords)
> response.write('" />\n<meta name="description"
> content="',escape=False)
> response.write(response.description)
> response.write('" />\n<title>',escape=False)
> response.write(URL(r=request))
> response.write('</title>\n<link type="text/css" rel="stylesheet"
> href="/',escape=False)
> response.write(request.application)
> response.write('/static/textarea/SyntaxHighlighter.css"></link>
> \n<style>\ndiv.fluid { width: 93% !important; }\n div.fixed { width:
> 800px !important; }\n* { margin: 0em; padding: 0em; }\n body
> { background-color: #fff; color: #585858; font-size: 10pt; font-
> family: georgia, serif; }\n h1,h2,h3,h4,h5,h6 { font-weight: normal;
> letter-spacing: -1px; }\n h2,h3,h4,h5,h6 { color: #185360; }\n
> br.clear { clear: both; }\n img { padding: 3px; border: solid 1px
> #e1e1e1; }\n img.icon { border: 0px; vertical-align: middle; }\n
> img.floatTL { float: left; margin-right: 1.5em; margin-bottom: 1.5em;
> margin-top: 0.5em; }\n a { text-decoration: none; color: #FF5C1F; }\n
> a:hover { text-decoration: underline; }\n textarea { font-family:
> courier; }\n ul { margin-left: 1.5em; }\n li { line-height: 1.5em; }\n
> dd { text-decoration: bold; }\n dt { text-decoration:none; margine-
> left: +10em; }\n p { line-height: 1.8em; }\n table, tr, td { text-
> align: left; vertical-align: top; } \n #header { width:100%; height:
> 48px; background: #195866 url(\'/',escape=False)
> response.write(request.application)
> response.write("/static/title.png') repeat-x; }\n #header_inner
> { position: relative; width: 800px; height:36px; margin: 0 auto; }\n
> #header_lite { width:100%; height:36px; background: #440000 url
> ('/",escape=False)
> response.write(request.application)
> response.write('/static/title.png\') repeat-x; }\n #header_inner_lite
> { position: relative; width: 800px; height: 36px; margin: 0 auto; }\n /
> * Logo */\n #logo { position: absolute; bottom: 0.6em; }\n #logo h1
> { display: inline; color: #fff; font-size: 1.8em; }\n #logo h2
> { display: inline; color: #fff; font-size: 1.8em; }\n /* Menu */\n
> #menu { position: absolute; right: 0em; bottom: 0em; }\n #menu ul
> { list-style: none; }\n #menu li { float: left; }\n #menu li a
> { margin-left: 0.5em; display: block; padding: 0.5em 0.5em 0.5em
> 0.5em; background: #fff repeat-x; color: #185360; font-weight: bold;
> font-size: 1.0em; text-decoration: none;}\n// #menu li a.inactive
> { background: #FF6C1F repeat-x; color: #fff; border: solid 1px
> #DB7623; border-top: solid 1px #FBA653; }\n#menu li a.inactive
> { background: transparent; color: #FF5C1F; border: solid 0px #185360;
> border-top: solid 0px #185360; }\n /* Main */\n #main { background:
> #fff 0px 1px repeat-x; }\n #main_inner p { text-align: justify; margin-
> bottom: 2.0em; }\n #main_inner ul { margin-bottom: 2.0em; }\n
> #main_inner { position: relative; width: 800px; margin: 0 auto;
> padding-top: 1.0em; }\n #main_inner h1 { border-bottom: dotted 1px
> #E1E1E1; position: relative; font-size: 2.1em; padding-bottom: 0.1em;
> margin-bottom: 0.8em; }\n #main_inner .post { position: relative; }\n
> #main_inner .post h3 { position: relative; font-size: 1.7em; padding-
> bottom: 1.2em; }\n #main_inner .post ul.post_info { list-style: none;
> position: absolute; top: 3em; font-size: 0.8em; }\n #main_inner .post
> ul.post_info li { background-position: 0em 0.2em; background-repeat:
> no-repeat; display: inline; padding-left: 18px; }\n /* Flash */\n
> #flash { width: 600px; margin: 0 auto; text-align: center; clear:
> both; border: 1px #000000; background-color: #FF5C1F; color: white;
> margin-top: 0.0em; margin-bottom: 1.0em; padding-top: 1.0em; padding-
> bottom: 1.0em; }\n /* Footer */\n #footer { width: 800px; margin: 0
> auto; text-align: center; clear: both; border-top: dotted 1px #E1E1E1;
> margin-top: 1.0em; margin-bottom: 1.5em; padding-top: 1.0em; }\n /*
> Search */\n input.button { background: #FF6C1F repeat-x; color: #fff;
> border: solid 1px #DB7623; font-weight: bold; font-size: 0.8em;
> height: 2.0em; }\n input.text { border: solid 1px #F1F1F1; font-size:
> 1.0em; padding: 0.25em 0.25em 0.25em 0.25em; }\n /* LAYOUT - 3 COLUMNS
> */\n /* Primary content */\n #primaryContent_3columns { position:
> relative; margin-right: 34em; }\n #columnA_3columns { position:
> relative; float: left; width: 100%; margin-right: -34em; padding-
> right: 2em; }\n /* Secondary Content */\n #secondaryContent_3columns
> { float: right; }\n #columnB_3columns { width: 13.0em; float: left;
> padding: 0em 2em 0.5em 2em; border-left: dotted 1px #E1E1E1; }\n
> #columnC_3columns { width: 13.0em; float: left; padding: 0em 0em 0.5em
> 2em; border-left: dotted 1px #E1E1E1; }\n /* LAYOUT - 2 COLUMNS */\n /
> * Primary content */\n #primaryContent_2columns { position: relative;
> margin-right: 17em; }\n #columnA_2columns { position: relative; float:
> left; width: 100%; margin-right: -17em; padding-right: 2em; }\n /*
> Secondary Content */\n #secondaryContent_2columns { float: right; }\n
> #columnC_2columns { width: 13.0em; float: left; padding: 0em 0em 0.5em
> 2em; border-left: dotted 1px #E1E1E1; }\n /* LAYOUT - COLUMNLESS */\n /
> * Primary content */\n #primaryContent_columnless { position:
> relative; }\n #columnA_columnless { position: relative; width: 100%; }
> \n</style>\n<script type="text/javascript">\n<!--\nfunction popitup
> (url) {\nnewwindow=window.open(url,\'name\',\'height=400,width=600\');
> \nif (window.focus) {newwindow.focus()}\nreturn false;\n}\nfunction
> collapse(name) { if\n(this.document.getElementById
> (name).style.display=="none")\n(this.document.getElementById
> (name).style.display="block") ;\nelse (this.document.getElementById
> (name).style.display="none") ; }\n//-->\n</script>\n</head>\n<body>
> \n<div id="header">\n <div id="header_inner" class="fixed">\n � <div
> id="logo">\n � � <h1><a href="">[web2py]</a></h1>\n
> <h2>',escape=False)
> response.write(request.application)
> response.write('</h2>\n � </div>\n � ',escape=False)
> if response.menu:
> � � response.write('\n � <div id="menu">\n � <ul>\n � �',escape=False)
> � � for _name,_active,_link in response.menu:
> � � � � response.write('\n � �<li><a href="',escape=False)
> � � � � response.write(_link)
> � � � � response.write('" ',escape=False)
> � � � � if not _active:
> � � � � � � response.write('class="inactive"',escape=False)
> � � � � � � pass
> � � � � response.write('>',escape=False)
> � � � � response.write(_name)
> � � � � response.write('</a></li>\n � �',escape=False)
> � � � � pass
> � � response.write('\n � </ul>\n � </div>\n � ',escape=False)
> � � pass
> response.write('\n �</div>\n</div>\n<div id="main">\n �<div
> id="main_inner" class="fixed">\n � �<div
> id="primaryContent_columnless">\n � � �<div id="columnA_columnless">
> \n � � � �',escape=False)
> if response.flash:
> � � response.write('\n � � � �<div id="flash">',escape=False)
> � � response.write(response.flash)
> � � response.write('</div>\n � � � �',escape=False)
> � � pass
> response.write('\n � � � �\n<h1>This is the test/show_periods.html
> template</h1>\n\n',escape=False)
> for period in periods:
> � � response.write('\n � �<TR>',escape=False)
> � � period
> � � response.write('</TR>\n � ',escape=False)
> � � subperiods = db(db.subperiod.period=period.id).select()
> � � response.write('\n � � ',escape=False)
> � � for subperiod in subperiods:
> � � � � response.write('\n � � � � <TR>',escape=False)
> � � � � subperiod
> � � � � response.write('</TR>\n � � � � �',escape=False)
> � � � � pass
> � � response.write('\n � �',escape=False)
> � � pass
> response.write('\n\n � � �</div>\n � �</div>\n � �<div id="footer"
> class="fixed">\n � � �© 2007, web2py Web Framework created by
> Massimo Di Pierro\n � �</div>\n �</div>\n</div>\n</body>\n</html>
> \n',escape=False)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
