<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >Tips and tricks</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="The knoda scripting tutorial" HREF="index.html"><LINK REL="PREVIOUS" TITLE="hk_database" HREF="hk_database.html"><LINK REL="NEXT" TITLE="How to execute a query" HREF="querydata.html"><META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css"><LINK REL="stylesheet" HREF="common/kde-common.css" TYPE="text/css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META HTTP-EQUIV="Content-Language" CONTENT="en"><LINK REL="stylesheet" HREF="common/kde-localised.css" TYPE="text/css" TITLE="KDE-English"><LINK REL="stylesheet" HREF="common/kde-default.css" TYPE="text/css" TITLE="KDE-Default"></HEAD ><BODY CLASS="CHAPTER" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#AA0000" VLINK="#AA0055" ALINK="#AA0000" STYLE="font-family: sans-serif;" ><DIV CLASS="logoheader" ><A HREF="http://www.kde.org/" ></A ></DIV ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >The knoda scripting tutorial</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="hk_database.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="querydata.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="CHAPTER5" ></A >Chapter 5. Tips and tricks</H1 ><P ></P ><DIV CLASS="SECTION" ><H1 CLASS="SECTION" ><A NAME="SHOWDATA" ></A >5.1. How to display the data</H1 ><P ><DIV CLASS="EXAMPLE" ><HR><A NAME="AEN434" ></A ><P ><B >Example 5-1. Show data</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><PRE CLASS="PROGRAMLISTING" > 1 horst@horstnotebook:~> python 2 Python 2.2.2 (#1, Mar 17 2003, 15:17:58) 3 [GCC 3.3 20030226 (prerelease) (SuSE Linux)] on linux2 4 Type "help", "copyright", "credits" or "license" for more information. 5 >>> from hk_classes import * 6 >>> dr=hk_drivermanager() 7 >>> con=dr.new_connection("mysql") 8 >>> con.set_password("secret") 9 >>> con.connect() 10 1 11 >>> db=con.new_database("exampledb") 12 >>> table=db.new_table("authors") 13 >>> i=0 14 >>> table.enable() 15 SQL : SELECT * FROM `authors` 16 1 17 >>> table.goto_first() 18 1 19 >>> while i< table.max_rows(): 20 ... table.show_currentrow() 21 ... table.goto_next() 22 ... i=i+1 23 ['1', 'Goethe,Johann Wolfgang', '1749', '1832', 'FALSE'] 24 1 25 ['2', 'Schiller, Friedrich von', '1759', '1805', 'TRUE'] 26 1 27 ['3', 'Lessing, Gotthold Ephraim', '1729', '1781', 'TRUE'] 28 1 29 ['4', 'Kleist', '1400', '0', 'FALSE']</PRE ></TD ></TR ></TABLE ><HR></DIV ></P ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="hk_database.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="querydata.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >hk_database</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >How to execute a query</TD ></TR ></TABLE ></DIV ></BODY ></HTML >