Re: [sqlite] Fwd: column name as a value in a tuple - headache!

2005-11-06 Thread Bjørn Eikeland
On 11/6/05, Puneet Kishor <[EMAIL PROTECTED]> wrote: > > On Nov 6, 2005, at 8:19 AM, Bjørn Eikeland wrote: > > > Two columns, 'rr' and 'slag', 'rr' contains precipitation and 'slag' > > contains the type of precipitation as a two letter code. RR (capital) > > is the code for rain, but any and all

Re: [sqlite] Fwd: column name as a value in a tuple - headache!

2005-11-06 Thread Puneet Kishor
On Nov 6, 2005, at 8:19 AM, Bjørn Eikeland wrote: Two columns, 'rr' and 'slag', 'rr' contains precipitation and 'slag' contains the type of precipitation as a two letter code. RR (capital) is the code for rain, but any and all select statemens includeing WHERE slag="RR" fails as it thinks I'm

Re: [sqlite] Fwd: column name as a value in a tuple - headache!

2005-11-06 Thread Guillaume MAISON
Bjørn Eikeland a écrit : I've been using sqlite to ease making statistical graphs from metrological data and have encountered a strange problem. Two columns, 'rr' and 'slag', 'rr' contains precipitation and 'slag' contains the type of precipitation as a two letter code. RR (capital) is the code

[sqlite] Fwd: column name as a value in a tuple - headache!

2005-11-06 Thread Bjørn Eikeland
I've been using sqlite to ease making statistical graphs from metrological data and have encountered a strange problem. Two columns, 'rr' and 'slag', 'rr' contains precipitation and 'slag' contains the type of precipitation as a two letter code. RR (capital) is the code for rain, but any and all