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
#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
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
3 matches
Mail list logo