Re: [sqlite] Help with syntax

eneral Discussion of SQLite Database <sqlite-users@sqlite.org> 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

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

Re: [sqlite] Help with syntax

From: BareFeet <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, May 20, 2008 8:37:37 AM Subject: Re: [sqlite] Help with syntax Well those original instructions are corr

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

Re: [sqlite] Help with syntax

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

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 >

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

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

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,