Strange MySQL Problem

Thu May 20 12:26:24 EDT 2010

Hi;
I have this code:

#!/usr/bin/python

import cgitb; cgitb.enable()
import cgi
import sys,os
sys.path.append(os.getcwd())
import MySQLdb
from login import login

def create_edit_passengers4():
  print "Content-Type: text/html"
  print
  print '''
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<head xmlns="http://www.w3.org/1999/xhtml">
</head>
<body>
'''
  user, passwd, db, host = login()
  database = MySQLdb.connect(host, user, passwd, db)
  cursor = database.cursor()
  form = cgi.FieldStorage()
  cursor.execute('create table if not exists Passengers (id int(11)
auto_increment primary key, flights_id int(11) not null, customer_id int(11)
not null, foreign key (id) references Flights (flights_id), foreign key (id)
references Customers (customer_id), name varchar(40), weight int)
engine=InnoDB;')
  new_passengers = int(form.getfirst('new_passengers'))
  i = 0
  while i < new_passengers:
    cursor.execute('insert into Passengers values (Null, %s, %s, "%s", %s);'
% (form.getfirst('%d:flight' % i), form.getfirst('%d:customer' % i),
form.getfirst('%d:name' % i, ''), form.getfirst('%d:weight' % i)))
    i += 1
  print "All passenger information has successfully been added."
  cursor.close()
  print "</body>\n</html>"

create_edit_passengers4()

Now, it throws no errors; however, it doesn't insert. If I print out the
insert statement to screen and then manually insert it in MySQL it inserts.
Huh??
TIA,
beno
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20100520/7364de22/attachment.html>