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: 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 currently active.

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 doing

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 currently

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

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 |

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:20Anthony Scism : I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time

Re: need help with select statement

: 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 statement Hi Antony, Eventually key is a reserved word

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: 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

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 a

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;

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 possible but you can just read in all tables anyway and ignore t