Select?

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Professional
Select?

Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

July 2nd, 2007, 05:36 AM

mikedeepak mikedeepak is offline

Authorized User

Join Date: May 2004

Posts: 66

Thanks: 0

Thanked 0 Times in 0 Posts

Select?

Hi all,
I have doubt in Selecting records from the Table is as

tblName

ID int
Name varchar(100)
stdate datetime
endate datetime

Now i need to retrive Name from the table by following condtion

if the Start Date is 08/01/07 and the End Date is 09/01/07 the records should be selected from the table on 08/01/07 at 12:00:01AM and should not be selected on 09/01/07 at 11:59:59 PM

Please post ur thoughts/answers.....

Mike

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select row in GridView WITHOUT using Select button	rao965	ASP.NET 2.0 Professional	1	February 15th, 2008 10:44 AM
Select from another select statement to a repeater	simsen	ASP.NET 2.0 Professional	0	May 2nd, 2007 04:34 PM
Fill select box and select recordset value	markd	Classic ASP Databases	1	February 20th, 2006 06:41 PM
select="node1", select="node2"...	Baldo	XSLT	7	March 12th, 2004 10:38 AM
Select Within A Select Problem	vinyl-junkie	Classic ASP Databases	6	June 7th, 2003 04:31 PM