Re: [sqlite] Near misses

Simon Slavin wrote: > On 26 Jun 2009, at 12:25pm, Alberto Simões wrote: > >> one adition, one remotion or one substitution > > I am always amazed at how well people use English. For your word > 'remotion' you probably mean 'removal' or 'omission'. You have joined > the two possibilities

Re: [sqlite] DBD::SQLite reporting corruption sqlite3 CL program does not

Craig Talbert wrote: >>From Perl, when I attempt to make a database connection using SQLite, > I get the following error: > > [Tue Jun 23 17:10:22 2009] projectory.cgi: > DBI->connect(dbname=projectory.sqlite3) failed: database disk image is > malformed at ./projectory.cgi line 1577 > > At line

[sqlite] Column headers of result

Hi, Is there any way in the command line to get the columns in a query result? For example, given an ad-hoc SQL command, such as: begin; insert into MyTableOrView select * from SomeSource; select * from MyTableOrView join SomeOtherTableOrView where condition; end; how can I get the column

Re: [sqlite] [ANN] SQLiteManager 3.0

Hi Marco, > SQLabs is proud to announce today the worldwide availability of > SQLiteManager 3.0, the most powerful sqlite database manager tool > for MacOS X and Windows. Congrats on the new version. I've revised my comparison table at: http://www.tandb.com.au/sqlite/compare/?ml to show

Re: [sqlite] Comparison of numbers as text

On Sun, Jun 28, 2009 at 07:59:54PM -0400, Tim Largy scratched on the wall: > Can someone explain what is going on in the third select statement > below? I would have expected it to return a row because the number is > quoted. > > sqlite> select 'foo' where 1 in (1, '2', 'three'); > foo > sqlite>

Re: [sqlite] Comparison of numbers as text

On 6/28/09, Tim Largy wrote: > Can someone explain what is going on in the third select statement > below? I would have expected it to return a row because the number is > quoted. > > sqlite> select 'foo' where 1 in (1, '2', 'three'); > foo > sqlite> select 'foo' where 2 in

[sqlite] Comparison of numbers as text

Can someone explain what is going on in the third select statement below? I would have expected it to return a row because the number is quoted. sqlite> select 'foo' where 1 in (1, '2', 'three'); foo sqlite> select 'foo' where 2 in (1, '2', 'three'); sqlite> select 'foo' where '2' in (1, '2',

Re: [sqlite] Near misses

On 27/06/2009 7:00 AM, Jean-Christophe Deschamps wrote: > At 13:25 26/06/2009, you wrote: > ´¯¯¯ >> I am trying to find words in a dictionary stored in sqlite, and trying >> a near miss approach. >> For that I tried an algorithm to create patterns corresponding to >> Levenshtein distance of 1

Re: [sqlite] Data Extraction Question

On Sun, Jun 28, 2009 at 05:58:39PM -0500, Rick Ratchford scratched on the wall: > Hello. > > I have the following task: > > Suppose that you have a recordset that contains the following: > > DATE > Color1 > Offset1 > > Okay. Now suppose you want to extract from this recordset 15 records

Re: [sqlite] unable to write the string "1.0" into a database table

chandan wrote: > I am really sorry, The correct code is given below: > > // > #include > #include > #include > #include > #include > > const char *create_and_insert = "create table some_tbl (id int primary > key,

Re: [sqlite] Near misses

On Fri, Jun 26, 2009 at 10:00 PM, Jean-Christophe Deschamps wrote: > Hi, > > I'm currently finishing an C extension offering, among other functions, > a "TYPOS" scalar operator which is meant to perform just that, and a > bit more. > > Internally, it applies a Unicode fold()

[sqlite] (no subject)

humm -- ArbolOne.org specializes in Custom Web Site Design, Web Site Re Design, Web Site Template Modifications, Web Site Maintenance, Integration of Payment Gateways (API's), Database Applications, Custom Applications and much more. 416.838.2057 arbol...@gmail.com "O Allah, make my love