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
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
