Jonas Sandman <[EMAIL PROTECTED]>
wrote:
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.
Be aware that you can have named parameters: the same parameter can
occur more than once in the statement and you only need to bind it once.
E.g. (simplified for brevity)
select * from data where
(title=:query or artist=:query or album=:query) and path=:path;
This statement has two parameters named ":query" and ":path" and indexed
1 and 2 correspondingly. You can also use sqlite3_bind_parameter_index
to convert name to index.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
