Re: [sqlite] ? placeholder not allowed in LIMIT or OFFSET clause of SELECT statement?

2005-02-02 Thread Eric Bohlman
Eric Scouten wrote: James, thanks for that update. I've filed a new ticket for this issue, #1096 (http://www.sqlite.org/cvstrac/tktview?tn=1096). I hope you don't mind that I quoted your response and implementation suggestion in the body of that ticket. There you express some concerns about

Re: [sqlite] ? placeholder not allowed in LIMIT or OFFSET clause of SELECT statement?

2005-02-02 Thread Eric Scouten
James, thanks for that update. I've filed a new ticket for this issue, #1096 (http://www.sqlite.org/cvstrac/tktview?tn=1096). I hope you don't mind that I quoted your response and implementation suggestion in the body of that ticket. -Eric James Berry wrote: Eric, No, you're not missing

Re: [sqlite] ? placeholder not allowed in LIMIT or OFFSET clause of SELECT statement?

2005-02-01 Thread James Berry
Eric, No, you're not missing anything. I asked this same question about a month ago. Dr. Hipp replied that argument substitution is not allowed in those cases, because it's allowed only where any of the datatypes allowed for substitution would be legal (blob, int, string, null). As limit and

[sqlite] ? placeholder not allowed in LIMIT or OFFSET clause of SELECT statement?

2005-02-01 Thread Eric Scouten
When I attempt to prepare the following statement using sqlite3_prepare: SELECT id FROM testEntity LIMIT 5 OFFSET ?; I get the following error back from SQLite: near "?": syntax error Is this really not allowed? If so, that seems a bit odd to me. This seems like a classic use-case for