[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok-bugs-dist
Subject:    [Bug 147398] New: DCOP SQLite Queries and Single Quotes
From:       Sebastien <slaout () linux62 ! org>
Date:       2007-06-30 14:23:24
Message-ID: 20070630162323.147398.slaout () linux62 ! org
[Download RAW message or body]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=147398         
           Summary: DCOP SQLite Queries and Single Quotes
           Product: amarok
           Version: unspecified
          Platform: Ubuntu Packages
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: amarok-bugs-dist kde org
        ReportedBy: slaout linux62 org


Version:            (using KDE KDE 3.5.7)
Installed from:    Ubuntu Packages

I have a song with an apostroph in its name:
Artist: "Adema"
Album: "Insomniac's Dream EP"

To get the full-size cover image, I use that SQLite/DCOP command:

dcop amarok collection query "SELECT path FROM images WHERE artist='Adema' AND \
album='Insomniac\'s Dream EP'"

I rightly escaped the apostroph, but this query returns no result at all.

I also typed that command in KDCOP and in C++, tryed escaping with "\\'" or "\\\'" \
(one never know), but there is still no result.

If I use double-quotes instead of single-quotes in the SQL syntax, I can avoid the \
use of escaping characters, but I think the problem still exists when the artist or \
album name contains double-quotes:

dcop amarok collection query "SELECT path FROM images WHERE artist='Adema' AND \
album=\"Insomniac's Dream EP\""

This works.

Note: I need this for Kirocker Music Display in order to display the full-screen \
album cover: http://www.kde-apps.org/content/show.php/Kirocker+Music+Display?content=52869
 _______________________________________________
Amarok-bugs-dist mailing list
Amarok-bugs-dist@kde.org
https://mail.kde.org/mailman/listinfo/amarok-bugs-dist


[prev in list] [next in list] [prev in thread] [next in thread]