Using the regexp tag library I think it is still at version 1.0.
Because INSERT into tablename (field1) values ('I CAN'T DO THIS')
generates an error in SQL Server.
Karl
-----Original Message-----
From: Christopher Schultz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 12:03 PM
To: Tomcat Users List
Subject: Re: RegExp issues with Tomcat 5
Karl,
> We upgraded tomcat running one of our applications from 4 to 5 this
past =
> Friday, March 27th. Since, one of our regular expressions is not =
> functioning properly. Here is the expression:
>
> s/(\\|')/\\$1/g
>
> Instead of escaping the apostrophe with another apostrophe for SQL =
> purposes, it is replacing the apostrophe with the literal '$1'. It was
=
> working with Tomcat 4 and that is the only thing that has changed.
What regex library are you using? Tomcat shouldn't have anything in it
that would affect your regexs.
Not to open up too big of a can of worms, but if you're using JDBC, why
do you have to escape your own SQL statements?
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
