Re: [sqlite] Newbie what does & do.

2009-03-28 Thread Kees Nuyt
On Sat, 28 Mar 2009 09:42:59 +, Dermot wrote: >2009/3/28 Jay A. Kreibich : >> On Fri, Mar 27, 2009 at 05:37:49PM +, Dermot scratched on the wall: >> >>> The statement is: >>> >>> SELECT COUNT(*) FROM products WHERE productid=808800033 AND >>>

Re: [sqlite] Newbie what does & do.

2009-03-28 Thread Dermot
2009/3/28 Jay A. Kreibich : > On Fri, Mar 27, 2009 at 05:37:49PM +, Dermot scratched on the wall: > >> The statement is: >> >> SELECT COUNT(*) FROM products WHERE productid=808800033 AND >> (allowcountry2 & 0x0001) >> SELECT COUNT(*) FROM products WHERE

Re: [sqlite] Newbie what does & do.

2009-03-27 Thread Jay A. Kreibich
On Fri, Mar 27, 2009 at 05:37:49PM +, Dermot scratched on the wall: > The statement is: > > SELECT COUNT(*) FROM products WHERE productid=808800033 AND > (allowcountry2 & 0x0001) > SELECT COUNT(*) FROM products WHERE productid=808800033 AND > (allowcountry1 & 0x8000)

Re: [sqlite] Newbie what does & do.

2009-03-27 Thread John Machin
On 28/03/2009 4:37 AM, Dermot wrote: > Hi, > > I just bough my "Introduction to SQL 4th edition" as per a list > member's advice. > > Before I had a chance to take it home and start going through it I > came across an SQL statement that I could use some help understanding. > > The statement is:

[sqlite] Newbie what does & do.

2009-03-27 Thread Dermot
Hi, I just bough my "Introduction to SQL 4th edition" as per a list member's advice. Before I had a chance to take it home and start going through it I came across an SQL statement that I could use some help understanding. The statement is: SELECT COUNT(*) FROM products WHERE