Re: [sqlite] about sqlite3_exec function

2012-03-31 Thread Black, Michael (IS)
lite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Saturday, March 31, 2012 7:50 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] about sqlite3_exec function On 31 Mar 2012, at 12:48pm, "Black, Michael (IS)" <michael.bla...@ngc.com> wrote: &

Re: [sqlite] about sqlite3_exec function

2012-03-31 Thread Simon Slavin
On 31 Mar 2012, at 12:48pm, "Black, Michael (IS)" wrote: > What you want is the system() function which will execute a shell command. > > > > But you still need to add your own HTML around it to be displayed by a > browser as it's missing the "rest of the story". >

Re: [sqlite] about sqlite3_exec function

2012-03-31 Thread Black, Michael (IS)
Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of YAN HONG YE [yanhong...@mpsa.com] Sent: Saturday, Ma

Re: [sqlite] about sqlite3_exec function

2012-03-31 Thread Steinar Midtskogen
[YAN HONG YE] > sqlite3_exec( db, "???", 0, 0, ); > > I wanna add this following command into sqlite3_exec func: > "sqlite3 -html -header mydzh.db \"select * from dhq where ph15>10;\" >mm.html" > like this: > sqlite3_exec( db, "-html -header \"select * from dhq where ph15>10;\" > >mm.html", 0,

[sqlite] about sqlite3_exec function

2012-03-30 Thread YAN HONG YE
sqlite3_exec( db, "???", 0, 0, ); I wanna add this following command into sqlite3_exec func: "sqlite3 -html -header mydzh.db \"select * from dhq where ph15>10;\" >mm.html" like this: sqlite3_exec( db, "-html -header \"select * from dhq where ph15>10;\" >mm.html", 0, 0, ); but it doesn't work