Think I managed to solve it using:-
print '<p><a href="view.cgi?id=%i">%s</a></p>' % (row[0], row[1])
Paul
Paul Issott wrote:
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.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------