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

2006-10-30 Thread Jonas Sandman
On 10/30/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Jonas Sandman <[EMAIL PROTECTED]> wrote: >> Data.artist LIKE (SELECT '%' || ? || '%') OR Data.album LIKE (SELECT >>> '%' || ? || '%') OR Data.genre LIKE (SELECT '%' || ? || '%') OR >>> Data.comment LIKE (SELECT '%' || ? || '%') AND Data.path

[sqlite] Re: Re: sqlite3_prepare16 and LIKE

2006-10-30 Thread Igor Tandetnik
Jonas Sandman <[EMAIL PROTECTED]> wrote: Data.artist LIKE (SELECT '%' || ? || '%') OR Data.album LIKE (SELECT '%' || ? || '%') OR Data.genre LIKE (SELECT '%' || ? || '%') OR Data.comment LIKE (SELECT '%' || ? || '%') AND Data.path LIKE (SELECT You have AND here, while elsewhere you have OR. Is