How To resolve this ERROR "A potentially dangerous Request.Form value was detected from the client "in ms sql
Hi!
I'm Using sql server 2000,
I've table entries like this
id Amount TransactionType Balance DateOfCreation
1 50 1 50 7/15/2010 11:39:00 AM
2 50 1 100 7/15/2010 11:50:00 AM
if suppose the current date is 7/16/2010 11:38:00 AM,
Now i want sum of the amount added in the table from past 24 hours....
so,
I've written query like this
declare @Amount decimal
set @Amount =(select sum(Amount) from tblCompMb
where DateOfCreation>(dateadd(d,-1,getdate())) and DateOfCreation<getdate() and TransactionType=1)
select @Amount as Yester_Day_Amount
I'm just getting the current date and the yesterday date of the current date ,and adding all the amount between that date By using < and > symbol
It Works reall fine But When I'm trying to run this procedure in MS SQL server, It gives the ERROR Like this
"A potentially dangerous Request.Form value was detected from the client "
Is there any way to overcome this problem???
Please help me out...Its so urgent....