[sqlite] How do I unsubscribe?

Thanks. NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.

RE: [sqlite] Version 3.3.14

Something that would be very useful in the shell code in a future release would be the ability to handle data containing embedded binary data. I use the shell to populate tables and many of the files I need to load have the odd \n or \000 embedded in what whould be ascii text. Sybase handles this

RE: [sqlite] stupid man's manual to sqlite?

Removing the index is one of the silliest suggestions I've ever encountered. A book without an index is almost useless, unless of course you're blessed with a photographic memory. As far as putting in on a CD or on the web, that's fine as long as a _good_ index is also included in the book. I

RE: [sqlite] Is there an inverse for .import?

Not an option for what I'm doing. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? On Fri, 9 Mar 2007, Dennis Cote wrote: > You can get csv output

RE: [sqlite] Is there an inverse for .import?

Yes, unlike .dump, that works. Thanks very much. jim -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? Anderson, James H (IT) wrote: > I need to &quo

RE: [sqlite] Is there an inverse for .import?

limiter using the .separator command, or you can use .mode to use a predefined format. -Clark - Original Message From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, March 9, 2007 9:04:29 AM Subject: [sqlite] Is there an inverse fo

RE: [sqlite] Is there an inverse for .import?

] Is there an inverse for .import? On 3/9/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I need to "export" a table to a file in the same format as used by > .import, but I don't see any such cmd. Am I missing something, or does > such a cmd just not exist? .dump

[sqlite] Is there an inverse for .import?

I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? jim

RE: [sqlite] stupid man's manual to sqlite?

FWIW, excepting the index which is truly terrible, this is one of the better technical books I've encountered. It has certainly been invaluable for me. jim -Original Message- From: Mike Owens [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:16 PM To: sqlite-users@sqlite.org

RE: [sqlite] stupid man's manual to sqlite?

You won't be disappointed , it's a terrific book! -Original Message- From: Jakub Ladman [mailto:[EMAIL PROTECTED] Sent: Thursday, March 08, 2007 9:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] stupid man's manual to sqlite? Thank you i will try my possibilities buying from

[sqlite] bug in the cmd shell

The .import cmd has a problem when it encounters binary zeros embedded in data. I have a large tab-separated text file which has some garbage (aka binary zeros) in one of the fields of one of the records. The .import cmd trips on this and terminates with this msg:

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

, James H (IT) wrote: > I guess I forgot to mention the context. I'm interested in doing this > from the cmd shell. > > James, You can use the command pragma count_changes=1 in the shell to have it report the number of rows affected by insert, update, or delete statemen

RE: [sqlite] Any way to know the numbers of rows affected by a cmd?

to know the numbers of rows affected by a cmd? Indeed, try: select count() ... update count() ... delete count() ... Dr. Tom - Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, March 01, 2007 3:40 PM

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

? Anderson, James H (IT) wrote: > For a select, the number of rows selected. Just count them as you step through them. > For an update, the number of rows updates. > > For a delete the number of rows deleted. sqlite3_changes, sqlite3_total_changes Ig

[sqlite] Any way to know the numbers of rows affected by a cmd?

For a select, the number of rows selected. For an update, the number of rows updates. For a delete the number of rows deleted. jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive

[sqlite] sybase => sqlite "translation" ???

I'm trying to implement the equivalent of the following sybase query in sqlite, but I suspect I've got it wrong. Any help much appreciated, jim update tmpRR_ML_final set id = case when a.CDRefSNP <> 'NR' then b.id when a.CDRefSNP = 'NR' and a.CDRefMoody

RE: [sqlite] Re: Re: Looking for equivalent syntax

OK, thanks again. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 10:56 AM To: SQLite Subject: [sqlite] Re: Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > In order to improve my understanding, I'd like to as

RE: [sqlite] Re: Looking for equivalent syntax

ry 19, 2007 2:04 PM To: SQLite Subject: [sqlite] Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > I'm trying to convert the following statement in Sybase syntax into > the > equivalent sqlite syntax: > > update C1_credDerivEvent >set a.CDEvent = a.CDEvent || ',' |

RE: [sqlite] Re: Looking for equivalent syntax

Thanks! I'll give it a try. -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 2:04 PM To: SQLite Subject: [sqlite] Re: Looking for equivalent syntax Anderson, James H (IT) wrote: > I'm trying to convert the following statement in Syb

RE: [sqlite] Looking for equivalent syntax

On Behalf Of P Kishor Sent: Monday, February 19, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Looking for equivalent syntax On 2/19/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I'm trying to convert the following statement in Sybase syntax into the > eq

[sqlite] Looking for equivalent syntax

I'm trying to convert the following statement in Sybase syntax into the equivalent sqlite syntax: update C1_credDerivEvent set a.CDEvent = a.CDEvent || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent b, tmp_eventsc where a.CDId= b.CDId

RE: [sqlite] retrieval speedup help requested

Where does one get "analyze"? -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, February 17, 2007 5:25 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] retrieval speedup help requested Try running: analyze city_loc after adding the index. RBS

[sqlite] Disk corruption?

Is this likely to just be a hardware error. database disk image is malformed(1) at dbdimp.c line 398 jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of

