Daniel Fimiarz - 2009-09-15

Hello,

For some reason feeding this query to executemany function:

> """insert into my_table values

> (null,now(),%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,1,'','',0,%s)"&qu
ot;"

throws

> not all arguments converted during

> string formatting

Changing now() to 'now' or 'now()' inserts the data but with incorrect value
(defaults to default date)

It seems that executemany doesn't like the NOW() part of the query.

Given the number of mysql functions out there I doubt functions like that are
not supported. Is there a way to escape the '()' somehow?

Thanks,