Re: Trouble supporting mixed case entities.
Gerhard Häring <[email protected]>
| Newsgroups | gmane.comp.python.db.pypgsql.user |
|---|---|
| Organization | People's Front of Judea |
| Message-ID | <[email protected]> |
* Benjamin Scherrey <[email protected]> [2003-03-31 18:45 -0500]: > [...] > cstmt = r"""create table "Test" ( "FName" varchar(20), "LName" varchar(20) )""" > istmt = r"""insert into "Test" values ( 'Benjamin', 'Scherrey' )""" > sstmt = r"""select "FName", "LName" from "Test" """ > [...] > > print res["fname"] > print res["lname"] If you use quotes around SQL identifiers, case matters. Try: print res["FName"], res["LName"] or even: print res.FName, res.LName Gerhard -- mail: [email protected] web: http://ghaering.de/ ------------------------------------------------------- This SF.net email is sponsored by: ValueWeb: Dedicated Hosting for just $79/mo with 500 GB of bandwidth! No other company gives more support or power for your dedicated server http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/