RE: [sqlite] Re: another

A syntax error, "duplicate column name". -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 10:24 AM To: SQLite Subject: [sqlite] Re: another Anderson, James H (IT) wrote: > If I run the following sql > > c

[sqlite] another

If I run the following sql create table table_C as select A.col_1, B.col_2 from table_A A, table_B B where A.col_3 = B.col_4 The table_C is created with the following column names: "A.col_1", "B.col_2" Quotes and all. How bizarre is that? Am I doing something wrong? (The only way

RE: [sqlite] help with syntax

That did the trick. Thanks very much. jim -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 4:55 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] help with syntax Anderson, James H (IT) wrote: > I have the following sybase qu

RE: [sqlite] help with syntax

Thanks, Dennis, I'll try that. Yes, "*=" means "LEFT JOIN" in sybase syntax. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 4:55 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] help with syntax Anderson, James H

[sqlite] help with syntax

I have the following sybase query (a left join) that I'm having trouble translating into the "LEFT JOIN" syntax. Any help appreciated. Thanks, jim. create table tmpRR_ML as select b.ratingCodeas ratingCode, a.CDSpreadCurve as CDSpreadCurve from tmpRR a, MasterList b,

RE: [sqlite] What does this mean???

Looks like removing the semi-colon did the trick. Thanks very much. -Original Message- From: Matt Sergeant [mailto:[EMAIL PROTECTED] Sent: Thursday, February 08, 2007 11:09 AM To: Anderson, James H (IT) Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 8-Feb

RE: [sqlite] What does this mean???

The output after setting $dbh->trace(3): insert or replace into TMP_credDerivOrig select A.date, A.CDId, A.CDName, A.CDTicket, A.tradeId, A.tapsAccount, A.CDBook, coalesce(A.CDFid,'') CDFid, A.CDStatus, A.CDTradeDate, A.CDExpDate, A.CDNotional, A.CDCurr, A.CDSellBuy, A.CDType, A.CDExerType,

RE: [sqlite] What does this mean???

ot;not an error" on $sth->execute is bound to be nasty to diagnose. FWIW, it looks like "not an error" is the result of a call to sqlite3_errmsg(). Unrelated to your issue is a DBI presentation you may be interested to look through at http://search.cpan.org/src/TIMB/DBI_Adv

RE: [sqlite] What does this mean???

ehalf Of P Kishor Sent: Wednesday, February 07, 2007 6:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 2/7/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Context :) > > insert or replace into TMP_credDerivOrig > select > A.date, .. &g

RE: [sqlite] What does this mean???

; on $sth->execute is bound to be nasty to diagnose. FWIW, it looks like "not an error" is the result of a call to sqlite3_errmsg(). Unrelated to your issue is a DBI presentation you may be interested to look through at http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index

RE: [sqlite] What does this mean???

ailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, February 07, 2007 6:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 2/7/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Context :) > > insert or replace into TMP_cred

RE: [sqlite] What does this mean???

Clark - Original Message From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, February 7, 2007 2:33:21 PM Subject: [sqlite] What does this mean??? not an error(21) at dbdimp.c line 398 I'm using DBD::SQLite and got this e

RE: [sqlite] What does this mean???

affected: 566606 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, February 07, 2007 5:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] What does this mean??? On 2/7/07, Anderson, James H (IT) <[EMAIL PROTECTED]>

[sqlite] What does this mean???

not an error(21) at dbdimp.c line 398 I'm using DBD::SQLite and got this error. What does it mean and how best to hanle it? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive

RE: [sqlite] Another sybase conversion question

Thanks, Joe! That looks like it might be the solution. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question --- "Anderson, James H (IT)&quo

RE: [sqlite] Another sybase conversion question

. -Original Message- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 6:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another sybase conversion question On Fri, 2 Feb 2007, Anderson, James H (IT) wrote: > The following works fine in sybase, but beca

[sqlite] Another sybase conversion question

The following works fine in sybase, but because in sqlite "update" does not support "from" it doesn't work. Is there another way of doing this? Thanks, Jim update C1_credDerivEvent set CDEvent = a.CDEvent || ',' || b.CDEvent from C1_credDerivEvent a, C1_tmp_credDerivEvent b,

RE: [sqlite] "select into" ?

Perfect! Thanks. -Original Message- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 5:28 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "select into" ? Anderson, James H (IT) wrote: > Sybase supports "select into" but sqllite d

RE: [sqlite] "select into" ?

t; ? > - Original Message - > From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> > > Sybase supports "select into" but sqllite does not seem to. Here's a > sybase example: > > select distinct CDId, CDEvent > into credDerivEvent > f

[sqlite] "select into" ?

Sybase supports "select into" but sqllite does not seem to. Here's a sybase example: select distinct CDId, CDEvent into credDerivEvent from credDerivOrig This query creates the table credDerivEvent. Is there anythin comparable in sqlite? Thanks, jim

RE: [sqlite] Function question

That's an interesting idea, thanks, Kees. -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question Hi Jim, On Thu, 1 Feb 2007 09:08:44 -0500, you wrote: >From the CLP

