<head><title>Secondary Sources</title>
</head>
<body bgcolor=white>
<HR>
<H2>School Registration</H2>
<HR>
<H4>You have successfully registered yourself with SecondarySources.com</H4>
return to
<A HREF="/project/front.py">main page.</A>
<HR>
</BODY>
</HTML>'''
#####################################################################
db = Ns.DbHandle(Ns.DbPoolDefault(conn.Server()))
html = displayify.displayify(html,db)
del db
conn.ReturnHtml(200, html)
<TR><TD>office: %s<BR>mobile: %s<BR>fax: %s</TD></TR>
<TR><TD><ADDRESS><A HREF="mailto:%s">%s</TD></TR>""" % (list.Get('last_name'),
list.Get('first_names'),
school,
list.Get('street_address'),
list.Get('city'),
list.Get('state'),
list.Get('zipcode'),
list.Get('office_phone'),
list.Get('mobile_phone'),
list.Get('fax'),
list.Get('email'),
list.Get('email'))
html = displayify(content,db)
del db
conn.ReturnHtml(200,html)
ORDER BY
content.date_posted DESC"""
try:
db = Ns.DbHandle(Ns.DbPoolDefault(conn.Server()))
except:
conn.ReturnRedirect("error_page")
most_recently_updated = rowify(db, all_updates_query_string)
### TODO:
### -keep the school in a TD that spans all the appropriate team *rows*
### -also, make sure updates from last seven days are displayed in red
html = displayify(most_recently_updated, db)
## '''<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
## <html> <head>
## <title>Secondary Sources Caselist - Updates from last 7 days</title>
## </head>
## <body bgcolor=white>
## <table width=100\% align="center">
## <tr>
## <td width=10\% rowspan=10 valign=top>
## Someday,
## <p>
## There will be nothing but links
Comment
</Th>
<Th width=5\%>
Posted on
</th>
</tr>""" + content
###this is debugging stuff, uncomment to use
#Ns.Log(Ns.Notice,"------------- for query string:\n%s\n---------------------------team info: \n%s" % (team_query_string,team_caselist_info))
###todo:
#team_comments = sidebarify(db, comment_string)
###here's the page itself
html = displayify(team_comment_info, db)
###close up the connection in case it's hanging around. This should be unnecessary.
del db
###here's the web page that gets generated.
conn.ReturnHtml(200, html)
</th>
<Th width=60\%>
<p>Comments<p><p>
</Th>
<Th width=5\%>
<p>---<p>
</th>
</tr>
''' + this_team_comments
###this is debugging stuff, uncomment to use
#Ns.Log(Ns.Notice,"------------- for query string:\n%s\n---------------------------team info: \n%s" % (team_query_string,team_caselist_info))
###here's the call to displayify which returns the html
html = displayify(team_caselist_info, db)
###close up the connection in case it's hanging around. This should be unnecessary.
del db
###here's the aolserver command to send the page to the browser
conn.ReturnHtml(200, html)
<Th width=60\%>
Case
</Th>
<Th width=5\%>
Updated on
</th>
</tr>""" + most_recently_updated + '''
<tr>
<th colspan=4 valign="bottom" align=left>
<h3>Full Caselist</h3>
</th>
</tr>''' + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list + whole_list
html = displayify(content, conn)
conn.ReturnHtml(200, html)
### TODO:
### -keep the school in a TD that spans all the appropriate team columns
### -also, make sure updates from last seven days are displayed in red