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

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)

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

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

[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 /

[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

[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 -

[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,