[Tutor] Read only buffer tuple ? [data structures / close()ing a file]

Danny Yoo dyoo@hkn.eecs.berkeley.edu
Fri May 23 00:24:15 2003


> What we may want to do, then, is just extract the first element of the
> row:
>
>
> ###
> sql = "SELECT message FROM email WHERE emailid='%s'" % (rows[0])
> result_set = con1.query(sql).getresult()
> first_row = msg[0]
              ^^^^^^
> first_message = first_row[0]
> ###

*cough* Doh.  Um... I meant,



###
sql = "SELECT message FROM email WHERE emailid='%s'" % (rows[0])
result_set = con1.query(sql).getresult()
first_row = result_set[0]
first_message = first_row[0]
###


Sorry about the mistake; it's hard to test pseudocode.  *grin*