Keeping quotes from column in my table?

[Moined Mogul]

Does anyone know how I could ensure that quotes were never permitted to be added into my database table where the input is coming from user input in a JSP???

[Jamie Robertson]

can you not just check for a quote in the String before you insert into the database?

int i = str.indexOf("\"");  //find quote in String str
if (i != -1)                //quotation found
{
//error routine
}
else
{
//insert into database
}

Jamie

[This message has been edited by Jamie Robertson (edited August 08, 2001).]