Diez B. Roggisch
deets at nospam.web.de
Tue May 23 13:36:10 CEST 2006
Harlin Seritt wrote:
> I have this string that I am sending via a Cursor.execute() using
> insert into table Ping82_eb13__elearn__ihost__com (`dateTime`,
> `values`) values(
> "Fri May 12 11:39:02 2006", "1")
> Does anyone see anything wrong with this SQL syntax?
How about a stacktrace?
And you should use the parametrized version of execute, because then the
DB-API will take care of escaping the strings properly for you. Which is
the problem here, btw: you are using "" for strings, where SQl requires ''.
More information about the Python-list