Hi André, I'm not sure this does concern Velocity: - '&' has no special meaning in sql : it's a specificity of sqlplus - interpreting ampersands from inside comments looks like a sqlplus bug
You can always write your own specialization of the EscapeSqlReference filter to work around this sqlplus bug, it shouldn't be that hard. Regards, Claude Brisson On ven, 2009-04-24 at 13:14 +0200, mumu wrote: > Hello > > When using sql filter, the ' are replace with '' . > > But there is little problem, when using "&" in the field. Perhaps it's not a > bug. > > Nevertheless, when you add a sqlMyField "-- youger & older people", the & is > considerer a prompt for a value. > We can says that's the problem come from sqlplus, but as it widely use, > perhaps il should be filtered too ? > > eventhandler.referenceinsertion.class = > org.apache.velocity.app.event.implement.EscapeSqlReference > eventhandler.escape.sql.match = /sql.*/ > > André. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@velocity.apache.org For additional commands, e-mail: dev-h...@velocity.apache.org