Re: [sqlite] question about php_pdo_sqlite

2006-06-04 Thread yuyen
. Jack - Original Message - From: "DJ Anubis" <[EMAIL PROTECTED]> To: Sent: Saturday, June 03, 2006 5:00 PM Subject: Re: [sqlite] question about php_pdo_sqlite Did you fully read Apache documentation ? Maybe some RTFM can help with this. From Apache doc, section Run

Re: [sqlite] question about php_pdo_sqlite

2006-06-03 Thread Clay Dowling
yuyen wrote: > Ok, finally I found the problem is that the PHP and Apache are installed > in local drive and I put the sqlite database file on a remote file > server which is a Linux / Samba. I can use sqlite3.exe to open that > remote database with a mapped remote drive. And Insert, Update and > D

Re: [sqlite] question about php_pdo_sqlite

2006-06-03 Thread DJ Anubis
yuyen wrote: > Ok, finally I found the problem is that the PHP and Apache are > installed in local drive and I put the sqlite database file on a > remote file server which is a Linux / Samba. I can use sqlite3.exe to > open that remote database with a mapped remote drive. And Insert, > Update and D

Re: [sqlite] question about php_pdo_sqlite

2006-06-02 Thread yuyen
em at all. Even I can use sqlite3.exe concurrently with PHP pdo. Does Apache has different thinking about remote server? Jack - Original Message - From: "DJ Anubis" <[EMAIL PROTECTED]> To: Sent: Friday, June 02, 2006 12:13 AM Subject: Re: [sqlite] question about php_

Re: [sqlite] question about php_pdo_sqlite

2006-06-01 Thread DJ Anubis
yuyen wrote: > And the error message is: > "execute err: SQLSTATE[HY000]: General error: 8 attempt to write a > readonly database" > > So the problem is why the database becomes read only. > This time, you get another message :) Are you sure the Web Server user (Apache or...) has write access to yo

Re: [sqlite] question about php_pdo_sqlite

2006-06-01 Thread yuyen
Hi, DJ I try the following code: -- try{ $dsn = 'sqlite:counter/cntdata.sq3'; $myConn = new PDO($dsn); $myConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $j = $myConn->exec('update test_item set balqty = 100'); }catch (PDOException $e){ die('execute err: '.$e->getMessage()); }

Re: [sqlite] question about php_pdo_sqlite

2006-06-01 Thread DJ Anubis
yuyen wrote: > HI, JC > I use php_do_sqlite with PHP 5.1.4 and Sqlite 3.2.8 on Windows XP. The > following is my coding: > > try{ > $dsn = 'sqlite:counter/cntdata.sq3'; > $myConn = new PDO($dsn); > $myConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); > > $myPre = $myConn->prepare('upd

Re: [sqlite] question about php_pdo_sqlite

2006-06-01 Thread Kevin Waterson
This one time, at band camp, "yuyen" <[EMAIL PROTECTED]> wrote: > HI, JC > I use php_do_sqlite with PHP 5.1.4 and Sqlite 3.2.8 on Windows XP. The > following is my coding: -8< snip try { $dbh = new PDO("sqlite:counter/cntdata.sq3"; /*** echo a message s

Re: [sqlite] question about php_pdo_sqlite

2006-05-31 Thread yuyen
From: "DJ Anubis" <[EMAIL PROTECTED]> To: Sent: Thursday, June 01, 2006 4:03 PM Subject: Re: [sqlite] question about php_pdo_sqlite yuyen wrote: Hi, all I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With php_pdo, it provides PREPARE and EXECUTE function

Re: [sqlite] question about php_pdo_sqlite

2006-05-31 Thread DJ Anubis
yuyen wrote: > Hi, all > > I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With > php_pdo, it provides PREPARE and EXECUTE functions to prepare an sql at first > then which can execute later. But it seems that the php_pdo_sqlite.dll > doesn't support it. Or I may do somth

[sqlite] question about php_pdo_sqlite

2006-05-31 Thread yuyen
Hi, all I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With php_pdo, it provides PREPARE and EXECUTE functions to prepare an sql at first then which can execute later. But it seems that the php_pdo_sqlite.dll doesn't support it. Or I may do somthing wrong. If there is a