Re: [sqlite] import in sqlite

2006-07-22 Thread Tom Njagi
Tom Njagi wrote: sandhya wrote: Hi, Is there any possibility to import files from the local file system and storing in sqlite DB.And Is there any export option just to check whether the loaded file into a table consists of same data as the original file or not. Is it possible in sqlite?

Re: [sqlite] SQLiteSpy - new topic

2006-07-22 Thread Jens Miltner
Am 22.7.06 um 21:48 schrieb Will Leshner: On 7/21/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote: is there a similar program as SQLiteSpy for other platforms available? I am especially interested in programs running on MacOS X. You might want to check out SQLiteManager:

Re: [sqlite] SQLiteSpy - new topic

2006-07-22 Thread Will Leshner
On 7/21/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote: is there a similar program as SQLiteSpy for other platforms available? I am especially interested in programs running on MacOS X. You might want to check out SQLiteManager:

Re: [sqlite] help with win32/iis install

2006-07-22 Thread greenshire
Thank you Pat and Kees. It looks like I will attack the permissions of it. That makes the most sense as well from some of the other things I've read in my searching. Thank you, greenshire On 7/22/06, Pat Wibbeler <[EMAIL PROTECTED]> wrote: The error probably comes from this line of code: $db

RE: [sqlite] help with win32/iis install

2006-07-22 Thread Pat Wibbeler
The error probably comes from this line of code: $db = sqlite_open("test.db") or die("failed to open/create the database"); I know nothing about this configuration, but when sqlite_open fails, my first instinct is a permissions issue. sqlite_open("test.db") attempts to create or open a file "./tes

[sqlite] [patch] SQLite shell TAB completion

2006-07-22 Thread Max Lapan
Hello to everybody I am pleased to contribute patch to sqlite shell, which adds readline TAB completion functionality similiar to bash shell, and can complete table names and fields depending from current cursor context. I also would like to thank Scot Doyle <[EMAIL PROTECTED]> for financical sup

Re: [sqlite] import in sqlite

2006-07-22 Thread Tom Njagi
sandhya wrote: Hi, Is there any possibility to import files from the local file system and storing in sqlite DB.And Is there any export option just to check whether the loaded file into a table consists of same data as the original file or not. Is it possible in sqlite? If possible,How it

RE: [sqlite] SQLiteSpy vs. SQLite.dll speed comparison

2006-07-22 Thread Joe Wilson
--- michael cuthbertson <[EMAIL PROTECTED]> wrote: > This qry is used to refresh a scrolling display where any of the constants > are actually variables. > The subquery returns about 1000 rows. > Note that a LIMIT = 1 is only marginally faster than 32. > Also, as the offset increases, the exec. tim

Re: [sqlite] help with win32/iis install

2006-07-22 Thread Kees Nuyt
Hi, On Fri, 21 Jul 2006 22:54:40 -0400, you wrote: > Greetings. > I recently installed php 5 on Win 2k3 server (iis 6). > I enabled the pdo and sqlite extensions for sqlite, but using > the test script from > http://www.tanguay.at/installPhp5.php5?step=8 , > I get error message: "failed to ope