Re: Trouble supporting mixed case entities.
Benjamin Scherrey <[email protected]>
| Newsgroups | gmane.comp.python.db.pypgsql.user |
|---|---|
| Organization | Proteus Technologies, Inc. |
| Message-ID | <SR75QLTP53PSR4Y84SQJA8DBDZV82.3e88e00a@BONZO> |
Ah!! Once again I outsmarted myself by insisting on quoting out the quotes... this python's stuff too smart for my own good... :-) many thanx, Ben Scherrey 3/31/2003 7:35:44 PM, Gerhard Häring <[email protected]> wrote: >* 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 ------------------------------------------------------- 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/