Re: [sqlite] Insert not working for sqlite3

2011-07-11 Thread James_21th
Systems Advanced Analytics Directorate ____ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Stephan Beal [sgb...@googlemail.com] Sent: Monday, July 11, 2011 6:10 AM To: General Discussion of SQLite Database Subject: EXT :Re:

Re: [sqlite] Insert not working for sqlite3

2011-07-10 Thread James_21th
cientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of James_21th [james_2...@yahoo.com] Sent: Thursday, July 07, 2011 8:50 PM To: General Discussion of SQLite Database

Re: [sqlite] Insert not working for sqlite3

2011-07-07 Thread James_21th
Dear all, Thank you for all your valuable suggestion, it's good idea to put the whole script here, also good idea everytime to check the result, so I put the whole script here: The $result always return false, it don't allow me to create a simple table, the table name surely not exist, I

Re: [sqlite] Insert not working for sqlite3

2011-07-07 Thread James_21th
What if you put a semicolon at the end of the query text? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th Sent: Thursday, July 07, 2011 3:32 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Insert

Re: [sqlite] Insert not working for sqlite3

2011-07-07 Thread James_21th
e] Insert not working for sqlite3 On Thu, Jul 7, 2011 at 8:24 AM, James_21th <james_2...@yahoo.com> wrote: > The table already created with some data inside, the existing data can be > display use "select * from tbl1". Are you 100% sure that the test.db being opened here

Re: [sqlite] Insert not working for sqlite3

2011-07-07 Thread James_21th
July, 2011 1:59:40 PM Subject: Re: [sqlite] Insert not working for sqlite3 I don't see something like a "create table tbl1(one, two);" statement. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th Sent: Thursday, J

[sqlite] Insert not working for sqlite3

2011-07-06 Thread James_21th
Dear all,   I'm able to connect to sqlite3 DB and display the data inside, but when insert data, no matter how to try, just don't work, there's no error, but no data inserted.   Below is the simple PDO SQL I'm using, table name is "tbl1", the two fields name is just "one" & "two":   $dbh = new

[sqlite] Help needed for SQLite PHP

2011-07-03 Thread James_21th
Dear experts, I was quite excited when I see such a nice portable database---SQLite,  which can be installed locally. However, when I tried to open the SQLite DB with PHP, just a simple open script will cause "HTTP 500 Internl server error", my web server is running fine with normal php code.