formating query with empty parameter

[someone]

Hello!

if one of parameter in values is empty, I'm getting
TypeError: not enough arguments for format string

But how to handle such situation? It is ok for DB, that some of values
are empty.



def __insert(self, data):
        query = """
            BEGIN;
                INSERT INTO table
                    (a,  b,  c,  d,  e,  f,  g)
                    VALUES
                    (%s, %s, %s, %s, %s, %s, %s);
            COMMIT;
            """
        values = [
            data['a'],
            data['b'],
            data['c'],
            data['d'],
            data['e'],
            data['f'],
            data['g']
            ]
        self.db.execute(query, *values)



Thanks Pet
-- 
http://mail.python.org/mailman/listinfo/python-list