I have localized the source of my problem.
Macromedia Ultradev is JSP 1.0
The previous version of Tomcat I was running was also JSP 1.0. The
escaping of single quotes in sql queries was handles automagically.
Moving to Tomcat 3.2 and Tomcat 4.x I am now running a JSP 1.1 or 1.2
container. Now the escaping seems to be handled by a jakarta taglib. The
other solution seems to be - manually modify the JSP source to put "
around the insert statements.
Cheers
Tony Grant
--