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: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of James_21th [james_2...@yahoo.com]
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 <domehead...@gmail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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: 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 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 <sgb...@googlemail.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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 <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 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to