You could do something like:
query = db.mytable.id > 0
if tag:
query &= db.mytable.tag == tag
if status:
query &= db.mytable.status == status
Anthony
On Friday, February 10, 2012 5:10:01 PM UTC-5, gbs wrote:
>
> Hi,
>
> i have search posts on this group, but i don't have found the solution
> of my question :$
>
> I have a table, wich display record of a database, nothing weird..
>
> I have made a form, so you can "filter" the result.
>
> You can check "Tag" of the record, "Status" of the record, so on...
>
> How can i create an sql "requete/statement" : ??
>
> sql = ""
> -- if tag :
> sql += "tag = xxx"
> -- if status:
> sql += " and status = xxx"
>
> result = db(sql).select()
>
> it's just an example, wich don't work, but i don't understand how to
> chain condition of a query :$
>
> Best regards
