Hello,
For my application, I would like to execute an SQL query like this:
self.dbCursor.execute(INSERT INTO track (name, nbr, idartist, idalbum,
path) VALUES ('%s', %s, %s, %s, '%s') % (track, nbr, idartist,
idalbum, path))
where the different variables are returned by the libtagedit python
[EMAIL PROTECTED] wrote:
Hello,
For my application, I would like to execute an SQL query like this:
self.dbCursor.execute(INSERT INTO track (name, nbr, idartist, idalbum,
path) VALUES ('%s', %s, %s, %s, '%s') % (track, nbr, idartist,
idalbum, path))
No, I'll bet that you'd like to run
[EMAIL PROTECTED] wrote:
I tried to encode the different variables in many different encodings
(latin1), but I always get an exception. Where does this ascii codec
error comes from? How can I simply build this query string?
Raphael,
The 'ascii' encoding is set in the python library file
Jim wrote:
[EMAIL PROTECTED] wrote:
Hello,
For my application, I would like to execute an SQL query like this:
self.dbCursor.execute(INSERT INTO track (name, nbr, idartist, idalbum,
path) VALUES ('%s', %s, %s, %s, '%s') % (track, nbr, idartist,
idalbum, path))
No, I'll bet that you'd
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
I tried to encode the different variables in many different encodings
(latin1), but I always get an exception. Where does this ascii codec
error comes from? How can I simply build this query string?
Raphael,
The 'ascii' encoding is set
John Machin wrote:
Jim wrote:
No, I'll bet that you'd like to run something like
self.dcCursor.execute(INSERT INTO track (name, nbr, idartist,
idalbum,path) VALUES (%(track)s, %(nbr)s,
%(idartist)s,%(idalbum)s,'%(path)s'),
Jim wrote:
John Machin wrote:
Jim wrote:
No, I'll bet that you'd like to run something like
self.dcCursor.execute(INSERT INTO track (name, nbr, idartist,
idalbum,path) VALUES (%(track)s, %(nbr)s,
%(idartist)s,%(idalbum)s,'%(path)s'),