hi,
I am creating a jsp app which will add some data to mysql tables.. Now if we enter some characters like single quote(') it will create error while inserting/updating the db..
I would like to know what can i do for that.. Also what all characters like single quotes can create problem in updation of db..
thanks

single quote is the only problem

replace each single quote in the text with two consecutive single quotes

e.g. to insert the name O'Toole,

insert into names (name) values ( 'O''Toole' )

thanks buddy

It is good practice, anytime you update or insert strings into a SQL database, to pass the values through a function that handles the quotes. Example, in ASP I do something this:

function f_SafeQuotes(inputstring)
f_SafeQuotes = replace(inputstring," ' ", " '' ")
end function

...

conn.execute "insert into test (ID,name) values (1," & f_SafeQuotes(namevar) & ")"

that is a good idea.. infact now i am doing the same.. thanks