Re: [sqlite] Re: Re: Re: sqlite3_prepare16 and LIKE

2006-10-30 Thread Clark Christensen
in path. -Clark - Original Message From: Jonas Sandman <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, October 30, 2006 1:31:02 PM Subject: Re: [sqlite] Re: Re: Re: sqlite3_prepare16 and LIKE #define SELECT_STATEMENT_TEXTSORT L"SELECT * FROM Data WHERE (Da

Re: [sqlite] Re: Re: Re: sqlite3_prepare16 and LIKE

2006-10-30 Thread Jonas Sandman
#define SELECT_STATEMENT_TEXTSORT L"SELECT * FROM Data WHERE (Data.titleLIKE (SELECT '%%' || ? || '%') OR Data.artist LIKE (SELECT '%' || ? || '%') OR Data.album LIKE (SELECT '%' || ? || '%') OR Data.genre LIKE (SELECT '%' || ? || '%') OR Data.comment LIKE (SELECT '%' || ? || '%') OR Data.path LIK

[sqlite] Re: Re: Re: sqlite3_prepare16 and LIKE

2006-10-30 Thread Igor Tandetnik
Jonas Sandman <[EMAIL PROTECTED]> wrote: Yes, but path isn't part of the query. I ask for query = "", path = "C:\MP3\Albums" and I get all the results in the entire database. If I set query = "madonna" and same path. I get no results. Use parentheses to achieve this result. Okay, that could'v