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]
-----------------------------------------------------------------------------

Reply via email to