Re: [sqlite] Help with syntax

To: General Discussion of SQLite Database Sent: Tuesday, May 20, 2008 9:04:42 AM Subject: Re: [sqlite] Help with syntax Hi Carlo, > Well those original instructions are correct, as long as you unsmarten > the the quotes, so it reads: > > sqlite /var/local/database/dblist "insert

Re: [sqlite] Help with syntax

Hi Carlo, > Well those original instructions are correct, as long as you unsmarten > the the quotes, so it reads: > > sqlite /var/local/database/dblist "insert into list > (owner,behavior,entry) values(0,0,'newblacklistentry.com') " I should clarify that I meant the syntax of your original instru

Re: [sqlite] Help with syntax

From: BareFeet <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Tuesday, May 20, 2008 8:37:37 AM Subject: Re: [sqlite] Help with syntax Well those original instructions are correct, as long as you unsmarten

Re: [sqlite] Help with syntax

Hi Carlo, > Here are the instructions given me > You can add entries with inserts from the command line. You should > be able to do it like this: > > sqlite /var/local/database/dblist “insert into list > (owner,behavior,entry) values(0,0,’newblacklistentry.com’) ” Well those original instru

Re: [sqlite] Help with syntax

To: sqlite-users@sqlite.org Sent: Tuesday, May 20, 2008 7:27:08 AM Subject: Re: [sqlite] Help with syntax Carlo S. Marcelo <[EMAIL PROTECTED]> wrote: > Below is the syntax and error I received. > > [EMAIL PROTECTED] root]# sqlite > /var/local/database/dblist "insert into >

Re: [sqlite] Help with syntax

Carlo S. Marcelo <[EMAIL PROTECTED]> wrote: > Below is the syntax and error I received. > > [EMAIL PROTECTED] root]# sqlite > /var/local/database/dblist "insert into > list ('0,0,newblacklistentry1,com') values > ('0,0,newblacklistentry1.com')" > SQL error: table list has no column named > 0,0,newb

Re: [sqlite] Help with syntax

Hi Carlo, > insert into list ('0,0,newblacklistentry1,com') > values ('0,0,newblacklistentry1.com')" > SQL error: table list has no column named 0,0,newblacklistentry1,com Well, the error tells you the problem. You are asking SQLite to insert a text value '0,0,newblacklistentry1.com' into a co

[sqlite] Help with syntax

Hi! I just subscribed to the mailing list as my work now requires some sqlite stuff. Below is the syntax and error I received. [EMAIL PROTECTED] root]# sqlite /var/local/database/dblist "insert into list ('0,0,newblacklistentry1,com') values ('0,0,newblacklistentry1.com')" SQL error: table lis

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 query

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

Re: [sqlite] help with syntax

Anderson, James H (IT) wrote: 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,

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