Re: [sqlite] [sqlite-dev] Error 25: column index out of range when binding for a DATETIME

2019-11-01 Thread Jeffrey Walton
On Thu, Oct 31, 2019 at 9:52 AM Keith Medcalf wrote: > On Thursday, 31 October, 2019 07:17, Jeffrey Walton > wrote: > ... > >/* negative for days in the past */ > >int days = 120; > >days = -days; > > >const char DELETE_STMT[] = "DELETE from blacklist " \ > >"WHERE dtime

Re: [sqlite] [sqlite-dev] Error 25: column index out of range when binding for a DATETIME

2019-10-31 Thread Keith Medcalf
On Thursday, 31 October, 2019 07:17, Jeffrey Walton wrote: First, your question should go to the sqlite-users mailing list, not the developers mailing list. >I'm having trouble binding a parameter for a DELETE. I am trying to >delete records older than 120 days. Below, I have a table with a