Re: [sqlite] problem with blobs (perl code)

Quoting [EMAIL PROTECTED]: > Jim Dodgen <[EMAIL PROTECTED]> wrote: > > I am having a problem with blobs, I seem to insert ok but only get three > (3) > > bytes when I query it back. yes I am setting LongReadLen. any ideas? > > > > thanks > > > >

[sqlite] problem with blobs (perl code)

I am having a problem with blobs, I seem to insert ok but only get three (3) bytes when I query it back. yes I am setting LongReadLen. any ideas? thanks Jim I'm using sqlite 3.2.7, 1.09 and of the perl module also code and test results are below. also when I use the command line sqlite3 I al

Re: [sqlite] howto exit ?

the ...> indicates uou are continuing a statement, from you r example it looks like you are lost. at this point you need to do what is needed to complete a statement, even though the statement is garbage, try typing a ; (to end a sql statemtent. you could be inside a quote so type a "; or '; to

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

look at the glob command it works like like except uses the unix file name globbing style of matching not quite a grep select * from table where a glob '[abc]foobar*'; At 06:47 PM 7/5/2005, you wrote: like this? select * from table where a like '%abc%'; SQLite also makes it easy to write you

Re: [sqlite] philosophy behind public domain?

Small world, I worked with Poul at TRW Finanacial systems in the mid 90's. Quoting Clay Dowling <[EMAIL PROTECTED]>: > > Chad Whitacre said: > > My personal favorite non-copyleft license is the "beer-ware license," as > > used by, e.g., Poul-Henning Kamp: > > > >http://people.freebsd.org/~

Re: [sqlite] Inserting bulk data in a sqlite table

bulk loading should be wrapped with begin and commit statements. begin; insert into ... (a bunch more) commit; At 03:08 AM 5/24/2005, Anirban Sarkar wrote: Hi all, I have a flat file with pipe seperated data which needs to be inserted into a sqlite table. I have written a script for the same

Re: [sqlite] Relationship between 2 tables

I use triggers to do this. Quoting Jay Sprenkle <[EMAIL PROTECTED]>: > On 5/17/05, Svetlik Slavomir <[EMAIL PROTECTED]> wrote: > > Hi, I am new in this forum, but not in SQLite3. I successfully used > > SQLite3.dll with Rapid-Q (very good programming language - clone of > > Q-Basic), basic comman

Re: [sqlite] Original Conf

you only need DBD::SQLite it is self contained Quoting Leander Gillard <[EMAIL PROTECTED]>: > Quick question I need answered to send to the sysadmin but do I need to both > > download and install sqlite and also use the DBD::SQLite module when coding > in perl?? > > I think this is true, b

Re: [sqlite] Original Conf

DBD::SQLite is self contained. if you want to run queries from the command line, like to test stuff. you will need the sqlite download. I like to build both from the same sqlite sources so the versions are identical. Quoting Leander Gillard <[EMAIL PROTECTED]>: > Quick question I need answere

Re: [sqlite] concatenation of row with NULLS suppresses all values

just fine for me thanks Jim At 08:55 PM 3/28/2005, you wrote: Jim Dodgen <[EMAIL PROTECTED]> writes: > drop table foo; > create table foo (x,y,z); > insert into foo values (1, null, null); > insert into foo values (2, null, null); > insert into foo values (3, 33, 333); &g

[sqlite] concatenation of row with NULLS suppresses all values

drop table foo; create table foo (x,y,z); insert into foo values (1, null, null); insert into foo values (2, null, null); insert into foo values (3, 33, 333); select x || "-" || y || "-" || z from foo; whe I run the above select I only see the last row. it looks as if a row has any nulls in the c

[sqlite] getting table column names and types programaticly

Anyone know how I can query the field names and types for a given table?

Re: [sqlite] Version 3.2.0

Quoting "D. Richard Hipp" <[EMAIL PROTECTED]>: > > Error: unsupported file format > > This is as documented. See for example ... thanks I guess I need to learn how to read :) >> also when I use the "up arrow" > > I used to compile the command-line client using GNU readline > so that the arrow

Re: [sqlite] Version 3.2.0

I just pulled down the linux command line utility for 3.2.0 my previous verson was 3.0.8. as i remember, I installed the 3.0.8 version from a rpm. the 3.2.0 was a pre-compiled binary. also upgrade the perl wrapper from 1.07 to 1.08. just for testing I went into an existing 3.0.8 database with t

[sqlite] importing csv files?

anyway to import csv files in sqlite3? .import does not quite work, leaves the quotes in.

Re: [sqlite] Error: malformed database schema ...

very good, thanks At 09:58 PM 2/13/2005, you wrote: On Sun, 2005-02-13 at 21:40 -0800, Jim Dodgen wrote: > attach database bar as ref; > create table ref.table_field >( > name varchar(255), > nbr varchar(255) >

[sqlite] Error: malformed database schema ...

sqlite 3.0.8, windows XP I'm attempting to create some tables and indexes in a attached database (bar) and after everything is complete and I go back in to the previously attached database and do a .schema I get the following: "Error: malformed database schema - index table_field_name cannot ref

<    1   2