Re: need help with select statement

2003-07-08 Thread Paul DuBois
At 4:20 -0500 7/7/03, Anthony Scism wrote: I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL

Re: need help with select statement

2003-07-07 Thread Nils Valentin
Scism さんは書きました: > Thank you very much, I should have thought of that. > > -Original Message- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 4:34 AM > To: Anthony Scism; [EMAIL PROTECTED] > Subject: Re: need help with select stat

Re: need help with select statement

2003-07-07 Thread Nils Valentin
Hi Antony, Eventually "key" is a reserved word ?? ;-) nice one !! Best regards Nils Valentin Tokyo/Japan 2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました: > I am relatively new at this, but is there any way to perform the > > following: > | obs_date | date | YES | | NULL

need help with select statement

2003-07-07 Thread Anthony Scism
I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL | | | observing_site | varchar(40)

Re: Need help with select statement.

2001-02-26 Thread David Jacobowitz
Thanks Rolf >From: "Rolf Hopkins" <[EMAIL PROTECTED]> >To: "David Jacobowitz" <[EMAIL PROTECTED]>, ><[EMAIL PROTECTED]> >Subject: Re: Need help with select statement. >Date: Tue, 27 Feb 2001 09:21:57 +0800 > >No it's not pos

Re: Need help with select statement.

2001-02-26 Thread Rolf Hopkins
No it's not possible but you can just read in all tables anyway and ignore the columns you don't want. - Original Message - From: "David Jacobowitz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 7:33 Subject: Need help wit

Need help with select statement.

2001-02-26 Thread David Jacobowitz
Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest; I