TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
syed afroz
NA
54
0
How To resolve this ERROR "A potentially dangerous Request.Form value was detected from the client "in ms sql
Aug 9 2010 4:15 AM
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....
Reply
Answers (
1
)
SQL 2008 Text Search (FREETEXTTABLE, formsof, thesaurus )
how to find out last four characters using substring?