I'm fairly new to SQLObject and Python for that fact.  I've poured over a
few python tutorials and actually read the SQLObject docs.  I feel brassy
enough to try a small program but I'm stuck before get started.

Here's what I have installed (all from RPMs):
RedHat 9
python 2.3
SQLObject 5.1
MySQL 3.23.58
MySQL-Python

Here's the code I put together:

from SQLObject import *

_connection_ = MySQLConnection(host="localhost", user="xxxx",
passwd="zzzz", db="ReportDR")


class ProcReport(SQLObject):
        _table = "procReport"

        #db columns
        sourceOrg = StringCol(length=10)
        mrn = StringCol(length=10)
        lastName = StringCol(length=10)
        firstName = StringCol(length=10)
        middleName = StringCol(length=10)
        dateOfBirth = DateTimeCol(default=None)
        gender = StringCol(length=1, default=None)
        orderingMd = StringCol(length=20)
        procDesc = StringCol(length=20)
        srvDateTime = DateTimeCol(default=None)
        readingMd = StringCol(length=20)
        reportText = StringCol()
        reportHtml = StringCol()
        reportSource = StringCol()


#create the table
ProcReport.createTable()

When I run this, I get

Traceback (most recent call last):
  File "_ProcReport.py", line 33, in ?
    ProcReport.createTable()
  File "/usr/lib/python2.3/site-packages/SQLObject/SQLObject.py", line
965, in createTable
    cls._connection.createTable(cls)
AttributeError: 'NoneType' object has no attribute 'createTable'

Any ideas?  I've even tried to run the people.py example from the 5.1
tarball with the following results:

#python2.3 people.py create
Traceback (most recent call last):
  File "people.py", line 96, in ?
    table.createTable(ifExists=True)
TypeError: createTable() got an unexpected keyword argument 'ifExists'


And the tutorials made it look so darn easy....
--
Scott LeFevre Signature
Scott LeFevre, Consultant
Solutio Informatio
t: 317/696-1010