Re: [sqlite] like-op
Rod Dav4is wrote: I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) Don't hesitate to contact customer services to arrange for your 30day no quibble refund. :-Þ P.
[sqlite] Shadow Pager
Has anyone implemented the shadow pager for sqlite??? Thanks Sankarshana M ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com
[sqlite] For vim users: dbext.vim supports sqlite now
>From the vim mailing list: (David Fishburn, the author, says:) I am pleased to announce an update to dbext to version 2.10. http://vim.sourceforge.net/scripts/script.php?script_id=356 This release has increased the supported databases to 10 by adding SQLite (www.sqlite.org). -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853 CB42 3ECF 9259 AD29 415D
Re: [sqlite] like-op
Rod Dav4is wrote: I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) My guess is that most of us on this list are building bakeries and not just buying bread.
Re: [sqlite] like-op
1. Hardly a solution for those who, like me, don't have C, are not into compiling Windows programs, etc. 2. This would make for a bastard version of LIKE or GLOB, which really grates on my nerves. I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) So, I guess the bottom line answer is No. -R. D. Richard Hipp wrote: Rod Dav4is wrote: Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB? You can use the sqlite3_create_function() API to provide your own implementation of LIKE and/or GLOB that does whatever you want.
Re: [sqlite] like-op
Rod Dav4is wrote: Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB? You can use the sqlite3_create_function() API to provide your own implementation of LIKE and/or GLOB that does whatever you want. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Re: [sqlite] left outer join returns duplicates
Philip Riggs wrote:
I have the two following tables for testing:
Test1) rowid | class | join_value
1 | 'one' | 1
2 | 'two' | 2
Test2) rowid | type | join_value
1 | 'number' | 1
2 | 'string' | 2
and peform the following query:
select * from test1 natural join test2
I expect the following:
test1.rowid | test1.class | test1.join_value | test2.type
1 | one | 1 | number
2 | two | 2 | string
but I instead get the following:
test1.rowid | test1.class | test1.join_value | test2.type
1 | one | 1 | number
2 | two | 2 | string
1 | one | 1 | number
2 | two | 2 | string
I did this:
create table test1(class, join_value);
insert into test1 values('one',1);
insert into test1 values('two',2);
create table test2(type, join_value);
insert into test2 values('number',1);
insert into test2 values('string',2);
select * from test1 natural join test2;
And I got this:
one|1|number
two|2|string
Version 3.0.6. If you are getting something different, please
supply the specifics.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
[sqlite] like-op
Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB? -- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA Genealogy, et Cetera: http://freepages.rootsweb.com/~dav4is/ 391 ancestral & collateral families, mostly 17th - 19th century New England & European roots, total population: 89,400+ Annex: http://www.gencircles.com/users/dav4is/ email: [EMAIL PROTECTED]
[sqlite] left outer join returns duplicates
I have the two following tables for testing: Test1) rowid | class | join_value 1 | 'one' | 1 2 | 'two' | 2 Test2) rowid | type | join_value 1 | 'number' | 1 2 | 'string' | 2 and peform the following query: select * from test1 natural join test2 I expect the following: test1.rowid | test1.class | test1.join_value | test2.type 1 | one | 1 | number 2 | two | 2 | string but I instead get the following: test1.rowid | test1.class | test1.join_value | test2.type 1 | one | 1 | number 2 | two | 2 | string 1 | one | 1 | number 2 | two | 2 | string Why are my data duplicating rows? I've been over the SQL statement in books and this is the way it demonstrates this query, but the SQLite results don't match what the books say to expect. I even tried this: select test1.class, test2.type from test1 natural join test2 group by class, type But still get duplicates.
[sqlite] TEST
Is this how I should send messages to the list? Your %^&@# verbose instructions tell everything but how to do that! -- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA Genealogy, et Cetera: http://freepages.rootsweb.com/~dav4is/ 391 ancestral & collateral families, mostly 17th - 19th century New England & European roots, total population: 89,400+ Annex: http://www.gencircles.com/users/dav4is/ email: [EMAIL PROTECTED]
[sqlite] [Announce] Lua-Sqlite3 verion 0.1 (alpha) released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lua-Sqlite3 is a binding of Sqlite3 for Lua. Lua-Sqlite3 is unique in contrast to other database bindings that it consists of two layers. The first layer translates the SQLite 3 implementation's C API to Lua. The second layers are interface layers, written in Lua. These layers provide a nice and smart view of the database Currently, Lua-Sqlite3 implements two interfaces: a.) A specialiced interface which provides all sqlite3 capabilities. b.) A LuaSQL compatible interface as used on the Kepler Project. Lua-Sqlite3 works in hosts with multiple Lua states, integrates with coroutines, provides for-loop iterators and much more. Homepage: http://www.nessie.de/mroth/lua-sqlite3/ -BEGIN PGP SIGNATURE- Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBRtKsSIrOxc3jOmoRAuVkAJwIHu0uqVnX0pzsEm/05KyL3InmkACdF3ZB ZzUv5U9NrUdxcbgmWM/Ytc0= =Nqfq -END PGP SIGNATURE-
