#!C:/Python20/python.exe
#
import mx.ODBC.Windows as odbc
from jetCursor import jetCursor
import urllib
print """Content-Type: text/html\n
<HTML>
<HEAD>
<TITLE>Min-Web Page List</TITLE>
</HEAD>
<BODY>"""
cn = odbc.connect("WebData")
cr = jetCursor(cn.cursor(), cn)
sql = cr.SELECT("PgName", FROM="PgData")
cr.execute(sql)
data = cr.fetchall()
cr.close()
cn.close()
print """<P>Click the page name to show data in an edit form<BR>"""
for d in data:
PgName = d[0]
print """
<A HREF="thisFile.py?PgName=%s">%s</A><BR>""" %Â
(urllib.quote(PgName), PgName)
print """<BR>
<A HREF="thisFile.py">Create New Page</A><BR>
</BODY>
</HTML>
"""
|