RE: [sqlite] Function question

OK, thanks. -Original Message- From: Nemanja Corlija [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > Does the fact that I have

RE: [sqlite] Function question

Does the fact that I have received no reply mean that there's no way to get this functionality within the CLP? -Original Message- From: Anderson, James H (IT) Sent: Thursday, February 01, 2007 9:09 AM To: sqlite-users@sqlite.org Subject: [sqlite] Function question >From the CLP (

[sqlite] Function question

>From the CLP (i.e., w/o user-defined functions) is there any way to get the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim spaces from the right/left end of a column value.) jim NOTICE: If received in error, please

RE: [sqlite] Equivalent syntax?

Thanks. Unfortunately my background is sybase and that's anything but standard :-( -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:52 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, 31 Jan 2007 17:30:29

RE: [sqlite] Equivalent syntax?

Thanks, somehow I had missed it. -Original Message- From: Nicolas Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, Jan 31, 2007 at 06:31:20PM -0500, Anderson, James H (IT) wrote

[sqlite] What is the sqlite concatenation operator?

Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.

RE: [sqlite] Equivalent syntax?

Is cast documented on the sqlite website? I couldn't find it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EM

RE: [sqlite] Equivalent syntax?

Experimenting :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > In the case

RE: [sqlite] Equivalent syntax?

OK, thanks, I'll try that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, January 31, 2007 5:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On 1/31/07, Anderson, James H (IT) <[EMAIL PROTEC

RE: [sqlite] Equivalent syntax?

] Equivalent syntax? Anderson, James H (IT) wrote: > What's the equivalent sqlite syntax for sybase convert function? For > example, > > select distinct > date, CDId, CDName, CDTicket, > tradeId, tapsAccount, CDBook, coalesce(CDFid,'') CDFid, > CDStatus, C

RE: [sqlite] Equivalent syntax?

@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > What's the equivalent sqlite syntax for sybase convert function? Can you describe what the convert function in sybase does? That might help us to find the equivalent functio

[sqlite] Equivalent syntax?

What's the equivalent sqlite syntax for sybase convert function? For example, select distinct date, CDId, CDName, CDTicket, tradeId, tapsAccount, CDBook, coalesce(CDFid,'') CDFid, CDStatus, CDTradeDate, CDExpDate, CDNotional, CDCurr, CDSellBuy, CDType, CDExerType,

[sqlite] Where can I find doc on user defined types?

Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.

RE: [sqlite] Another (possibly dumb) question

Thanks. -Original Message- From: Ralf Junker [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 11:37 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Another (possibly dumb) question >For select, update, insert, or delete is there a way to get the number >of rows

[sqlite] Another (possibly dumb) question

For select, update, insert, or delete is there a way to get the number of rows affected? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this

RE: [sqlite] How to conditionally drop a table?

: [sqlite] How to conditionally drop a table? On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? > > Thanks, Are you asking if http://sqlite.org/lang_droptable.html works or have you had pro

[sqlite] How to conditionally drop a table?

I need a way to drop a table only if that table exists. How would I do that? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is

RE: [sqlite] date - SQL extraction from day, month and year

/readme_sqlite_tutorial.html A quick glance through the date.c file in the Sqlite distribution is all you needed to understand the extent and rationale behind the Sqlite date support. You can also use the code there as a template to create your own user functions for more detailed date manipulation. Anderson, James H

RE: [sqlite] date - SQL extraction from day, month and year

Where are the date support functions documented? -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 26, 2006 12:40 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] date - SQL extraction from day, month and year Everybody? Most Sqlite users know

RE: [sqlite] Is there a method for doing bulk insertion?

issue .separator ':' use an editor to change the existing separator character(s) to the character you want to use. On Tue, 19 Dec 2006, Anderson, James H (IT) wrote: > So I can assume that there's no way to use a delimiter other than a > comma to import a CSV file? > > -Orig

RE: [sqlite] Is there a method for doing bulk insertion?

you need... Jeff - Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, December 19, 2006 2:52 PM Subject: RE: [sqlite] Is there a method for doing bulk insertion? So I can assume that there's no way to us

RE: [sqlite] Is there a method for doing bulk insertion?

insertion? .help pretty well sums it up. On Tue, 19 Dec 2006, Anderson, James H (IT) wrote: > How do I find doc on .import? > > Is there a way to specify the delimiter for the CSV file? > > Thanks, > > jim > > -Original Message- > From: [EMAIL PROTECTED] [ma

RE: [sqlite] Is there a method for doing bulk insertion?

for doing bulk insertion? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > or do I have to creation a gazillion insert statements? > The sqlite3 command-line shell has a ".import" command which can be used to read CSV data. But the way this works internall

RE: [sqlite] Is there a method for doing bulk insertion?

Thanks. -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 8:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion? On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: > I w

RE: [sqlite] Is there a method for doing bulk insertion?

: Monday, December 18, 2006 9:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a method for doing bulk insertion? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > or do I have to creation a gazillion insert statements? > The sqlite3 command-lin

[sqlite] Is there a method for doing bulk insertion?

...or do I have to creation a gazillion insert statements? Thanks, jim NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when