[sqlalchemy] Re: Select entire column

2007-11-07 Thread JamesT
Thanks. I have it working in SQL expression language, using text in execute(). For better modularity and scalabililty, I will probably move it over to using the select(), join(), etc. functions that are built in. On Nov 7, 5:26 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote: > One of the reasons t

[sqlalchemy] Re: Select entire column

2007-11-07 Thread JamesT
you want? > > select([my_table.c.my_column], distinct=True) > > Barry > > - Original Message > From: JamesT <[EMAIL PROTECTED]> > To: sqlalchemy > Sent: Wednesday, November 7, 2007 2:05:13 AM > Subject: [sqlalchemy] Select entire column > > I am l

[sqlalchemy] Select entire column

2007-11-06 Thread JamesT
I am looking to filter specific columns in a table, but I cannot find how to do this. I can filter by setting these columns to a value, but not just grabbing the entire column. In SQL, I want to do this: "SELECT artist FROM artist_table", where the only column kept is artist. The reason I want to