Deformed Form

Fri Jun 11 15:11:28 EDT 2010

Ok. Starting over. Here is the script that "generates" the variable
"new_passengers_curr_customers":

#!/usr/bin/python

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

def create_edit_passengers():
  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()
  flight = form.getfirst('flight')
  try:
    cursor.execute('select c.id, p.name, p.weight, c.first_name,
c.middle_name, c.last_name, c.suffix from Passengers p join Customers c
where p.flights_id=%s;', flight)
    passengers = cursor.fetchall()
  except MySQLdb.ProgrammingError:
    passengers = []
  cursor.execute('select * from Flights where id=%s;', flight)
  flight_data = cursor.fetchone()
  print "<b>You have selected flight #%s, departing %s from %s and arriving
%s at %s.</b><br /><br />" % (flight_data[0], flight_data[2],
flight_data[5], flight_data[3], flight_data[6])
  if len(passengers) > 0:
    print '<form method="post" action="create_edit_passengers3.py">\n'
    Curr_Passengers_Table(passengers)
    print "<h2>Add Passengers</h2>"
  else:
    print "There are currently no passengers enrolled in this flight. Please
enter some."
    print '<form method="post" action="create_edit_passengers3.py">\n'

*** RIGHT HERE! ***

  print "<input type='text' size='2' maxlength='2'
name='new_passengers_curr_customers' /><br />"
                                                         ^^^^^
*** SEE IT? ***

  print "<input type='submit' value=' Send ' />"
  print '</body>\n</html>'
  cursor.close()

create_edit_passengers()

Now, here's the form that *should* be able to access that variable:

!/usr/bin/python

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

form = cgi.FieldStorage()

def sortedDictValues(adict):
  items = adict.items()
  items.sort()
  return [value for key, value in items]

def create_edit_passengers3():
  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()
  cursor.execute('select id from Flights;')
  flights = [itm[0] for itm in cursor]
  cursor.execute('select id, first_name, middle_name, last_name, suffix from
Customers;')
  customers = cursor.fetchall()
  try:
    cursor.execute('select p.id, c.first_name, c.middle_name, c.last_name,
c.suffix, c.discount, p.flights_id, p.name, f.price, c.id from Customers c
join Passengers p on c.id=p.customer_id join Flights f on p.flights_id=f.id
;')
    passengers = cursor.fetchall()
    print '<form method="post" action="create_edit_passengers4.py">\n'
    start_html = "<table border='2'>\n  <tr>\n
<td><b>Delete?</b></td>\n    <td><b>Flight</b></td>\n
<td><b>Name</b></td>\n    <td><b>Discount</b></td>\n
<td><b>Price</b></td>\n  </tr>\n"
    passengers_html = []
    ids = []
    i = 0
    for passenger in passengers:
      do_delete = form.getfirst('%s:delete' % passenger[0])
      passengers_html, i = New_Passenger(passengers_html, passenger,
do_delete, flights, ids, i)
    printHTML = sortedDictValues(dict(zip(ids, passengers_html)))
    if len(printHTML) > 0:
      print start_html
    for html in printHTML:
      print html
    print "</table>"
  except MySQLdb.ProgrammingError:
    pass

*** NOTE THIS: ****
  new_passengers_curr_customers = New_Passengers_Curr_Customers(customers,
flights)
*** THAT LINE ****

  if new_passengers_curr_customers > 0:
    print "<input type='submit' value=' Send ' />"
  print '</body>\n</html>'
  cursor.close()

create_edit_passengers3()

See that line that I marked right at the end? So here's that script:

#!/usr/bin/python

import cgitb; cgitb.enable()
import cgi

form = cgi.FieldStorage()

def New_Passengers_Curr_Customers(customers, flights):

*** RIGHT HERE. SEE THIS LINE? WHY DOES IT WORK HERE AND NOT IN THE 2ND
SCRIPT IN THIS HERE EMAIL WHERE IT SHOULD WORK???***
  new_passengers_curr_customers =
int(form.getfirst('new_passengers_curr_customers', 0))
*** THAT LINE ABOVE. RIGHT ABOVE HERE. OK?? ***

  print "<input type='hidden' name='new_passengers_curr_customers'
value='%d' />" % new_passengers_curr_customers
  if new_passengers_curr_customers > 0:
    print "<table border='1'>\n"
    print "  <tr>\n    <td colspan='2' align='center'><b>From Current
Customers</b></td>\n  </tr>"
    print "  <tr>\n    <td><b>Flight</b></td>\n
<td><b>Customer</b></td>\n  </tr>"
  i = 0
  while i < new_passengers_curr_customers:
    print "  <tr>"
    print "    <td><select name='%d:curr:flight'>" % i
    for flight in flights:
      print "      <option>%s</option>" % flight
    print "    </select></td>"
    print "    <td><select name='%d:curr:customer'>" % i
    for customer in customers:
      print "      <option value='%s'>%s %s %s %s</option>" % (customer[0],
customer[1], customer[2], customer[3], customer[4])
    print "    </select></td>"
    print "  </tr>"
    i += 1
  if new_passengers_curr_customers > 0:
    print "</table>"
  return new_passengers_curr_customers

Ok. So I think that was clear now.
TIA,
beno
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20100611/c0f85edc/attachment-0001.html>