[sqlite] finding the groups which have some sort of mising transaction

HI, all The following 2 queries (have the same result) are about to find some groups which have some sort of missing transactions. Please advise which one would have better performance. Thank you in advance! SELECT docketno FROM cntt_sales2 GROUP BY docketno HAVING MAX(CASE WHEN datacmd = 'RC

[sqlite] 3.2.8Undefined

Hi, all I install PHP and Apache on a WINDOWS XP box. After I enable the php_pdo.dll and php_pdo_sqlite.dll, the PHP info shows the sqlite version as "3.2.8Undefined". Why is it Undefined? And is it possible to get a later version of php_sqlite.dll , such as 3.3.3? Jack

Re: [sqlite] question about php_pdo_sqlite

Thank you, DJ My Apache is installed in Windows XP( run on NTFS file system). I think the user setting in the way as you said would be only available in Windows 2000/2003. I did try to create a new user in the XP , but have nothing to set the account right except andministrator or normal user.

Re: [sqlite] question about php_pdo_sqlite

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

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

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

[sqlite] question about php_pdo_sqlite

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

Re: [sqlite] where I can download sqlite 3.2.8

ine program is http://www.sqlite.org/sqlite-3_3_5.zip. This becomes http://www.sqlite.org/sqlite-3_2_8.zip to download the 3.2.8 version. Regards. rayB |-+> | | "yuyen" | | |

[sqlite] where I can download sqlite 3.2.8

Hi, all I need sqlite3.exe and sqlite3.dll of version 3.2.8. Just can't find any previous version on sqlite dfficial site. Please advise how to get the previous verson of sqlite3 binary files or sources files. Jack

[sqlite] question about php_ pdo_sqlite

Hi, all I install PHP 5.1.4 and Apache 2.2.2 on a Windows XP box with php_pdo and php_pdo_sqlite enabled, which will support sqlite 3.2.8. Now I need a sqlite3.exe and a sqlite3.dll of version 3.2.8. Please advise where I can download it. Thank you in advance! Jack