Re: [sqlite] Sqlite catalog - datebase with pictures

I wrote something similar, the source might be useful to you: -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Indexing and Search speed

dcharno wrote: >> select types.Track,types.URL from ALBUM inner join (select * from MUSIC >> where Artist_Id =?) types on ALBUM.AlbumId=types.Album_Id order by >> ALBUM.YomiAlbumName ; > > How does the subquery work in this statement? I thought subqueries > could only retrieve a single column.

[sqlite] Scope of sqlite3_changes(), how to reset it?

Hi all, some questions: 1. Is sqlite3_changes() reset to 0 when a new sqlite3_exec() is started? 2. Does a PRAGMA index_list() manipulate sqlite3_changes() in any way? 3. How can i reset sqlite3_changes() manually if its not done on sqlite3_exec()? My real problem is i have a misdesigned

Re: [sqlite] Scope of sqlite3_changes(), how to reset it?

Michael Schlenker <[EMAIL PROTECTED]> wrote: > 1. Is sqlite3_changes() reset to 0 when a new sqlite3_exec() is > started? May or may not. E.g. if you execute a SELECT statement it doesn't affect change count. > 2. Does a PRAGMA index_list() manipulate sqlite3_changes() in any way? I haven't

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" Today I tried and installed on Solaris successfully. Both the module 1.14 and sqlite3 amalgamation. -- Radek

Re: [sqlite] DBD::SQLite::Amalgamation?

Humm... I'll keep looking. thanks On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" > > It hangs forever and never completes > > I have tried this on multiple boxes running both

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" > > It hangs forever and never completes > > I have tried this on multiple boxes running both Fedora and Redhat ES, > all 64

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, P Kishor <[EMAIL PROTECTED]> wrote: > On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > > Any Perl people out there using this yet (version 3.5.7)? > > > > I'm continually having problems when doing "make test" > > > > It hangs forever and never completes > > > > I have tried this

Re: [sqlite] DBD::SQLite::Amalgamation?

On 3/31/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > On 3/31/08, P Kishor <[EMAIL PROTECTED]> wrote: > > On 3/30/08, Jim Dodgen <[EMAIL PROTECTED]> wrote: > > > Any Perl people out there using this yet (version 3.5.7)? > > > > > > I'm continually having problems when doing "make test" > > > >

Re: [sqlite] Indexing and Search speed

From: Dennis Cote <[EMAIL PROTECTED]> > No, that's not true. A sub-query is like any other query. I have > rearranged the query to make it more readable. > > select types.Track,types.URL > from ALBUM > inner join (select * from MUSIC where Artist_Id =?) as types > on

[sqlite] When I try to .read I get a "can't open" message

I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_source>sqlite3 test SQLite version 3.5.7 Enter ".help" for instructions sqlite> .read test.sql; can't open "test.sql;" sqlite> .read C:/_source/test.sql; can't open "C:/_source/test.sql;"

Re: [sqlite] When I try to .read I get a "can't open" message

On 3/31/08, Douglas McCarroll <[EMAIL PROTECTED]> wrote: > I'm sure I'm doing something simple and obvious wrong here. I'm a complete > sqlite n00b. > > Help? > > C:\_source>sqlite3 test > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> .read test.sql; > can't open

Re: [sqlite] When I try to .read I get a "can't open" message

On 31-Mar-2008, at 2:11 PM, Douglas McCarroll wrote: > I'm sure I'm doing something simple and obvious wrong here. I'm a > complete > sqlite n00b. > > Help? > > C:\_source>sqlite3 test > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> .read test.sql; > can't open "test.sql;" You

Re: [sqlite] When I try to .read I get a "can't open" message

It's the trailing semicolon. The dot commands don't require them, while SQL statements do. - Original Message From: Douglas McCarroll <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" Sent: Monday, March 31, 2008 2:11:35 PM Subject: [sqlite] When I try to

Re: [sqlite] When I try to .read I get a "can't open" message

On Mon, 31 Mar 2008 17:11:35 -0400, you wrote: >I'm sure I'm doing something simple and obvious wrong here. I'm a complete >sqlite n00b. > >Help? > >C:\_source>sqlite3 test >SQLite version 3.5.7 >Enter ".help" for instructions >sqlite> .read test.sql; >can't open "test.sql;" >sqlite> .read

[sqlite] SQLITE QUERY (LIKE)

Hi, how are you?? actually i'm developing a program in SQLite, and until this moment i wouldn't have any problem, but now i have a big one with a huge difficult in a query. this query is: SELECT table.code, table.name FROM table, table table2 WHERE table.code like table2.code+'%' really i

Re: [sqlite] SQLITE QUERY (LIKE)

Hi Monica, > WHERE table.code like table2.code+'%' > > really i dont know if i am doing something wrong for sqlite, because > in access my query works very good. Replace the + with || which is used to concatenate strings. In fact, I think || is the SQL standard. See:

Re: [sqlite] When I try to .read I get a "can't open" message

Thanks all! Yes, dropping the semicolon fixed it... On Mon, Mar 31, 2008 at 6:11 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > On Mon, 31 Mar 2008 17:11:35 -0400, you wrote: > > >I'm sure I'm doing something simple and obvious wrong here. I'm a > complete > >sqlite n00b. > > > >Help? > > >

Re: [sqlite] DBD::SQLite::Amalgamation?

Hi, > [...] >> t/06error...ok 1/2 >> >> (this never finishes) > > well, look in the t directory for the specific test. In my case, I see > the following -- > [...] > my $db = DBI->connect('dbi:SQLite:foo', '', '', { RaiseError => 1, I'm not certain what the call to DBI->connect()

[sqlite] mem5 ("buddy system") usable?

I just downloaded 3.5.7, and noticed that there is a new memory allocator mem5.c, which apparently uses the "buddy system" to allocate power-of-two-sized chunks of memory from a static pool. This allocator is used by defining SQLITE_POW2_MEMORY_SIZE. Is it okay to use this allocator, or is it

[sqlite] create index with allow duplicate row

Hi All, Is sqlite3 allow to create the index(non-cluster index) with an option allow duplicate row Thanks, JL You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No

Re: [sqlite] mem5 ("buddy system") usable?

On Mar 31, 2008, at 10:00 PM, Richard Klein wrote: > I just downloaded 3.5.7, and noticed that there is a > new memory allocator mem5.c, which apparently uses the > "buddy system" to allocate power-of-two-sized chunks > of memory from a static pool. This allocator is used > by defining

Re: [sqlite] create index with allow duplicate row

"Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is sqlite3 allow to create the index(non-cluster index) with an > option allow duplicate row Yes. Just don't use UNIQUE option in your CREATE INDEX statement. Igor Tandetnik