check search item for symbols
Posted on 2003-10-29
hi guys need ur help....
well, when the user type in other unnesscary symbols like @##$% or watever..
the system will juz replied "no record Found"
however when the user put in ' this symbol..the system will generate an error..
this could be due to the fact that i am using asp for sql query for the search thingy...
i tried using the codes below...but it will alert the error msg when the user click the mouse on other area..however if the system type enter instead...the error will come out again...
how can i solve this thing?
if (string.indexOf("'")==1 )
alert("Please do not use invalid symbols!")