List Mini-Web Pages with Editing Links

List Mini-Web Pages with Editing Links : ODBC : Database PYTHON examples

PYTHON examples » Database » ODBC »

List Mini-Web Pages with Editing Links



 #!C:/Python20/python.exe
 #
 import mx.ODBC.Windows as odbc
 from jetCursor import jetCursor
 import urllib

 print """Content-Type: text/htmln
 <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>
 """