Error inserting data in playlist

[prettypython]

Hi went i add things into my database such as:

(file name, file path etc)
into the database sqlite

either i got:
sqlite3.Operati onalError: no such column:
or
sqlite3.Operati onalError: unrecognized token: ":"
when insert path (e.g. 'D:\music\blue. mp3'


Anyone knows how can solve this?

[bvdet]

Try escaping the backslashes as in "\\", pass the raw string as in r"D:\music\blue .mp3", or use forward slashes instead of backslashes.

[Rabbit]

It would help to see the code you're using along with a description of the table design.

[prettypython]

This is the table.

[Rabbit]

Please respond to the first half of my post.