500 Internal ... not the same of Dan

[mk_999 at my-deja.com]

Well, I'm a newbie of Python
and reading always this message is frustrating, because there is no
error in my code (I suppose).

I wrote a little code to upload files and register data on a database
(Oracle 8.0.4) using DCOracle. (plus Apache Web Server on Linux)

Sometimes doing this operation it shows me that message (INTERNAL SERVER
ERROR), but it works!!!!! if I control in the destination directory the
file is uploaded and in the database a new record is regularly
registered.

Refreshing the page, sometimes it shows the correct page, others not,
but it always add new records.

I used traceback (not so usefull in this case), and verified syntax on
command line (it seems all right).

I would be glad if someone showed me which way I can follow to solve
this problem.

There could be something wrong about the SQL, but why does it execute
the code anyway?!?

Here there is the function used to connect

def db_update(product, title, author, descr, path):
	try:
		dbc=DCOracle.Connect("***/***@***")
		if dbc:
			cur=dbc.cursor()  #get cursor
			if cur:
				stm = "INSERT INTO dev.procedure VALUES ( '%s', '%s', '%s', '%s',
TO_DATE(sysdate,'DD-MM-RRRR') ,'%s')" % (prodotto, title, author, descr,
path)
				#print stm
				cur.execute(stm)
			else:
				print 'Invalid SQL statement'

			cur.close()
			dbc.close()
		else:
			print 'Unable to connect to db'

	except:
		print 'Error on connection'
		if dbc:
			if cur:
				cur.close()
			dbc.close()


Sent via Deja.com http://www.deja.com/
Before you buy.