RE: single Quotes in SQL

2002-05-16 Thread James Mitchell
Not sure if you got the answer to this. single quotes should be changed to double single quotes (not " but '') JM > -Original Message- > From: Shawn Bayern [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 5:19 PM > To: Tag Libraries Users List &

Re: single Quotes in SQL

2002-05-16 Thread Shawn Bayern
On Thu, 16 May 2002, DAVE ANAND wrote: > How you handle single Quotes in the sql stmt inside > an sql tag. It's best to use PreparedStatement behind the scenes. For instance, you can use JSTL's tag inside a tag: select * from users where last_name=? Of course, 'value' can po