Thanks, James, but John Gordon identified my usage error so I'm good to go now.
On Mon, 14 May 2012 09:28:06 -0700 (PDT), james hedley <jameskhed...@gmail.com> wrote: >On Monday, 14 May 2012 17:01:49 UTC+1, Steve Sawyer wrote: >> Brand-new to Python (that's a warning, folks) >> >> Trying to write a routine to import a CSV file into a SQL Server >> table. To ensure that I convert the data from the CSV appropriately, >> I"m executing a query that gives me the schema (data column names, >> data types and sizes) from the target table. >> >> What I think I want to do is to construct a dictionary using the >> column names as the index value, and a list containing the various >> attributes (data type, lenghth, precision). >> >> If this is NOT a good approach (or if there is a better approach), >> please issue a dope-slap, ignore the rest of this post and set me >> straight. >> >> If this is a good approach, I ran into a problem populating the >> dictionary as I couldn't seem to figure out how to make the update() >> method work by passing the name property of the row object; I kept >> getting a "keyword can't be an expression" error. >> >> What I was able to make work was to construct the command as a string >> and run exec( >> ), but seems there shoudl be a more >> direct way of updating the dictionary. >> >> TIA. > >Could you provide some demo code? Something minimal but runnable, which >results in the error you're getting would be best. --Steve-- -- http://mail.python.org/mailman/listinfo/python-list
