> Try this (tested on a CVSNT repo audited by MSSQL Server, but the > command should be almost identical: > > SELECT Command, [Date], Username, Hostname, VirtRepos > FROM SessionLog > WHERE > (Command='update' OR Command='checkout') > AND ([Date] > '2006-01-05') > AND ([Date] < '2006-02-01') > > Notice the brackets surrounding Date, needed on MSSQL since Date is a > reserved word and here is also defining a column name.
I think that we changed column name that in CVSNT 2.5.04, so that SQL is probably for 2.5.03.2382? Regards, Arthur _______________________________________________ cvsnt mailing list cvsnt@cvsnt.org http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt Upgrade to CVS Suite for more features and support: http://march-hare.com/cvsnt/
