On Tuesday, June 18, 2013 10:10:42 AM UTC-4, upper...@gmail.com wrote: > I am new to python and struggling with creating a dynamic if statement. > > > > I have a set of queries that are run against various databases/tables. The > result is all the same in that I always get back the same field names. > > > > What I want to do is total the results differently based on the table. so for > instance > > > > I query fld1, fld2, fld3, qty, qty2 from table1 > > then I loop thru the results > > if fld1 = 'a' add qty to some_total1 > > > > I query fld1, fld2, fld3, qty, qty2 from table2 > > then I loop thru the results > > if fld2 = 'b' add qty to some_total1 > > > > I query fld1, fld2, fld3, qty, qty2 from table3 > > then I loop thru the results > > if fld3 = 'c' add qty2 to some_total1 > > > > I created a database pair that contains (table1,fld1 = 'a',add qty to > some_total1) > > (table2,fld2 = 'b',qty to some_total1) > > (table3,fld3 = 'c',qty2 to some_total1) > > > > So I know which table I am using, I query my list pair but I cant see how to > build the if statement using the results from the query. > > > > something like this would be the result > > var1 = "fld1 = 'a'" > > result = "add qty to some_total1" > > > > if var1: > > result
thanks for the help.. with a bit of tweaking i got it working as needed -- http://mail.python.org/mailman/listinfo/python-list
