[sqlite] reusing prepared queries or dynamic generation of SQL?

2007-02-10 Thread Brodie Thiesfield
Hi, I'm looking for some SQL advice. I have a query which is used as the base of a filter. At the moment I am using: SELECT * FROM table WHERE (1=? OR foo=?); The actual query is more complex and uses multiple of the constructions in this WHERE clause. If I wanted to select on the foo column

Re: [sqlite] reusing prepared queries or dynamic generation of SQL?

2007-02-10 Thread Jay Sprenkle
On 2/10/07, Brodie Thiesfield [EMAIL PROTECTED] wrote: Hi, I'm looking for some SQL advice. I have a query which is used as the base of a filter. At the moment I am using: SELECT * FROM table WHERE (1=? OR foo=?); The actual query is more complex and uses multiple of the constructions in