While we're on a roll here...
I'd like to count today's posts - I've used "SELECT COUNT (*) FROM post WHERE postdate='" & Date() & "'" "SELECT COUNT (*) FROM post WHERE postdate=#" & Date() & "#" "SELECT COUNT (*) FROM post WHERE postdate='#" & Date() & "#'" then I tried output these ways GetTodaysPosts=conn.execute(SQL) response.write GetTodaysPosts(0) SELECT COUNT (*) FROM post as todaysposts WHERE postdate='#" & Date() & "#'" response.write todaysposts It's either 0 or blank. Dare I ask for help again? --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
