Re: Help with SELECT statement for date range

Hi, try this: SELECT * FROM your_table WHERE StartDate > NOW() AND EndDate < NOW() > Hello, > > I am having a problem when doing a SELECT. Here is the > scenerio: > > I have a table that has an event StartDate and > EndDate, based on the current Date "NOW()" I need to > know which records are

RE: Help with SELECT statement for date range

SELECT * FROM table_name WHERE EndDate < now(); Is this what you need? -Original Message- From: Rob Sirota [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 4:12 AM To: [EMAIL PROTECTED] Subject: Help with SELECT statement for date range Hello, I am having a problem when do

Re: Help with SELECT statement for date range

On Tue, 19 Aug 2003 04:11:32 -0700 (PDT) Rob Sirota <[EMAIL PROTECTED]> wrote: > Hello, > > I am having a problem when doing a SELECT. Here is the > scenerio: > > I have a table that has an event StartDate and > EndDate, based on the current Date "NOW()" I need to > know which records are curren

Help with SELECT statement for date range

Hello, I am having a problem when doing a SELECT. Here is the scenerio: I have a table that has an event StartDate and EndDate, based on the current Date "NOW()" I need to know which records are currently active. Can anyone help with a quick SELECT statement? Thanks. = ___

Re: need help with select statement

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

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

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

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: more help with SELECT statement

>Hi, > > >A few days ago, I asked the list about a SELECT statement. I >received 2 replies that didn't really work but helped me think about >the problem some more. In my database I have 4 tables. For this one >query, I am matching up data from 3 of these tables and then >displaying them on a

more help with SELECT statement

Hi, A few days ago, I asked the list about a SELECT statement. I received 2 replies that didn't really work but helped me think about the problem some more. In my database I have 4 tables. For this one query, I am matching up data from 3 of these tables and then displaying them on a website.

Re: Help with SELECT statement.

SELECT request.id, request.date, request.type, request.status, faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON action.request_id=request.id; Chris Toth <[EMAIL PROTECTED]> wrote: I'm trying to form

Help with SELECT statement.

I'm trying to form a select statement that will match up all relevent data from a database for a trouble-ticket system. The select statement below is the only way I can figure out how to do it. However, the last line " AND action.request_id=request.id" worries me, because what if there are no

Re: Need help with select statement.

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.

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.

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