Not sure this is a MySQL problem or an ASP issue so apologies if it's OT. Code in ASP Page :
Dim intWeekID objRSWeekID.open "SELECT WeekID FROM WeekControl " & _ " WHERE WeekStart < NOW() AND WeekEnd > NOW()", objConn intWeekID = objRSWeekID("WeekID") This fails to bring back a value for WeekID. Data exists as : WeekStart 2002-05-13 00:00:01 WeekEnd 2002-05-19 23:59:59 When I run the code through MySQLAdmin like thus : SELECT WeekID FROM WeekControl WHERE WeekStart < NOW() AND WeekEnd > NOW() I get the correct result. Using Chilisoft ASP. Any suggestions? Thanks. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php