python - string conversion

Question

I know, the title to this question is vague, but I don't really know how else to describe it. Here's what I'm trying to do though.

I'm using pyodbc to query a database, and I want to allow the user to specify a column, and for my code to fetch it dynamically. In other words, I need to do something like this:

row_id = "row.%s" % id_column

Of course, this returns a string. What pyodbc is expecting is a variable/property, like so:

row_id = row.id

Could someone please tell me how to do this? I tried searching for "python string to val" but all those pages tell me how to convert a string to an int- which is different than what I'm trying to do.

Can you provide a longer sample from your code? Also consider looking at: code.google.com/p/pyodbc/wiki/Rows. — selllikesybok
– selllikesybok, Commented Jul 16, 2012 at 21:14

Paolo Bergantino · Accepted Answer · 2012-07-16 20:45:14Z

6

You are looking for getattr:

row_id = getattr(row, id_column)

answered Jul 16, 2012 at 20:45

Paolo Bergantino

490k83 gold badges523 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

starenka · Accepted Answer · 2012-07-16 20:46:11Z

1

You mean something like:

getattr(row,'id')

or maybe I don't really get what you want to do...

answered Jul 16, 2012 at 20:46

starenka

5803 silver badges9 bronze badges

Collectives™ on Stack Overflow

python - string conversion

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related