Re: [sqlite] select %column% from table

Thank you all, I am amazed by both the generousity and the intelligent solutions by everyone. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select %column% from table

On Fri, Apr 30, 2010 at 07:57:05AM -0700, David Lyon wrote: > if I had many many files like this: > http://research.stowers-institute.org/efg/ScientificSoftware/Utility/FCSExtract/CC4_067_BM.txt > > you see 2 columns keyword and value, the keywords would be the fields > (1st column in the html

Re: [sqlite] select %column% from table

On 30 Apr 2010, at 3:57pm, David Lyon wrote: > if I had many many files like this: > http://research.stowers-institute.org/efg/ScientificSoftware/Utility/FCSExtract/CC4_067_BM.txt > > you see 2 columns keyword and value, the keywords would be the fields (1st > column in the html link above)

Re: [sqlite] select %column% from table

>> >> >> >> >> >> >> >> >> >> - Original Message >> From: P Kishor <punk.k...@gmail.com> >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> Sent: Fri, April 30, 2010 10:

Re: [sqlite] select %column% from table

> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Fri, April 30, 2010 10:48:41 AM > Subject: Re: [sqlite] select %column% from table > > crap! I completely misunderstood your question... be confused, and > then ignore my reply. > > On Fri, Apr 3

Re: [sqlite] select %column% from table

t; > etc. > > thats why I wanted a quick way to access "select P%R from TABLE"; > > > thanks again > > > > > > > > > > > > > > - Original Message > From: P Kishor <punk.k...@gmail.com> > To: General Discussion

Re: [sqlite] select %column% from table

/2010 9:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] select %column% from table Thanks for everyones efforts let me expand: if I had many many files like this: http://research.stowers-institute.org/efg/ScientificSoftware/Utility/FCSExtract/CC4_067_BM.txt you see 2 columns

Re: [sqlite] select %column% from table

> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Fri, April 30, 2010 10:48:41 AM Subject: Re: [sqlite] select %column% from table crap! I completely misunderstood your question... be confused, and then ignore my reply. On Fri, Apr 30, 2010 at 9:43 AM, P Kishor <p

Re: [sqlite] select %column% from table

crap! I completely misunderstood your question... be confused, and then ignore my reply. On Fri, Apr 30, 2010 at 9:43 AM, P Kishor wrote: > On Fri, Apr 30, 2010 at 9:28 AM, David Lyon wrote: >> If I had a table called TABLE with fields P1N..P50N

Re: [sqlite] select %column% from table

On Fri, Apr 30, 2010 at 07:28:52AM -0700, David Lyon scratched on the wall: > If I had a table called TABLE with fields P1N..P50N is there a way > to select something like: > > "select P%N from TABLE" SELECT * FROM... > to return all the results from columns P1N..P50N or do I have >

Re: [sqlite] select %column% from table

On Fri, Apr 30, 2010 at 9:28 AM, David Lyon wrote: > If I had a table called TABLE with fields P1N..P50N is there a way to > select something like: > > "select P%N from TABLE" > >  to return all the results from columns P1N..P50N or do I have to do it > manually:

Re: [sqlite] select %column% from table

You have to do it manually. Or reconsider your database schema towards normalization. Pavel On Fri, Apr 30, 2010 at 10:28 AM, David Lyon wrote: > If I had a table called TABLE with fields P1N..P50N is there a way to > select something like: > > "select P%N from

[sqlite] select %column% from table

If I had a table called TABLE with fields P1N..P50N is there a way to select something like: "select P%N from TABLE" to return all the results from columns P1N..P50N or do I have to do it manually: "select P1N, P2N, P3N, P$nN from TABLE" I can obviously do it via scripting but