[thelist] SQL, Dates and more mental health

Ryan Mayberry Ryan at applicor.com
Tue Apr 3 14:39:59 CDT 2001

I tried that already... Doesn't work in the SQL statement, but I can open
all records from the database and use the same logic to loop through the
recordset and then it works perfectly. Except I have to do it in the SQL


-----Original Message-----
From: Scott Dexter [mailto:sgd at ti3.com]
Sent: Tuesday, April 03, 2001 2:31 PM
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] SQL, Dates and more mental health

I use 

Where (view_date>=dteEvStart and view_date<dteEvEnd)

instead of the between phrase, try that?

work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Ryan Mayberry [mailto:Ryan at applicor.com]
> SELECT * FROM tblEvents WHERE view_date BETWEEN dteEvStart 
> AND dteEvEnd

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

More information about the thelist mailing list