On Wed, Nov 11, 2009 at 1:20 PM, Benjamin Kaplan
<benjamin.kap...@case.edu>wrote:
> On Wed, Nov 11, 2009 at 11:42 AM, Victor Subervi
> <victorsube...@gmail.com> wrote:
> > On Wed, Nov 11, 2009 at 11:23 AM, Rami Chowdhury <
> rami.chowdh...@gmail.com>
> > wrote:
> >>
> >> On Wed, 11 Nov 2009 06:00:44 -0800, Victor Subervi
> >> <victorsube...@gmail.com> wrote:
> >>
> >>> On Tue, Nov 10, 2009 at 4:33 PM, Dave Angel <da...@ieee.org> wrote:
> >>>
> >>>> Victor Subervi wrote:
> >>
> >>>> Wrong?
> >>>> 2) you don't show the error traceback
> >>>>
> >>> because there are none
> >>>
> >>> try: # It does this, because I've printed 'getpic1.py' etc.
> >>> getpic = "getpic" + str(w) + ".py"
> >>> try:
> >>> os.remove(getpic)
> >>> except:
> >>> pass
> >>
>
Ok, I rewrote the script so that it calls one file called "getpic.py" with
parameters:
#! /usr/bin/python
import cgitb; cgitb.enable()
import MySQLdb
import cgi
import sys,os
sys.path.append(os.getcwd())
from login import login
form = cgi.FieldStorage()
w = form.getfirst('w', '')
i = form.getfirst('i', '')
def pic():
user, passwd, db, host = login()
form = cgi.FieldStorage()
db = MySQLdb.connect(host, user, passwd, db)
cursor= db.cursor()
sql = "select pic%s from products where ID=%s;" % (w, i)
cursor.execute(sql)
content = cursor.fetchone()[0]
cursor.close()
print content
print 'Content-type: image/jpeg'
print
pic()
Now, the problem is that it doesn't print the picture. It prints only the
url. Please try:
http://angrynates.com/stcroixresort/cart/getpic.py?w=1&i=1
Now, if I go into mysql and the correct database and enter:
select pic1 from products where ID=1;
it starts printing out all sorts of crap (indicative of an image) and I have
to close my ssh client. So it's there, all right. So, here I am back to
trying to figure out how to get that stupid image to print. Please take a
look at the code above and advise.
TIA,
V
--
http://mail.python.org/mailman/listinfo/python-list
