On 28 Jul 2014, at 2:53pm, Jonathan Moules <jonathanmou...@warwickshire.gov.uk> wrote:
> That said, I don't suppose there's any option for the other variable > ($date_string)? No. I suppose you could store the calculated date in another table, then use another JOIN to retrieve it. I have no idea how well this would work in real life. Otherwise I think you're going to have to have your software prepare the query as a big string using whatever string facilities your programming language has. It can then execute the query using _prepare()/_step (without needing to do any binding) or _exec(). You could do that with your CREATE VIEW command. Or you could do it with a SELECT. For those who don't know, CREATE VIEW is just a clever way of storing a SELECT statement. It does not store data from inside a table anywhere. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
