Re: [sqlite] no such column error

Try this: UPDATE mytable SET myfield1 = (SELECT 1 from mytable ORDER BY EXISTS (SELECT 1 WHERE mytable.myfield2 = 1 ) ) RBS On Tue, Oct 25, 2016 at 4:40 PM, Rob Golsteijn

[sqlite] no such column error

Hi List, I encountered a situation in which sqlite does not understand to which field I try to refer. I simplified the original query to show the problem. The simplified query itself is now completely meaningless (and for my specific situation I could rewrite the query to work around the

Re: [sqlite] Development environment reccomendation

Ruby to script out and automate the process. Could use Sinatra as a lightweight web interface, or go Rails for a full blown web service. On Mon, Oct 24, 2016 at 5:02 AM, Simon Slavin wrote: > > On 24 Oct 2016, at 6:26am, Philip Rhoades wrote: > > >

Re: [sqlite] Import 5000 xml files in a sqlite database file

Ruby scripting language, using Nokogiri library to parse the html. On Sun, Oct 23, 2016 at 11:12 AM, Preguntón Cojonero Cabrón < preguntoncojon...@gmail.com> wrote: > Scripting powershell? C#? > > El 23/10/2016 18:04, "Sylvain Pointeau" > escribió: > > > hello, > > >

[sqlite] the error on Aix7 where i make sqlite3.13

hello：when i downthe latest sqlite and make sqlite-autoconf-313 , there is something wrong.my os: AIX7 event: make sqlite3 erroe message: cc:1501-218(W) file 3.13.0 contains an incorrect file suffix cc:1501-218(W)input file 3.13.0 not found make:1254-004 the error code from the last