Hi everybody,
I am having problem with this query
I am using Access database and asp.net c# 2.0 to reterieve things using this
query
select count(*) as itemTotal from schoolitemmap
where (schoolid =1 and OrderDate = 8/3/2009) and itemId = 1
this query does not return nything.
(this date used in query is in m/d/y format as a
string)
and m using date() function as default value for OrderDate field in database
which is also in format (m/d/y)
Plase help .......
Thanks