On 10/30/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Jonas Sandman <[EMAIL PROTECTED]> wrote: > #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 LIKE (SELECT > '%' || ? '%')) AND Data.path LIKE (SELECT '%' || ? || '%');" Is this your actual statement, straight from your code? I'm asking because it has a few syntax errors, and should fail to prepare. Most surprising is the fact that you have seven parameters, but only bind six of them. Note how Data.path is mentioned twice in your query. Can this be the cause of your problem? The last parameter remains unboud, at which point it is treated as NULL. Igor Tandetnik
That was exactly it! I've had seven before but my select hasn't been correct before. Now when I added path as the seventh parameter it worked. I have path twice since the first six is bound to query (what you search for) and the seventh is used to only include certain folders. Anyways, thanks for the help! /Jonas -----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
