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@python.org
http://mail.python.org/mailman/listinfo/tutor
