[sqlite] Fwd: Expression syntax

2012-05-01 Thread Pete
r 2012 12:03:59 -0500 > From: "Jay A. Kreibich" > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Fwd: Expression syntax > Message-ID: <20120430170359.gc45...@dfjk.org> > Content-Type: text/plain; charset=us-ascii > > On Mon, Apr 30, 2012 at 0

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Stephan Beal
On Mon, Apr 30, 2012 at 7:40 PM, Stephan Beal wrote: > "You cannot provide a table and column" > Ignore me, please - i'm confusing DB.TABLE with TABLE.COLUMN. Sorry about that. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Stephan Beal
On Mon, Apr 30, 2012 at 7:31 PM, Simon Slavin wrote: > >> column. You cannot provide a table and column, it must > >> be a single-column table. > >> > > I see no conflict with what Jay wrote. The diagram says that db.table is > allowed. Jay has said that this works, but only when the ta

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Simon Slavin
On 30 Apr 2012, at 6:19pm, Stephan Beal wrote: > On Mon, Apr 30, 2012 at 7:03 PM, Jay A. Kreibich wrote: > >>> option to specify database.tablename as the right operand. What does >>> database.tablename evaluate to? >> >> column. You cannot provide a table and column, it must > > be

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Stephan Beal
On Mon, Apr 30, 2012 at 7:03 PM, Jay A. Kreibich wrote: > > option to specify database.tablename as the right operand. What does > > database.tablename evaluate to? > > column. You cannot provide a table and column, it must be a single-column table. > That seems to conflict with the

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Jay A. Kreibich
On Mon, Apr 30, 2012 at 09:50:34AM -0700, Pete scratched on the wall: > Anyone? > > -- Forwarded message -- > From: Pete > Date: Thu, Apr 26, 2012 at 10:55 AM > Subject: Expression syntax > To: sqlite-users@sqlite.org > > > The syntax diagram for an expression using the IN/NOT I

Re: [sqlite] Fwd: Expression syntax

2012-04-30 Thread Luuk
On 30-04-2012 18:50, Pete wrote: > Anyone? > > -- Forwarded message -- > From: Pete > Date: Thu, Apr 26, 2012 at 10:55 AM > Subject: Expression syntax > To: sqlite-users@sqlite.org > > > The syntax diagram for an expression using the IN/NOT IN operators shows an > option to spec

Re: [sqlite] sqlite] Fwd: Expression syntax

2012-04-30 Thread Black, Michael (IS)
of SQLite Database Subject: EXT :[sqlite] Fwd: Expression syntax Anyone? -- Forwarded message -- From: Pete Date: Thu, Apr 26, 2012 at 10:55 AM Subject: Expression syntax To: sqlite-users@sqlite.org The syntax diagram for an expression using the IN/NOT IN operators

[sqlite] Fwd: Expression syntax

2012-04-30 Thread Pete
Anyone? -- Forwarded message -- From: Pete Date: Thu, Apr 26, 2012 at 10:55 AM Subject: Expression syntax To: sqlite-users@sqlite.org The syntax diagram for an expression using the IN/NOT IN operators shows an option to specify database.tablename as the right operand. What does