Fetching data from table

Jessica · February 20th, 2010, 10:04 PM

Hi,

I have a table consisting five columns Card No, Sdate, Edate, ATime, Etime

Now i want to get three columns info CardNo, Sdate, Edate from table. But i am facing problem when i get input from user to get their required info. For example user want to exact CRad name & his info from a specific Sdate to Edate.

Any effort will be appreciated .

Neobux · February 20th, 2010, 10:09 PM

Quote:

Originally Posted by Jessica

Hi,

I have a table consisting five columns Card No, Sdate, Edate, ATime, Etime

Now i want to get three columns info CardNo, Sdate, Edate from table. But i am facing problem when i get input from user to get their required info. For example user want to exact CRad name & his info from a specific Sdate to Edate.

Any effort will be appreciated .

Following might help.. If SDate and EDate are date type columns..

SELECT CardNo, SDate, EDate FROM table WHERE SDate > INPUT_DATE AND EDate < INPUT_DATE

Alternately better method is..

SELECT CardNo, SDate, EDate FROM table WHERE INPUT_DATE BETWEEN SDate AND EDate

February 20th, 2010, 10:04 PM	#1 (permalink)
Jessica TechSpott Newbie Join Date: Feb 2010 Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts	Fetching data from table Hi, I have a table consisting five columns Card No, Sdate, Edate, ATime, Etime Now i want to get three columns info CardNo, Sdate, Edate from table. But i am facing problem when i get input from user to get their required info. For example user want to exact CRad name & his info from a specific Sdate to Edate. Any effort will be appreciated .

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Sponsored links