You're going to have to create a complete stand-alone example if you want us to debug your code for you.
Make a simple program that only does that one insert and share that with us. Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: [email protected] [[email protected]] on behalf of James_21th [[email protected]] Sent: Thursday, July 07, 2011 3:09 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Insert not working for sqlite3 semicolon added and tried again, still no use. ----- Original Message ---- From: Michael Stephenson <[email protected]> To: General Discussion of SQLite Database <[email protected]> Sent: Thu, 7 July, 2011 3:46:35 PM Subject: Re: [sqlite] Insert not working for sqlite3 What if you put a semicolon at the end of the query text? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James_21th Sent: Thursday, July 07, 2011 3:32 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Insert not working for sqlite3 Yes, 100% sure, because I only have one copy on my PC, and the script which can display the db's data also on the same directory. I also tried below, but no error captured, just nothing happened. try { $result=$dbh->exec("INSERT INTO tbl1(one,two) VALUES ('new1','new2')"); } catch(PDOExecption $e) { print "Error!: " . $e->getMessage() . "</br>"; } ----- Original Message ---- From: Stephan Beal <[email protected]> To: General Discussion of SQLite Database <[email protected]> Sent: Thu, 7 July, 2011 2:27:34 PM Subject: Re: [sqlite] Insert not working for sqlite3 On Thu, Jul 7, 2011 at 8:24 AM, James_21th <[email protected]> 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 is the same test.db being used in the rest of he code (same directory)? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
