[sqlite] Passing parameters Python and CGI

[Paul Issott]

Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using
CREATE TABLE messages (
id           INTEGER PRIMARY KEY,
subject    TEXT
)

Populated it with a few lines and one of the row of rows is (1, u'News') 
after:-
rows = curs.fetchall()

How do I pass these parameters in a cgi script, for instance I've tried 
using:-

print '<p><a href="view.cgi?id=row[0]">row[1]</a></p>'

which only prints _row[1]_  instead of  _News_
and probably doesn't set the id either.

Thanks for any help.