Where's the List?

[Peter Otten]

Victor Subervi wrote:

> Where's the list? They're both tuples in that last line of code.

>     for order in order_details:
>       store = order[0]
>       prodid = order[1]
>       pkg = order[2]
>       quantity = order[3]
>       if 'PatientID' in order_fields:
>         patientID = order[4]
>         try:
>           option_values = order[5:]
>         except TypeError:
>           option_values = []

Here...

>         sql = 'insert into orders%s values (Null, %s)' % (store, ",
> ".join("%s" * (4 + len(option_values))))
>         cursor.execute(sql, tuple([pkg, prodid, tmpTable, quantity] +
> option_values))
>       else:
>         patientID =  ''
>         try:
>           option_values = order[4:]
>         except TypeError:
>           option_values = []

there...

>         sql = 'insert into orders%s values (Null, %s)' % (store, ",
> ".join("%s" * (4 + len(option_values))))
> #        cursor.execute(sql, tuple([pkg, prodid, tmpTable, quantity,
> order[4], order[5]]))
>         cursor.execute(sql, tuple([pkg, prodid, tmpTable, quantity] +
> option_values))
> 
> It throws this error:
> 
> *TypeError*: can only concatenate list (not "tuple") to list
>       args = ('can only concatenate list (not "tuple") to list',)

everywhere?