Never mind. It appears my old original file from a couple of years ago prints out the image nicely. Thanks all!<br>V<br><br><div class="gmail_quote">On Wed, Nov 11, 2009 at 2:26 PM, Victor Subervi <span dir="ltr"><<a href="mailto:victorsubervi@gmail.com">victorsubervi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote">On Wed, Nov 11, 2009 at 1:20 PM, Benjamin Kaplan <span dir="ltr"><<a href="mailto:benjamin.kaplan@case.edu" target="_blank">benjamin.kaplan@case.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Wed, Nov 11, 2009 at 11:42 AM, Victor Subervi<br>
<<a href="mailto:victorsubervi@gmail.com" target="_blank">victorsubervi@gmail.com</a>> wrote:<br>
> On Wed, Nov 11, 2009 at 11:23 AM, Rami Chowdhury <<a href="mailto:rami.chowdhury@gmail.com" target="_blank">rami.chowdhury@gmail.com</a>><br>
> wrote:<br>
>><br>
>> On Wed, 11 Nov 2009 06:00:44 -0800, Victor Subervi<br>
>> <<a href="mailto:victorsubervi@gmail.com" target="_blank">victorsubervi@gmail.com</a>> wrote:<br>
>><br>
>>> On Tue, Nov 10, 2009 at 4:33 PM, Dave Angel <<a href="mailto:davea@ieee.org" target="_blank">davea@ieee.org</a>> wrote:<br>
>>><br>
>>>> Victor Subervi wrote:<br>
>><br>
>>>> Wrong?<br>
>>>> 2) you don't show the error traceback<br>
>>>><br>
>>> because there are none<br>
<div>>>><br>
>>> try: # It does this, because I've printed 'getpic1.py' etc.<br>
>>> getpic = "getpic" + str(w) + ".py"<br>
>>> try:<br>
>>> os.remove(getpic)<br>
>>> except:<br>
>>> pass<br>
>><br></div></blockquote><div><br>Ok, I rewrote the script so that it calls one file called "getpic.py" with parameters:<br><br>#! /usr/bin/python<br>import cgitb; cgitb.enable()<br>import MySQLdb<br>import cgi<br>
import sys,os<br>sys.path.append(os.getcwd())<br>from login import login<br>form = cgi.FieldStorage()<br>w = form.getfirst('w', '')<br>i = form.getfirst('i', '')<br>def pic():<br> user, passwd, db, host = login()<br>
form = cgi.FieldStorage()<br> db = MySQLdb.connect(host, user, passwd, db)<br> cursor= db.cursor()<br> sql = "select pic%s from products where ID=%s;" % (w, i)<br> cursor.execute(sql)<br> content = cursor.fetchone()[0]<br>
cursor.close()<br> print content<br>print 'Content-type: image/jpeg'<br>print<br>pic()<br><br>Now, the problem is that it doesn't print the picture. It prints only the url. Please try:<br><a href="http://angrynates.com/stcroixresort/cart/getpic.py?w=1&i=1" target="_blank">http://angrynates.com/stcroixresort/cart/getpic.py?w=1&i=1</a><br>
Now, if I go into mysql and the correct database and enter:<br>select pic1 from products where ID=1;<br>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.<br>
TIA,<br>V<br></div></div>
</blockquote></div><br>