1
Reply

How To resolve this ERROR "A potentially dangerous Request.Form value was detected from the client "in ms sql

syed afroz

syed afroz

Aug 9 2010 4:15 AM
3.4k
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....

Answers (1)