Re: best practice for handling single/double quotes, html characters, sql injection/poisoning

2004-08-25 Thread Woodchuck
hi Craig!! yup, i am using prepared statements and it safely handles the single/double quotes beautifully. i guess i still have to filter out sql constructs/keywords/statements myself before passing the data to my prepared statement objects. do you mean that instead of doing this: i do this i

Re: best practice for handling single/double quotes, html characters, sql injection/poisoning

2004-08-25 Thread Craig McClanahan
For embedded quotes, use JDBC prepared statements ... they take care of any escaping that is necessary for you. For embedded HTML, use Struts tags like to render the dynamic output to your page -- unless you tell them not to (filter="false"), any sensitive characters in HTML will be automatically

RE: best practice for handling single/double quotes, html characters, sql injection/poisoning

2004-08-25 Thread Woodchuck
--- Jim Barrows <[EMAIL PROTECTED]> wrote: > > > > -Original Message- > > From: Woodchuck [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 25, 2004 9:44 AM > > To: struts > > Subject: best practice for handling single/double quotes, html > > characters, sql injection/poisoning > >

RE: best practice for handling single/double quotes, html characters, sql injection/poisoning

2004-08-25 Thread Jim Barrows
> -Original Message- > From: Woodchuck [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 25, 2004 9:44 AM > To: struts > Subject: best practice for handling single/double quotes, html > characters, sql injection/poisoning > > > hihi, > > does struts or jstl have a good way to handle