Re: [sqlite] Getting a list of items on a column

Thanks. - Original Message - From: "C.Peachment" <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 9:40 PM Subject: Re: [sqlite] Getting a list of items on a column On Sat, 5 May 2007 21:03:27 -0400, jose isaias cabrera wrote: Ok, I am going to push

Re: [sqlite] Getting a list of items on a column

Thanks. Yes, that works. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 9:37 PM Subject: Re: [sqlite] Getting a list of items on a column "jose isaias cabrera" <[EMAIL PROTECTED]> writes: "C.Peachment" wrote, On Sat,

Re: [sqlite] Getting a list of items on a column

On Sat, 5 May 2007 21:03:27 -0400, jose isaias cabrera wrote: >Ok, I am going to push my luck. :-) Imagine the same data, what if I >wanted to get the sum of the other two columns also? I know how to do it >one at a time, so in this instance I would have to do 3 separate call using >sum or

Re: [sqlite] Getting a list of items on a column

"jose isaias cabrera" <[EMAIL PROTECTED]> writes: > "C.Peachment" wrote, > > >> On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: >> >> >>>Greetings! >> >>>imagine this data content, >> >>>c1, c2, c3 >>>a, 1, 2 >>>b, 3, 4 >>>c, 5, 6 >>>a, 9, 8 >>>a, 1, 9 >>>c, 1, 3 >> >>> I would like

Re: [sqlite] Getting a list of items on a column

"C.Peachment" wrote, On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: Greetings! imagine this data content, c1, c2, c3 a, 1, 2 b, 3, 4 c, 5, 6 a, 9, 8 a, 1, 9 c, 1, 3 I would like to get a list of all the items in c1. So, the return would be, a, b, c I know how

Re: [sqlite] Getting a list of items on a column

On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: >Greetings! >imagine this data content, >c1, c1, c3 >a, 1, 2 >b, 3, 4 >c, 5, 6 >a, 9, 8 >a, 1, 9 >c, 1, 3 >I would like to get a list of all the items in c1. So, the return would be, >a, >b, >c >I know how to do it