I'm trying to build a mini-CMS for my class to manage a single
webpage, using CGI and mysql. The children will be storing their main
content in a BLOB within a Mysql database.

When I query the content column, I get a strange return like this:

array('c', 'This is a test ')

- when the only text I entered in was 'This is a test'.

When I query mysql directly through a prompt, I get 'This is a test'.

Does a CGI query get mangled text from a blob? My other VARCHAR
columns are fine.

Code:

def query(statement):
    results = []
    mycursor.execute(statement)
    myrowcount = int(mycursor.rowcount)
    for i in range (0, myrowcount):
        myrow = mycursor.fetchone()
        results.append(myrow)
    return results

reportquery = "select id, title, content, published from report"
reportlist = query(reportquery)
print "<p> " + str(reportlist) + "</p>"


id = primary key, integer, not null
title = varchar(255)
content = blob
published = char(1), default ='n'

I've tried using looking at
reportlist[0][2][1], but that just returns 'T' - which is obviously
the T in 'This'.

TIA
Adam
--
http://www.monkeez.org
PGP key: 0x7111B833
_______________________________________________
Tutor maillist  -  Tutor@[...].org
http://mail.python.org/mailman/listinfo/tutor