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
